This article will explain how to create a General Budget Reservation for tracking Committed Cost on a Project.
This article assumes that you have installed KB3047235 on an AX 2012 R3 CU8 environment and you are using public sector. It also assumes you have gone through all the initial setup required that are listed in MSDN article: https://msdn.microsoft.com/en-us/dynamics/dn792460(v=ax.60)
or through blog: How to setup General Budget Reservation functionality that was added after AX 2012 R3 CU8 for Public Sector: http://blogs.msdn.com/b/axsupport/archive/2015/05/26/how-to-setup-general-budget-reservation-functionality-that-was-added-after-ax-2012-r3-cu8-for-public-sector.aspx
In the Project Management and Accounting Parameters you will need to make sure to include General Budget Reservations with Committed Cost. Project Management and Accounting | Setup | Project Management and Accounting Parameters
1. Click the Cost Control Option
2. Mark General Budget Reservation checkbox
Create a Budget Register Entry to track your budget – Budgeting | Common | Budget Register Entries | All Budget Register Entries – In the Budget Register Entry tab, in the New group, click the Budget Register Entry button.
1. Select your Budget Model
2. Select your Budget Code
3. Click the Add Line button
4. Select the Account Structure
5. Enter the Dimension Values
6. Enter the Amount
7. In the Budget Register Entry tab in the Update group click the Update Budget Balances button
8. Click Ok if prompted
9. Close the Infolog
10. Close the Budget Register Entry form
Create a new Project – Project Management and Accounting | Common | Projects | All Projects – In the Project tab in the New group click the Project button
1. Select the Project Type
2 Enter the Project Name
3. Select the Project Group
4. Select a Project Contract ID or Create a new one
5. Click Ok button
6. Click the Project Contract ID link
7. Expand the Funding Limits fast tab
8. Click the Add button
9. Select a Funding Source
10. Select a Project
11. Enter an Amount
12. Close the Projects Contract form
13. In the Projects form in the Project tab in the Maintain group click the Project Stage button and select In Process
14. Click Ok if Prompted
15. Close the Project form
Create a General Budget Reservation to link to the Project you created – Budgeting | Common | General Budget Reservation | All General Budget Reservation – In the Budget Reservation tab in the New group click the Budget Reservation button
1. Select Reservation Type: Make sure the reservation time is relieving on the PO
2. Enter Reservation Title
3. Enter the End date
4. Click Ok
5. Click the Add Line button
6. Enter the Transaction Text
7. Select the Project you created above
8. Change the Category if needed
9. Enter the Quantity
10. Enter the Unit Price
11. Expand the Line Detail fast tab
12. Select the General tab
13. Select the Procurement Category
14. Click the Project tab
15. Select the Unit
16. Save the record
17. Click the Distribute Amounts button
18. Verify the Ledger Account matches the Ledger Account matches the Budget Register Entry
19. In the Budget Reservation tab in the Post group click the Budget Reservation button
20. Close the Budget Reservation form
Go back to the Project Contract for this project.
Note the Committed Amount –
In the Control tab in the Control group click the Committed Cost button.
You can see the General Budget Reservation has a cost amount.
If you click on the General tab you can see the General Budget Reservation that is linked.
Now create a Purchase Order for this project – In the Project form in the Manage tab in the New group click the Item Task button and select Purchase Order
1. Select the Vendor Account
2. Click Ok
3. Select the Procurement Category that was referenced above
4. Enter Quantity
5. Enter Unit
6. Enter Unit Price
7. Expand the Line Details fast tab
8. Select the General Budget Reservation created above
9. Save the record
10. In the Purchase tab in the Generate group click the Confirm button
Now go back to the Project Contract, check the funding source and the Committed Cost form.
Note the Committed Amount does not change
In the Committed Cost form we can see there is a record for our Purchase Order and the Amount of Cost on the General Budget Reservation is reduced by the amount of the PO.
Now invoice part of the Purchase Order – In the Purchase Order form in the Invoice tab in the Generate group click the Invoice tab
11. Enter the Number
12. Change the Quantity to be less than the full amount
13. In the Vendor Invoice tab in the Actions group click the Post button
Go back to the Project Contract for the Project.
Note the Spent Amount is update and the Committed amount is reduced.
The Cost Amount on the PO is reduced by the amount of the vendor invoice.
The General Budget Reservation will hold the cost until it is relieved by the Purchase Order, which will then transfer the cost from the General Budget Reservation to the Purchase Order.