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:
Header Layout
| Column | Reference | Data Type | Tab | Example | Description |
| COL1 | Required | GLJE | (File Type Code) | ||
| COL2 | Required | H | (Line Type Code) | ||
| 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) | Purchase Order Number | ||
| COL8 | ** | Numeric | 0=Adjust;1=Check;2=Dep | Bank Category | |
| COL9 | ** | Numeric | Vendor Recnum | ||
| COL10 | String (50) | Payee | |||
| COL11 | String (50) | Payee2 | |||
| COL12 | String (50) | Address 1 | |||
| COL13 | String (50) | Address 2 | |||
| COL14 | String (50) | City | |||
| COL15 | String (2) | State | |||
| COL16 | String (10) | Zip | |||
| COL17 | String (50) | User Defined 1 | |||
| COL18 | String (50) | User Defined 2 | |||
| COL19 | Text | Notes | |||
| COL20 | (1) | 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) If posting period is left blank then the Journal Accounting Date will be used as the posting period
Detail Layout
| COL1 | Required | GLJE | (File Type Code) | ||
| COL2 | Required | D | (Line Type Code) | ||
| 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) | WIP / Direct Exp * | Workorder Number | ||
| COL11 | ** | Numeric | WIP / Direct Exp * | Job Number | |
| COL12 | ** | Numeric | WIP / Direct Exp * | Phase Number | |
| COL13 | String (50) | WIP / Direct Exp * | Description | ||
| COL14 | ** | Numeric | WIP / Direct Exp * | Cost Code | |
| COL15 | ** | Numeric | WIP / Direct Exp * | 1-Material; 2-Labor; 3-Equipment; 4-Subcontract; 5-Other; 6-Utilities; 7-UserDef7; 8-UserDef8; 9-UserDef9 | Cost Type |
| COL16 | Text | WIP / Direct Exp * | Notes | ||
| COL17 | ** | Numeric | Equip Exp ** | Equip Number | |
| 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 |
** Validated Field - value is either restricted to a defined list of values or exists in the fields respective lookup table in Sage 100 Contractor
COL: a placeholder must be provided for each column even if no value is 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:
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,