Sage 100 Contractor 1-7 Ledger Sub Accounts
Overview:
Import Ledger Sub Accounts directly into Sage 100 Contractor. Simply download your journal transactions into Excel, review and apply ledger sub account information and import directly into Sage 100 Contractor 1-7 Ledger Sub Accounts.
Are you tired of manually keying in Ledger Sub Accounts one by one into Sage 100 Contractor? Would you rather download your ledger sub 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 Sub Accounts data entry form.
Key Features:
- Download Ledger Sub Accounts into Excel
- Edit key ledger sub account information in Excel
- Bulk import ledger sub accounts directly into Sage 100 Contractor
- Supports all native features and functions of the 1-7 Ledger Sub Accounts Entry Form
Import Template Download:
Import File Layout:
| Header | Reference | Data Type | Tab | Example | Description |
| filetype | Required | GLLSA | GLLSA | GLLSA | |
| lgract | Required ** | Numeric | Ledger Account | ||
| subact | Required ** | Numeric | Sub Account | ||
| lngnme | Required | String (50) | GL Account Name | ||
| shtnme | Required | String (30) | GL Short Name | ||
| ntetxt | Text | 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
File Example:
filetype,lgract,subact,lngnme,shtnme,ntetxt
GLLSA,7951,1,"Tax Exp - sub a","Tax Exp - sub a",""
GLLSA,7951,2,"Tax Exp - sub b","Tax Exp - sub b",""