I have added a field Inventory on the Purchase Line of my Purchase Order which check the Quantity for items per location defined.
I have added a Flowfield on the field Inventory on the table: Sum("Item Ledger Entry".Quantity WHERE (Item No.=FIELD(No.),Location Code=FIELD(Location Code)))..
For e.g: I have chosen Item A and Location Code Green which returns a Quantity of 2 in my Inventory field..
Now, I have change Location Code to White which has a zero quantity but it is giving 2 as quantity.
It is not being updated accordingly. I have to click on the Sales Header part for it to update.
How can I refresh the Quantity without clicking on the form?
Also I have used: CurrForm.UPDATECONTROLS on the Location Code- OnValidate