Company Info

Sage 100 Contractor 3-3-1 & 2 Cash Receipts


Import Cash Receipts directly into Sage 100 Contractor. Simply download your cash receipts into Excel, review and apply cash receipt information and import directly into Sage 100 Contractor 3-3-1 & 2 Cash Receipts.

Are you tired of manually keying in Cash Receipts one by one into Sage 100 Contractor? Would you rather download your cash receipts, 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-3-1 & 2 Cash Receipts data entry form.

Key Features:

Import Template Download:

Endpoint Table:

HeaderReferenceData TypeTabExampleDescription
chkactRequired **NumericHeaderDeposit Bank Account
chkdepnoRequiredString (20)HeaderDeposit Number
actgdteRequiredDateHeaderyyyy-mm-ddPosting Date
chkdteRequiredDateHeaderyyyy-mm-ddCash Receipt Date
chkdscrptRequiredString (50)HeaderCash Receipt Description
invtypeRequired **String (1)HeaderC=Contract;S=ServiceInvoice Type
jobclnnumRequired ** (1)NumericJob / Service WO Client No
invnumRequired **String (20)Invoice Number
chknumString (20)Check No
pdamtRequiredNumeric (9,2)Check Paid Amount
ovrpmtNumeric (9,2)Check Overpayment Amount
dsctknNumeric (9,2)Discount Amount
er_pymtNumeric1=yes;0=noElectronic Pmt Flag
er_refno(2)String (16)Electronic Pmt Ref No
er_payor(2)String (103)Electronic Pmt Payor Name
er_paytyp(2) **String (1)3-American Express; 4-Visa; 5-MasterCard; 6-Discover; C-ACH; O-OtherElectronic Pmt Type
er_last4(2)String (4)Last 4 digits of credit cardElectronic Pmt Last 4 CC

** Validated Field - value is either restricted to a defined list of values or exists in the fields respective lookup table in Sage 100 Contractor
(1) Enter jobnum only if invtype="C" and clnnum if invtype="S"
(2) If Electronic Payment Flag (er_pymt) = 1 then the field is required

File Example:
filetype,chkact,chkdepno,actgdte,chkdte,chkdscrpt,invtype,jobclnnum,invnum,chknum, pdamt ,ovrpmt,dsctkn,er_pymt,er_refno,er_payor,er_paytyp,er_last4
ARCR,1000,"222_1",2017-05-01,2017-05-01,"work order pmt","S","1001","1","000222",250.5,,,0,"","","",""
ARCR,1000,"222_2",2017-05-01,2017-05-01,"contract pmt","C","20020","S1IV","000223",200,,,0,"","","",""

System Requirements

Requires the Sage 100 Contractor Data Integration Suite