Company Info

Sage 100 Contractor 4-2 Payable Invoices / Credits

Overview:

Import Payable Invoices / Credits directly into Sage 100 Contractor. Simply download your payable invoices / credits into Excel, review and apply payable invoice information and import directly into Sage 100 Contractor 4-2 Payable Invoices / Credits.

Are you tired of manually keying in Payable Invoices / Credits one by one into Sage 100 Contractor? Would you rather download your payable invoices / credits, 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 4-2 Payable Invoices / Credits data entry form.

Key Features:

Import Template Download:

Import File Layout:

Header
COL1RequiredString (5)APINVFile Type
COL2RequiredString (1)HHeader Record
COL3RequiredString (20)Invoice No
COL4Required **NumericVendor No
COL5RequiredString (50)Invoice Desc
COL6RequiredDateyyyy-mm-ddInvoice Date
COL7RequiredDateyyyy-mm-ddDue Date
COL8RequiredDateyyyy-mm-ddDiscount Date
COL9Required ** (1)Numeric1-Open, 2-Review, 3-Dispute, 4-PaidStatus
COL10Required **Numeric1-Contract,2-MemoInvoice Type
COL11** (2)String (20)Purchase Order No
COL12** (2)String (20)Subcontract No
COL13** (3)NumericJob No
COL14** (3)NumericPhase No
COL15String (20)Ship No
COL16String (20)Reference No
COL17String (50)User Def 1
COL18String (50)User Def 2
COL19Numeric (10,2)Discount Amt
COL20Numeric (10,2)Retainage Amt
COL21Numeric (10,2)Set to Pay Amt
COL22Numeric1=Yes;0-NoHot List
COL23TextNotes

** 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
(1) If a Status of 4-Paid is entered no ledger transactions will be created for the invoice
(2) Auto Detail: If no "D" records are passed into the file for the respective subcontract or purchase order then the detail line items will be automatically populated based on the existing line items for the PO or Subcontract in Sage
(3) If a contract or purchase order number are entered jobnum, phsnum should not be entered and will be ignored


AP Details
COL1RequiredString (5)APINVFile Type
COL2RequiredString (1)DDetail Record
COL3RequiredString (20)(Same as header)Invoice No
COL4Required **Numeric(Same as header)Vendor No
COL5RequiredString (75)Line Description
COL6(1)NumericContract Line No
COL7**NumericPart No
COL8String (10)Unit of Measure
COL9RequiredNumeric (10,2)Quantity
COL10Required (2)Numeric (10,2)Price
COL11Required **NumericExp Account
COL12**NumericExp Sub Account
COL13**NumericInventory Location
COL14String (30)Part Serial No
COL15String (50)User Def 1

** 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
(1) If a contract or purchase order number entered the contract line no is required for all lines
(2) Price may not be a negative value. If the line amount is negative you must make the "Quantity" negative

Job Cost Details (Required if a "Direct Expense" account is used on any invoice line item)
COL1RequiredString (5)APINVFile Type
COL2RequiredString (1)JDetail Record
COL3RequiredString (20)(Same as header)Invoice No
COL4Required **Numeric(Same as header)Vendor No
COL5Required **NumericJob No
COL6**String (20)Work Order No
COL7RequiredString (50)Description
COL8**NumericPhase No
COL9Required **Numeric (15,3)Cost Code
COL10Required **Numeric1=Material; 2=Labor; 3=Equipment; 4=Subcontract; 5=Other; 6=UDF6; 7=UDF7; 8=UDF8; 9=UDF9Cost Type
COL11RequiredNumeric (10,2)Cost Amount
COL12TextNotes

** 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

Equipment Cost Details (Required if a "Equipment Expense" account is used on any invoice line item)
COL1RequiredString (5)APINVFile Type
COL2RequiredString (1)EDetail Record
COL3RequiredString (20)(Same as header)Invoice No
COL4Required **Numeric(Same as header)Vendor No
COL5Required **NumericEquip No
COL6RequiredString (50)Description
COL7Required **Numeric (15,3)Cost Code
COL8Required **Numeric1=Material; 2=Labor; 3=Equipment; 4=Subcontract; 5=Other; 6=UDF6; 7=UDF7; 8=UDF8; 9=UDF9Cost Type
COL9RequiredNumeric (10,2)Cost Amount
COL10TextNotes

** 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:
APINV,H,"ABC 246",231,"Test AP Inv","7/20/2019","7/20/2019","7/20/2019",1,1,"","",,,"","","","",,,,0,""
APINV,D,"ABC 246",231,"Line 1 AP","","",,"","1",100,"6040","",,,
APINV,J,"ABC 246",231,2017008,"","line 1",,2010,1,200,""


REQUEST A DEMO

System Requirements:

Requires the Sage 100 Contractor Data Integration Suite