Company Info

Sage 100 Contractor 6-6-1 Purchase Orders

Overview:

Import Purchase Orders directly into Sage 100 Contractor. Simply download your purchase orders into Excel, review and apply purchase order information and import directly into Sage 100 Contractor 6-6-1 Purchase Orders.

Are you tired of manually keying in Purchase Orders one by one into Sage 100 Contractor? Would you rather download your purchase orders, fill in the blanks in Excel and import the details directly into Sage 100 Contractor? The following integration template allows you to do just that. It mimics every feature and function of the 6-6-1 Purchase Orders data entry form.

Key Features:

Import Template Download:

Import File Layout:

Header
COL1RequiredString (2)PJPOPJPO
COL2RequiredString (1)HHeader Record
COL3RequiredString (20)PO Number
COL4Required **NumericVendor No
COL5RequiredDateyyyy-mm-ddPO Date
COL6RequiredString (50)Description
COL7Required **Numeric1-Open,2-Review,3-Dispute,4-Closed,5-Void,6-MasterStatus
COL8**NumericPO Type
COL9String (50)Attention
COL10**NumericJob No
COL11**NumericPhase No
COL12**NumericEquipment No
COL13Numeric (11,3)Task No
COL14NumericTax District
COL15Dateyyyy-mm-ddApproved Date
COL16Dateyyyy-mm-ddScheduled Date
COL17Dateyyyy-mm-ddDelivery Date
COL18String (60)Via
COL19String (10)##DY,##TH or ##MOTerms
COL20**NumericOrdered By
COL21String (50)Address 1
COL22String (50)Address 2
COL23String (50)City
COL24String (2)State
COL25String (10)Zip Code
COL26String (50)User Def 1
COL27String (50)User Def 2
COL28NumericHot List
COL29NumericLock Edit
COL30TextNotes

** Validated Field - value must exist in the respective lookup table in Sage 100 Contractor
COL: a placeholder must be provided for each column even if no value is provided

Details
COL1RequiredString (2)PJPOPJPO
COL2RequiredString (1)DDetail Record
COL3RequiredString (20)PO Number
COL4Required **NumericVendor No
COL5**Numeric0Part No
COL6RequiredString (75)Line Description
COL7String (10)Unit
COL8Numeric (8,4)Quantity
COL9Numeric (9,6)Price
COL10Numeric (12,4)Qty Recvd To Date
COL11Numeric (8,4)Current
COL12Numeric (8,4)Canceled
COL13**Numeric (12,3)Cost Code
COL14**NumericCost Type
COL15**NumericInventory Location
COL16**NumericAccount
COL17**NumericSubaccount
COL18String (50)User Defined
COL19TextNotes

** Validated Field - value must exist in the respective lookup table in Sage 100 Contractor
COL: a placeholder must be provided for each column even if no value is provided


File Example:
PO,H,PO 2,231,2019-07-13,PO Test 2,1,,,2017008,,,,,,,,,,,,,,,,,,,,
PO,D,PO 2,231,,poline 1,,10,50,3,75,1,2120.000,1,,1211,,,
PO,D,PO 2,231,,poline 2,,10,75,,20,,,,,,,,


REQUEST A DEMO

System Requirements:

Requires the Sage 100 Contractor Data Integration Suite