You use this batch job to copy an existing budget to a new one. For example, you can copy 12 monthly budgets for the current fiscal year to 12 monthly budgets for the coming fiscal year. This ensures that the budget amounts are placed in the correct accounts. If the figures need to be changed, you can simply enter new figures over the old ones or use the Adjustment Factor field.
The Export Budget to Excel function appears when you open the Budget window and then click Functions, Copy Budget.
Before you can run the batch job, you must decide whether you want to copy G/L entries or G/L budget entries, and whether all or only selected entries will be copied. You can also decide what information the new G/L budget entries will contain in relation to the old ones and how the batch job is processed.
Fill in the fields as follows:
Source: In this field, you select which kind of amounts you wish to copy to a new budget. You can select either G/L entries or G/L budget entries.
Budget Name: Enter the name of the G/L budget to be copied. To see the existing budget names, click the AssistButton in the field.
G/L Account No.: Enter the numbers of the G/L accounts to be copied. To see the existing G/L account numbers, click the AssistButton in the field.
Date: Enter the period for which the budget will be copied (for example, 10/01/96..12/31/9).
Closing Entries: Here you select if the closing entries will be included or excluded in the new budget.
Dimensions: Here you select which dimensions will be included in the new budget. If G/L entries or budget entries have dimensions attached, these can be copied to the new budget. To see the attached dimensions, click the AssistButton to the right of the field.
Budget Name: Enter the name of the new budget. To select a budget name, click the AssistButton to the right of the field.
G/L Account No.: If one or more ledger entries must be copied to one G/L account, you enter the G/L account number here. To see the existing G/L accounts, click the AssistButton to the right of the field.
Adjustment Factor: In this field, you can enter an adjustment factor to multiply the amounts you wish to copy. By entering an adjustment factor, you can increase or decrease the amounts that the program will copy to the new budget.
Rounding Method: Here you can select a code for the rounding method you wish to apply to entries when copying them to a new budget.
Date Change Formula: Here you can specify how the dates on the entries that are copied will be changed. Use a date formula; for example, to copy last week's budget to this week, use the formula 1W (one week).
Date Compression: Here you can select the length of the period whose entries will be combined. To see the options, click the AssistButton to the right of the field.
Click OK to start the batch job. If you do not want to run the batch job now, click Cancel to close the window.