Sage 100 Contractor 4-7-3 Credit Card Receipts
Overview:
Import Credit Card Receipts directly into Sage 100 Contractor. Simply download your credit card receipts into Excel, review and apply credit card receipt information and import directly into Sage 100 Contractor 4-7-3 Credit Card Receipts.
Are you tired of manually keying in Credit Card Receipts one by one into Sage 100 Contractor? Would you rather download your credit card 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 4-7-3 Credit Card Receipts data entry form.
Key Features:
- Download Credit Card Receipts into Excel
- Edit key credit card receipt information in Excel
- Bulk import credit card receipts directly into Sage 100 Contractor
- Supports all native features and functions of the 4-7-3 Credit Card Receipts Entry Form
Import Template Download:
Import File Layout:
Header Layout| Header | Reference | Data Type | Tab | Example | Description |
| COL1 | Required | APCCR | (File Type Code) | ||
| COL2 | Required | H | (Header Record) | ||
| COL3 | Required (1) | String (20) | Header | 123_abc | Transaction Reference |
| COL4 | Required ** | Numeric | Header | Credit Card Account | |
| COL5 | Required ** | Numeric | Header | Credit Card Sub Account | |
| COL6 | Required | date | Header | YYYY-MM-DD | Transaction Date |
| COL7 | Required | String (50) | Header | CC Transaction Desc | Transaction Description |
| COL8 | Required (2) | String (50) | Header | Payee | |
| COL9 | ** (2) (3) | Numeric | Header | Invoice/Payment Created | Vendor Recnum |
| COL10 | String (50) | Header | usrdf1 | ||
| COL11 | String (50) | Header | usrdf2 | ||
| COL12 | Text | Header | Notes | ||
| COL13 | (4) | Date | Posting Period |
** 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) Transaction Reference must be unique for each line item. (2) Payee should be left blank if a Vendor Recnum is entered and will default to the Vendor Name. If both a Payee and Vendor No are entered the Payee value will be ignored and defaulted to the Vendor Name. (3) If you enter a vendor, a paid invoice is created. If you look in 1-3 Journal Transactions, you see that two journal transactions have been created. This is a typical journal transaction and a record of the payment (the paid invoice). (4) If posting period is left blank then the Transaction Date will be used as the posting period
Detail Layout
| COL1 | Required | APCCR | (File Type Code) | ||
| COL2 | Required | D | (Detail Record) | ||
| COL3 | Required | String (20) | Header | 123_abc | Transaction Reference |
| COL4 | Required ** | Numeric | Header | Ledger Acct Recnum | |
| COL5 | ** | Numeric | Detail | Sub Account Recnum | |
| COL6 | String (50) | Detail | Line Description | ||
| COL7 | ** (1) | Numeric | Detail | (Vendor Recnum Required) | Part No |
| COL8 | String (10) | Detail | Unit of Measure | ||
| COL9 | Numeric (12,4) | Detail | Quantity | ||
| COL10 | (2) | Numeric (15,6) | Detail | Price | |
| COL11 | (3) | Numeric (9,2) | Detail | (Enter 0 or Blank if Qty and Price entered) | Total Amount |
| COL12 | String (50) | Detail | User Defined 1 | ||
| COL13 | ** | String (20) | Detail | WIP / Direct Exp * | Workorder No |
| COL14 | ** | Numeric | Detail | WIP / Direct Exp * | Job No |
| COL15 | ** | Numeric | Detail | WIP / Direct Exp * | Phase No |
| COL16 | String (50) | Detail | WIP / Direct Exp * | Description | |
| COL17 | ** | Numeric (15,3) | Detail | WIP / Direct Exp * | Cost Code |
| COL18 | ** | Numeric | Detail | WIP / Direct Exp * | Cost Type |
| COL19 | Text | Detail | WIP / Direct Exp * | Notes | |
| COL20 | ** | Numeric | Detail | Equip Exp ** | Equip No |
| COL21 | String (50) | Detail | Equip Exp ** | Description | |
| COL22 | ** | Numeric (15,3) | Detail | Equip Exp ** | Cost Code |
| COL23 | ** | Numeric | Detail | Equip Exp ** | Cost Type |
| COL24 | Text | Detail | Equip Exp ** | Notes |
** 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) Part No is only allowed if a Vendor No is entered in the Header. (2) Price may not be a negative value. If the line amount is negative you must make the "Quantity" negative (3) The Total Amount field will be automatically calculated based on the Quantity and Price entered. If Quantity and Price are not entered then a value must be provided. WIP / Direct Exp * - Required if the lgract (Col 4) is assigned to [3 - WIP Assets] or [13 - Direct Expense] account type Equip Exp** - Required if the lgract (Col 4) is assigned to [14 - Equip/Shop Expense] account type
File Example:
CCR,H,"CC123","2250","1156","7/15/2020","lunch","CPK",,"","","","" CCR,D,"CC123",6001,,"lunch",,"",,,34.56,,"1",2,3,"4",5,6,"7",8,"9",10,11,"12" CCR,H,"CC124","2250","1156","7/16/2020","drill bits","Owens Hardware",,"","","","" CCR,D,"CC124",6001,,"drill bits",,"",,,125,,"",,,"",,,"",,"",,,"" CCR,H,"CC125","2250","1156","7/17/2020","office supplies","Office Max",,"","","","" CCR,D,"CC125",6001,,"office supplies",,"",,,45,,"",,,"",,,"",,"",,,""