Problem with code

mkpjsr

Hi all,

I want to show the current inventory of items on Transfer Order form when the Item No is selected, so I have written the following code under OnValidate trigger of "Item NO" fileld:

globals i have used:
ItemRec->Record->Item
Inventory->Decimal

ItemRec.GET("Item No.");
// ItemRec.SETFILTER(ItemRec."Location Filter",'MAIN STORE');
ItemRec.CALCFIELDS(Inventory);
Inventory:=ItemRec.Inventory;

If the line contains one item then there is no issue but, if i am selecting another item then the value of inventory field is getting updated with the inventory of new item.

should i use array or something else to resolve this issue.

Can anybody suggest me the solution.

einsTeIn.NET

OnValidate of the table field or of the field control in the form?
Maybe you should move your code to the OnAfterGetRecord trigger of the (sub)form.

mkpjsr

einsTeIn.NET wrote:

OnValidate of the table field or of the field control in the form?
Maybe you should move your code to the OnAfterGetRecord trigger of the (sub)form.

thanx, its done

vijay_g

einsTeIn.NET wrote:

Maybe you should move your code to the OnAfterGetRecord trigger of the (sub)form.

The scene looking like you must have written your code on OnAfterGetRecord trigger because you have used a variable to show inventory. whether it will be better if you add a field in table and write code on validate trigger of item no.

einsTeIn.NET

vijay_g wrote:

whether it will be better if you add a field in table and write code on validate trigger of item no.

Yes, I think that would be a better solution, but I assumed that mkpjsr doesn't have access to the table design. That's why I said "maybe" and I asked for which OnValidate trigger.