Sage 100 Contractor 3-3-1 & 2 Cash Receipts
Overview:
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:
- Download Cash Receipts into Excel
- Edit key cash receipt information in Excel
- Bulk import cash receipts directly into Sage 100 Contractor
- Supports all native features and functions of the 3-3-1 & 2 Cash Receipts Entry Form
Import Template Download:
Endpoint Table:
| Field | Reference | Data Type | Tab | Example | Description |
| filetype | Required | ARCR | Header | ARCR | (File Type Code) |
| chkact | Required ** | Numeric | Header | Deposit Bank Account | |
| chkdepno | Required | String (20) | Header | Deposit Number | |
| actgdte | Required | Date | Header | yyyy-mm-dd | Posting Date |
| chkdte | Required | Date | Header | yyyy-mm-dd | Cash Receipt Date |
| chkdscrpt | Required | String (50) | Header | Cash Receipt Description | |
| invtype | Required ** | String (1) | Header | C=Contract;S=Service | Invoice Type |
| jobclnnum | Required ** (1) (2) | Numeric | Job / Service Client No | ||
| invnum | Required ** (2) | String (20) | Invoice Number | ||
| chknum | String (20) | Check No | |||
| pdamt | Required | Numeric (9,2) | Check Paid Amount | ||
| ovrpmt | Numeric (9,2) | Check Overpayment Amount | |||
| dsctkn | Numeric (9,2) | Discount Amount | |||
| er_pymt | Numeric | 1=yes;0=no | Electronic Pmt Flag | ||
| er_refno | (3) | String (16) | Electronic Pmt Ref No | ||
| er_payor | (3) | String (103) | Electronic Pmt Payor Name | ||
| er_paytyp | (3) ** | String (1) | 3-American Express; 4-Visa; 5-MasterCard; 6-Discover; C-ACH; O-Other | Electronic Pmt Type | |
| er_last4 | (3) | String (4) | Last 4 digits of credit card | Electronic Pmt Last 4 CC |
** Validated Field - value must exist in the respective lookup table in Sage 100 Contractor
(1) Enter jobnum if invtype="C" and clnnum if invtype="S"
(2) Job / Service Client No and Invoice Number must be unique in Sage 100 Contractor
(3) 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,"","","",""