Company Info

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:

Import Template Download:

Import File Layout:

Header
COL1 Required APCCR (File Type Code)
COL2 Required H (Header Record)
COL3 Required String (20) 123_abc Transaction Reference (1)
COL4 Required ** Numeric Credit Card Account
COL5 Required ** Numeric Credit Card Sub Account
COL6 Required date YYYY-MM-DD Transaction Date
COL7 Required String (50) CC Transaction Desc Transaction Description
COL8 Required String (50) Payee (2)
COL9 ** Numeric (3) Invoice/Payment Created Vendor Recnum (2)
COL10 String (50) usrdf1
COL11 String (50) usrdf2
COL12 Text Notes

(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).


Detail Layout
COL1 Required APCCR (File Type Code)
COL2 Required D (Detail Record)
COL3 Required String (20) 123_abc Transaction Reference
COL4 Required ** Numeric Ledger Acct Recnum
COL5 ** Numeric Sub Account Recnum
COL6 String (50) Line Description
COL7 ** Numeric (Vendor Recnum Required) Part No (1)
COL8 String (10) Unit of Measure
COL9 Numeric (10,2) Quantity
COL10 Numeric (10,2) Price
COL11 Numeric (9,2) (Enter 0 or Blank if Qty and Price entered) Total Amount (2)
COL12 String (50) User Defined 1
COL13 String (20) Direct Exp * Workorder No
COL14 ** Numeric Direct Exp * Job No
COL15 ** Numeric Direct Exp * Phase No
COL16 String (50) Direct Exp * Description
COL17 ** Numeric (15,3) Direct Exp * Cost Code
COL18 ** Numeric Direct Exp * Cost Type
COL19 Text Direct Exp * Notes
COL20 ** Numeric Equip Exp ** Equip No
COL21 String (50) Equip Exp ** Description
COL22 ** Numeric (15,3) Equip Exp ** Cost Code
COL23 ** Numeric Equip Exp ** Cost Type
COL24 Text Equip Exp ** Notes

(1) Part No is only allowed if a Vendor No is entered in the Header
(2) The Total Amount field will be automatically calculated based on the Quantity and Price entered. If no quantity or price is entered then a value must be provided.
Direct Exp* - Required if the lgract (Col 5) is assigned to [13 - Direct Expense] account type
Equip Exp** - Required if the lgract (Col 5) 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,,"",,,"",,,"",,"",,,""

REQUEST A DEMO

System Requirements:

Requires the Sage 100 Contractor Data Integration Suite