Import Journal Transactions directly into Sage 100 Contractor. Simply download your journal transactions into Excel, review and apply journal transaction information and import directly into Sage 100 Contractor 1-3 Journal Transactions.
Are you tired of manually keying in Journal Transactions one by one into Sage 100 Contractor? Would you rather download your journal transactions, 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 1-3 Journal Transactions data entry form.
COL1 | Required | GLJE | (File Type Code) | ||
COL2 | Required | H | (Header Record) | ||
COL3 | Required | String (20) | 123_abc | Journal Number | |
COL4 | Required | date | 2018-01-05 | Journal Accounting Date | |
COL5 | Required | String (50) | Test Journal Entry | Journal Description | |
COL6 | Required | Numeric | 1=Open; 2=Cleared | Journal Status | |
COL7 | ** | String (20) | Purch Order No | ||
COL8 | ** | Numeric | 0=Adjust;1=Check;2=Dep | Bank Category | |
COL9 | ** | Numeric | Vendor Recnum | ||
COL10 | String (50) | payee1 | |||
COL11 | String (50) | payee2 | |||
COL12 | String (50) | addrs1 | |||
COL13 | String (50) | addrs2 | |||
COL14 | String (50) | ctynme | |||
COL15 | String (2) | state_ | |||
COL16 | String (10) | zipcde | |||
COL17 | String (50) | usrdf1 | |||
COL18 | String (50) | usrdf2 | |||
COL19 | Text | Notes |
COL1 | Required | GLJE | (File Type Code) | ||
COL2 | Required | D | (Detail Record) | ||
COL3 | Required | String (20) | Journal Number | ||
COL4 | Required ** | Numeric | Ledger Acct Recnum | ||
COL5 | ** | Numeric | Sub Account Recnum | ||
COL6 | String (50) | Line Description | |||
COL7 | Numeric | Debit Amount | |||
COL8 | Numeric | Credit Amount | |||
COL9 | String (50) | User Defined 1 | |||
COL10 | String (20) | Direct Exp * | Workorder No | ||
COL11 | ** | Numeric | Direct Exp * | Job No | |
COL12 | ** | Numeric | Direct Exp * | Phase No | |
COL13 | String (50) | Direct Exp * | Description | ||
COL14 | ** | Numeric | Direct Exp * | Cost Code | |
COL15 | ** | Numeric | Direct Exp * | 1-Material; 2-Labor; 3-Equipment; 4-Subcontract; 5-Other; 6-Utilities; 7-UserDef7; 8-UserDef8; 9-UserDef9 | Cost Type |
COL16 | Text | Direct Exp * | Notes | ||
COL17 | ** | Numeric | Equip Exp ** | Equip No | |
COL18 | String (50) | Equip Exp ** | Description | ||
COL19 | ** | Numeric | Equip Exp ** | Cost Code | |
COL20 | ** | Numeric | Equip Exp ** | 1-Material; 2-Labor; 3-Equipment; 4-Subcontract; 5-Other; 6-Utilities; 7-UserDef7; 8-UserDef8; 9-UserDef9 | Cost Type |
COL21 | Text | Equip Exp ** | Notes |