Company Info

Sage 100 Contractor 3-2 Receivable Invoices / Credits

Overview:

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

Are you tired of manually keying in Receivable Invoices / Credits one by one into Sage 100 Contractor? Would you rather download your receivable 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 3-2 Receivable Invoices / Credits data entry form.

Key Features:

Import Template Download:

Import File Layout:


AR Header
COL1RequiredARINV(File Type Code)
COL2RequiredH(Line Type Code)
COL3RequiredString (20)Invoice No
COL4Required **NumericJob Number
COL5RequiredString (100)Invoice Description
COL6RequiredDateInvoice Date
COL7RequiredDateDue Date
COL8RequiredDateDiscount Date
COL9Required **Numeric1-Open;2-Review;3-Dispute;4-PaidStatus
COL10Required **Numeric1-Contract;2-MemoInvoice Type
COL11**NumericPhase No
COL12**NumericTax District
COL13String (40)Client PO#
COL14String (40)Reference #
COL15String (100)User Def1
COL16String (100)User Def2
COL17Numeric (10,2)Discount Avail
COL18Numeric (10,2)Retention
COL19Numeric1=Yes;0-NoHot List
COL20TextNotes

** 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 are entered jobnum, phsnum should not be entered and will be ignored


AR Details
COL1RequiredARINV(File Type Code)
COL2RequiredD(Line Type Code)
COL3RequiredString (20)(Same as header)Invoice No
COL4Required **Numeric(Same as header)Job No
COL5bigintPart #
COL6String (75)Line Description
COL7String (10)Unit Desc
COL8decimalQty
COL9decimalUnit Price
COL10**String (1)Y=Yes;N=NoTaxable
COL11**bigintAccount
COL12**bigintSub-Account
COL13**decimalCost Code
COL14String (50)User Def 1
COL15TextNotes

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


Job Cost Details (Required if a "Direct Expense" account is used on any invoice line item)
COL1RequiredString (5)ARINVFile Type
COL2RequiredString (1)JDetail Record
COL3RequiredString (20)(Same as header)Invoice No
COL4Required **Numeric(Same as header)Invoice Job No
COL5Required **NumericJob No
COL6**String (20)Work Order No
COL7RequiredString (50)Description
COL8**NumericPhase No
COL9Required **Numeric (15,3)Cost Code
COL10Required **NumericCost Type
COL11RequiredNumeric (10,2)(Negative Amount)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)ARINVFile Type
COL2RequiredString (1)EDetail Record
COL3RequiredString (20)(Same as header)Invoice No
COL4Required **Numeric(Same as header)Invoice Job No
COL5Required **NumericEquip No
COL6RequiredString (50)Description
COL7Required **Numeric (15,3)Cost Code
COL8Required **NumericCost Type
COL9RequiredNumeric (10,2)(Negative Amount)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:
ARINV,H,"ART1",2017008,"AR Test 1","5/25/2017","5/25/2017","5/25/2017",1,1,,,"","","","",,,0,""
ARINV,D,"ART1",2017008,"AR Line 1",,"",1,50,"N",4000,,,"",""
ARINV,D,"ART1",2017008,"AR Line 2",,"",1,75,"N",4001,,,"",""
ARINV,J,"ART1",2017008,2017008,"","Test AP Invoice",,2120.000,4,150,""
ARINV,E,"ART1",2017008,1,"Test AP Invoice",2010.000,3,180,""


REQUEST A DEMO

System Requirements:

Requires the Sage 100 Contractor Data Integration Suite