Sage 100 Contractor 1-3 Journal Transactions
Overview:
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.
Key Features:
- Download Journal Transactions into Excel
- Edit key journal transaction information in Excel
- Bulk import journal transactions directly into Sage 100 Contractor
- Supports all native features and functions of the 1-3 Journal Transactions Entry Form
Import Template Download:
Import File Layout:
| 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 |
Detail Layout
| 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 |
Direct Exp* - Required if the lgract (Col 4) is assigned to [13 - Direct Expense] account type
Equip Exp** - Required if the lgract (Col 4) is assigned to [14 - Equip/Shop Expense] account type
File Example:
GLJE,H,123,2018-01-05,"Test, Journal Entry ",1,,,,,,,,,,,,,,,
GLJE,D,123,1,2001,,500.00,,,,,,,,,,,,,,
GLJE,D,123,2,5001,,,250.00,,,2017504,"test line",,2030.000,2,,,,,,
GLJE,D,123,2,5601,,,250.00,,,,,,,,,1,test,2030.000,1,