Tips for preparing vendor invoice file for import into Items and subsequent Import into Purchasing Spreadsheet

 

Open vendor file and insert a row below their headers.

 

Drop in new headers for Po worksheet:

 

The following columns are required and expected as column headings:

 

Storeno -Only required if central Acme.

Acmeitemno -Required, must pre-exist. PLU's cannot be used.

Orderqty -Required, can be 0 if you plan to fill it in later. This is in Purchasing Unit of Measure.

Unitcost -Required, can be blank or zero if you plan to update cost during PO receipts. This populates Vendor Default Cost field, for purchasing unit of measure.

Vendorno -Required. the item does not have to be previously associated with the vendor if you choose to "Add New Vendor Items" during import.

Vendorpartno Required, must be unique, since these are used along with Acmeitemno to match up the item. Can be different than value stored in Acme if you chose to Update Vendor Item Numbers during import.

 

 

Add new headers for the rest of the columns that you wish to have as part of item import.

 

Adjust "Convert_UPC.ini" accordingly.

 

Run Convert_UPC.exe to produce file suitable for both imports.