hi
in baaniv ,I would like to import the beginning inventory of lot items using exchange module instead of using session ilc1120m000 "enter inventory transactions".
which tables should i import except for tdinv100 and tdilc102.



thanks :confused:

One of the best ways of importing inventory is through Cycle counting orders. In such cases the system stock would be "0" if the item is new and the physical stock can be entered. After completing all the records the cycle counting order can be processed and the inventory will be updated in Baan with the physical stock that was entered.

Try this!!!!

Regards,
John.

I think there are quite a few tables that would also need to be loaded(locations, warehouses, etc.). I think you will also need to update the item master for the quantity on hand. I would just check all the table references on the tables you know you need to load. What about Mauc?

One of the reasons I advocate using the inventory adjustment session or cycle count orders is so you do not have to do all this research. I do not know the tables good enough to give a list. This would also depend on what your setup is.

Good Luck!

Mark

hi jmathew
thanks for your reply,
but i had to import the beginning inventory data by text file, i want to use exchange module to do it ,i once use tiitm001,tiitm100,tdinv001 to import item data. anyone tell me if i want to use exchange moule to import inventroy data , which tables should i import

thanks

Hi,

You can use the exchange module and import data into the table "tdilc501" for cycle counting orders from the text file that is available. Then, just process the cycle counting orders and Baan will take care of updating the necessary tables which would be accurate than trying to update all tables through a script.

Hope this will be of help.

Regards,
John.

thanks jmathew, i will have a try.