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
Started by
sblair
, Jan 24 2008 08:51 AM
No replies to this topic
0 user(s) are reading this topic
0 members, 0 guests, 0 anonymous users