Sage 100 Contractor 1-7 Ledger Accounts
Overview:
Import Ledger Accounts directly into Sage 100 Contractor. Simply download your ledger accounts into Excel, review and apply ledger account information and import directly into Sage 100 Contractor 1-7 Ledger Accounts.
Are you tired of manually keying in Ledger Accounts one by one into Sage 100 Contractor? Would you rather download your ledger accounts, 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-7 Ledger Accounts data entry form.
Key Features:
- Download Ledger Accounts into Excel
- Edit key ledger account information in Excel
- Bulk import ledger accounts directly into Sage 100 Contractor
- Supports all native features and functions of the 1-7 Ledger Accounts Entry Form
Import Template Download:
Import File Layout:
| Header | Reference | Data Type | Tab | Example | Description |
| filetype | Required | GLLA | GLLA | GLLA | |
| recnum | Required | Numeric | GL Account No | ||
| lngnme | Required | String (50) | GL Account Name | ||
| shtnme | Required | String (30) | GL Short Name | ||
| acttyp | Required ** | Numeric | 1-Cash Accounts; 2-Current Assets; 3-WIP Assets; 4-Other Assets; 5-Fixed Assets; 6-Depreciation; 7-Current Liab; 8-Long Term Liability; 9-Equity; 10-Owner's Drawing; 11-Operating Income; 12-Other Income; 13-Direct Expense; 14-Equip/Shop Exp; 15-Overhead Exp; 16-Admin Exp; 17-After Tax Inc Exp | Account Type | |
| sumact | ** | Numeric | Summary Account | ||
| subact | ** | Numeric | 0=None; 1=Subaccounts; 2=Departments | Subsidiary type (1) | |
| csttyp | ** | Numeric | 0=None; 1-Material; 2-Labor; 3-Equipment; 4-Subcontract; 5-Other; 6-UserDef6; 7-UserDef7; 8-UserDef8; 9-UserDef9 | Cost Type (2) | |
| jobsub | Numeric | 0=No; 1=Yes | Use Job No as subaccount | ||
| iscrcd | Numeric | 0=No; 1=Yes | Is Credit Card | ||
| ntetxt | Text | Notes |
Required(I) - required for inserts only
** Validated Field - value is either restricted to a defined list of values or exists in the fields respective lookup table in Sage 100 Contractor
(1) Not allowed for 1-Cash Accounts or the following designated accounts [Finance Charge, Discounts Given, Retained Earnings, Discounts Earned and Inventory Offset Account]
(2) Only available [3-WIP Assets, 13-Direct Expense, 14-Equip/Shop Exp]
File Example:
filetype,recnum,lngnme,shtnme,acttyp,sumact,subact,csttyp,jobsub,iscrcd,ntetxt
GLLA,1001,"Cash Checking","Cash Check",1,,,,,,""
GLLA,2081,"Loan Payable","Loan Pay",2,,,,,,""