Enterprise Resource Planning Blogs by Members
Gain new perspectives and knowledge about enterprise resource planning in blog posts from community members. Share your own comments and ERP insights today!
cancel
Showing results for 
Search instead for 
Did you mean: 
silambarasan_rajendran
Active Contributor

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.

Step 1:

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.

Step 2:

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.

Step 3:

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,

Silambu

6 Comments
Labels in this area