Budget information is imported using the standard Sage 300 import function.
When you are consolidating budgets, you are replacing the contents of budget set 1 in the destination ledger with the budget information from the source ledger.
- You can export only the functional currency for budgets.
- Imported budget information replaces destination information—it is not added to it.
-
You may find it easier to consolidate budget data from several source companies by adapting and using the sample VBA budget macro (in Budget.xls) included with System Manager. It reads budget information directly from a General Ledger database, and lets you update it with revised information.
- Budgets do not use balancing accounts. (This account is used to create balanced transaction batches when consolidating account balances or net amounts and period or posting sequence transactions.)
- You can choose which budget figures you want to transfer to the destination ledger (budgets 1, 2, 3, 4, or 5), and you can specify a range of fiscal years.
Consolidate Option
If multiple source accounts are mapped to a single destination account, you use the Consolidate option on the Criteria tab of the G/L Consol Export Setup screen to specify whether or not to consolidate budget amounts from the source accounts into the destination account:
- If the Consolidate option is selected, Export creates a single entry for import that consolidates the budget amounts.
- If the Consolidate option is not selected, Export creates separate entries for import that consecutively replace each other. The last imported entry appears as the destination company's new budget amount.
Suppose accounts 1005, 1006, and 1007 are all mapped to account 1005 in the export file.
If the Consolidate option is selected, budget amounts are consolidated as follows:
| Exported Account | Mapping | Exported Budget |
|---|---|---|
|
1005 |
1005 -> 1005 |
1,000 |
|
1006 |
1006 -> 1005 |
1,200 |
|
1007 |
1007 -> 1005 |
1,500 |
|
Total |
3,700 |
| Imported Account | Imported Budget | |
|---|---|---|
|
1005 |
|
3,700 |
If the Consolidate option is not selected, budget amounts are consolidated as follows:
| Exported Account | Mapping | Exported Budget |
|---|---|---|
|
1005 |
1005 -> 1005 |
1,000 |
|
1006 |
1006 -> 1005 |
1,200 |
|
1007 |
1007 -> 1005 |
1,500 |
|
Total |
3,700 |
| Imported Account | Imported Budget | |
|---|---|---|
|
1005 |
1,500 |