Some of you might already know this but in case you don’t have…
Hereby explained : How to post inventory Opening Balance by using FMS.
It will ease your work and make work efficient and time saving.
Create one User Defined Table (UDT) with the columns ItemCode, WareHouse, Quantity and Price.
Most of the client prepare excel sheet. So you can import data from excel sheet to UDT.
Now make two FMS.
FMS 1: For Quantity,
SELECT Quantity FROM InventoryOB WHERE ItemCode=RTRIM(LTRIM($[$9.1.0]))
FMS 2: For Price,
SELECT Price FROM InventoryOB WHERE ItemCode=RTRIM(LTRIM($[$9.1.0]))
InventoryOB is the UDT.
Now set this FMS into Inventory Opening Balance Screen in Quantity and Price Columns.
We have to select ‘When Field Changes’ option in Auto Refresh and assign any one field for refresh.
Thats all. It will take time for getting value. It depends upon the number of items.
I hope this will help to our friends.
Thanks & Regards,