Importing Purchase Order Information into MAS90.... almost there

Question

Trying to import a CSV file into Mas90. Looking to bring in the following.... 
 PO# PO Date Vendor# WarehouseCode ItemCode ItemCodeDesc QtyOrdered UnitCost ExtensionAmt 
 What I have is working perfectly if I import a PO# that has already been entered into MAS90. 
 But when I try to import an entirely new PO, ....For the Header it tells me that the VENDOR is not on file ....For the Line item it tells me The VENDOR Number is required. 
 Again, it works fine as long as the PO# being imported "ALREADY EXISTS" in the database. 
 Can anyone tell me what I'm missing. 
 ALSO....... Is there a list of the tables in Mas90,what they do and how they relate to each other? 
 Thanks

RyanClark · Accepted Answer

It looks like you are missing the Division # field. Even if you are not using AP Divisions (Check this under AP --> Setup --> AP Options --> Main Tab) you need to include The Division # data item and ASSIGN a value of 00. Make sure it is between PO Date and Vendor #. If you are using divisions, you will see them before the vendor # in Vendor Maintenance (for example 01-AIRWAY) and then you need to specify that value in your job. Most likely the job cannot pass the DivNo+VendorNo, so it is saying the entire VendorNo failed.

Sage 100

Importing Purchase Order Information into MAS90.... almost there

COMMUNITY

COMPANY

PARTNERS

SUPPORT & TRAINING