Page History: Purchase Order Import
Compare Page Revisions
Page Revision: Mon, 20 Sep 2010 14:07
Default Menu Location
Transaction >> Importers/Exporters >> Purchase and Sales Orders >> Purchase Order Import
Click here for a screenshot
General Description
The Purchase Order Import screen allows users to import external Purchase Order files into Adjutant.
There is a Header and Details (line items) file. Both files are imported at the same time.
Import Template Help - Header File
PoNo - Purchase Order number.
RemitTo - Organization ID of the Remit To company.
Vendno - Organization ID of the Vendor (Sold From).
Orderno - A reference order number. Purchase Orders can be searched by this number on the Purchase Order screen.
Owner - The Organization ID of the Inventory Owner. This is most likely the Org ID of your company.
PODate - Purchase Order date.
ReqDate - Required Date of the PO. This date flows through to the line items as a default date.
Freight - Freight payment terms. This must match a value in the FREIGHT rule.
Terms - PO payment terms. This must match a value in the TERMS rule.
TaxRate - Sales tax rate that applies to the PO (typically 0).
POType - Type of PO. This must match a one-character code in the POTYPE rule. If in doubt, use 'P' for purchase orders and 'R' for vendor returns.
Heldfor - The holder of the inventory. Leave this blank if unsure or use the same value that you entered for Owner.
ConfirmTo - PO Confimation person. Plain text field up to 50 characters.
Remarks - PO remarks field. Plain text field up to 50 characters.
Buyer -Person making the purchase. This must match the full name of a contact with the Buyer attribute.
FOB - FOB terms. This must match a value in the FOB rule.
ShipVia - Shipping method. This must match a value in the SHIPVIA rule.
ShipTo - Only use this field if the PO is being drop-shipped to a customer location. Organization ID of the Ship To.
RecLoct - Warehouse name. This must match a warehouse name that has been set up in the Warehouses screen.
