QAD 2016 Enterprise Edition Training Guides > Financials-Advanced > Budgeting > Hands-On Exercises
  PPT
Hands-On Exercises
Exercise 1: Create a New Budget using the Excel Hotlink
Log in to 10USACO or 22UKCO.
1 Open System Maintain (36.24.3.1) and check the setting for the Budget Enabled field.
If the field is cleared, select the field and save the change.
2 Open Budget Report Period Modify (25.4.5.2), and verify if budget periods exist for the current GL calendar year, for example, 2013.
If records do not exist, use Budget Report Period Create to create budget periods for the current GL calendar year.
a Specify the following values:
 
Field
Data
New Year
Current year, for example, 2013
Create Manually
Yes (Selected)
b Click OK.
c Save the budget periods.
3 Go to Budget Create (25.5.1.1) and create the following budget:
 
Field
Data
Budget Code
ISBGT
Description
ISBGT
4 On the Budget Period tab, create four periods for the current GL calendar year (for example, 2013).
Select Custom Date. Use the Periods by Dates sub-screen to create the periods:
 
Field
Data
Starting Date
The first day of the GL calendar year. For example, 01/01/2013
Occurrences
4
Budget Period Type
Quarter
5 On the Levels tab, enter three lines by right-clicking on the grid and selecting Insert a New Row.
 
Field
Data
WBS Level
1,2,3
COA Element
(Sub)Total, (Sub)Total, General Ledger
The Input Level (Budget) field displays 3.
6 On the Versions tab, enter the following values:
 
Field
Data
From Report Period
01
From Reporting Year
2013
7 Open the QMI Documentation/Financial Activities folder on the desktop.
8 From the Budgeting folder in the Financials Activities folder, download the file HO budget create1.xlsx using File|Download in GoogleDocs.
The file is saved to My Documents/Downloads.
9 Return to the QAD application.
10 Go to the Structures tab of Budget Create, click the Excel Hotlink menu at the top of the screen, and select Create from Excel.
11 In the popup window, select the file HO budget create1.xlsx and click Open to review.
After the upload from Excel, the budget amounts are loaded.
12 Save your newly created budget. If you receive an error message about missing WBS/COA links, try the following workaround:
a Change the budget status back to Initial.
b Click the Save button and the budget is saved without COA links.
Exercise 2: Create and Copy a Budget
1 In Budget Create (25.5.1.1), create the following budget:
 
Field
Data
Budget Code
CC-ADM
Description
CC-ADM
2 In the Budget Period tab, create periods for the current GL calendar year. Click Select Year, specify the current GL calendar year as the year, and then click Create Budget Periods.
3 In the Levels tab, right-click and select Insert a New Row twice to create two levels.
 
Field
Data
WBS Level
1, 2
COA Element
Cost Center, General Ledger
4 In the Structures tab, right-click and select Insert a New Row. Rename the topic to ADM on this row.
5 Right-click the row and select Topic Properties. In the Topic Properties window, select the COA Link tab.
 
Field
Data
Budget Group
<leave blank>
Link by Level
ADM (enter or select from lookup)
6 Click OK.
7 In the Structures tab, right-click in the ADM topic row again and select Insert Child Row twice to create two child rows.
8 Name the first child row 7000. Select the row, right-click, and select Auto Link|Current Budget Node.
9 Name the second child row 7020. Select the row, right-click, and select Auto Link|Current Budget Node.
10 On the Versions tab, enter the following values:
 
Field
Data
From Report Period
01
Reporting Year
Specify the year for which you created the budget, for example, 2013.
11 Change the budget status to Operational.
12 Save your newly created budget.
13 In Budget Copy (25.5.1.5), enter the following data:
 
Field
Data
Source Budget Code
CC-ADM
Budget Code
CC-MAR
Budget Description
CC-MAR
Copy Budget Figures
Yes (Selected)
14 Click Save.
15 Go to Budget Modify All Versions (25.5.1.6) and select the newly created budget code (CC-MAR).
16 Go to the Structures tab and rename the topic from ADM to MAR.
17 Right-click the row, select Topic Properties, and then go to the COA Link tab. Replace ADM by MAR.
18 Click OK in the Topic Properties window.
19 Save the budget.
Your new budget is ready.