Sage 100 Contractor 1-7 Ledger Account Budgets
Overview:
Import Ledger Account Budgets directly into Sage 100 Contractor. Simply download your ledger account budgets into Excel, review and apply ledger account budget information and import directly into Sage 100 Contractor 1-7 Ledger Account Budgets.
Are you tired of manually keying in Ledger Account Budgets one by one into Sage 100 Contractor? Would you rather download your ledger account budgets, 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 Account Budgets data entry form.
Key Features:
- Download Ledger Account Budgets into Excel
- Edit key ledger account budget information in Excel
- Bulk import ledger account budgets directly into Sage 100 Contractor
- Supports all native features and functions of the 1-7 Ledger Account Budgets Entry Form
Import Template Download:
Import File Layout:
| Header | Reference | Data Type | Tab | Example | Description |
| filetype | Required | GLLAB | GLLAB | GLLAB | |
| lgract | Required ** | Numeric | Ledger Account | ||
| subact | ** | Numeric | Sub Account | ||
| postyr | Required ** | Numeric | 2020 | Budget Year (1) | |
| actprd | Required ** | Numeric | [1 - 12] | Accounting Period | |
| budget | Required | Numeric | Budget Amount |
** 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) The budget year must already exist and be set up in Sage. To create or manage periods go to 1-6 Period/Fiscal Year Management
File Example:
filetype,lgract,subact,postyr,actprd, budget
GLLAB,1001,,2017,1,10000
GLLAB,1001,,2017,2,10000
GLLAB,1001,,2017,3,10000