I need to import our Inventory, Bin, Customer and Suppliers data into MOM using dbuwin. Here is who I think it can be done.
I have exported the following tables in order to help me format our data: stock.dbf, bin.dbf, inventor.dbf, suppliers.dbf cust.dbf.
I'm probably going to import the stock information using the Import/Export module. I will be importing the Distrib and Diststock fields.
I believe that I can append the Supplier information into the directly in to the suppliers.dbf table without any trouble. With this import I believe Distrib fild from the stock.dbf must match the Code field in the suppliers.dbf. Am I correct?
With customers I think can be imported directly into the dbf if I'm not tacking any history with me. It also looks like customers can be imported via the import/export module?
When importing bin numbers would I have to create a relationship with the the BIN_ID field in the Inventor.dbf table and the BIN_ID in the bin Bin.dbf table. Also what is the purpose of the bin field in stock.dbf? I have set up some test items with test bins and that field is not populated. Also what exactly dose the inventor.dbf table do?
Importing of data
No replies to this topic
0 user(s) are reading this topic
0 members, 0 guests, 0 anonymous users