importing data into ABC

Message Topic Search Topic Options Post Reply Create New Topic Printable Version Translate Topic

   I've been testing out the free version to see if it fits our needs.
It is overkill for our use but the best I've seen.
We have two lists to import;
we have a master list from the supplier with:
part numbers, descriptions, cost price, retail price, suspersession part numbers

then we have our old inventory with:
part number, description, location, and up to four separate supersession part numbers

I think I can merge them by doing the Mfg. list first, the adding the local list that will match the "in stock" part number list with the master and overwrite it with our local information (correct?).

The problem I've having is getting the "quantities on hand" put into the system.
Using "ITEM MASTER LIST" to import my data does most of the work but is missing quantity and my supersession lists which are for my info only so they don't have to linked to anything, just shown.
Is there a way to do this?

Author	Message Topic Search Topic Options Post Reply Create New Topic Printable Version Translate Topic
rzimmer Members Profile Send Private Message Find Members Posts Add to Buddy List Newbie Joined: 23 Feb 2012 Points: 2	Post Options Post Reply Quote rzimmer Thanks(0) Quote Reply Topic: importing data into ABC Posted: 23 Feb 2012 at 10:23am
	I've been testing out the free version to see if it fits our needs. It is overkill for our use but the best I've seen. We have two lists to import; we have a master list from the supplier with: part numbers, descriptions, cost price, retail price, suspersession part numbers then we have our old inventory with: part number, description, location, and up to four separate supersession part numbers I think I can merge them by doing the Mfg. list first, the adding the local list that will match the "in stock" part number list with the master and overwrite it with our local information (correct?). The problem I've having is getting the "quantities on hand" put into the system. Using "ITEM MASTER LIST" to import my data does most of the work but is missing quantity and my supersession lists which are for my info only so they don't have to linked to anything, just shown. Is there a way to do this?

BillD Members Profile Send Private Message Find Members Posts Add to Buddy List Senior Member Joined: 01 Jul 2011 Location: Nevada, US Points: 474	Post Options Post Reply Quote BillD Thanks(0) Quote Reply Posted: 24 Feb 2012 at 11:06am
	To import inventory catalog, use your format with part numbers, descriptions, cost price, retail price import it into the Item Master. To import your current inventory position, use format part number, location, quantity, (serial), etc. import it into the Inventory Units. The part number (item ID in Almyta) is a unique identifier. Supersession part number can be imported into serial 1, serial 2, or Remark. Almyta also supports Alternate Part numbers, but using this function or not depends on your particular business application.