I have a question primarily about the "estimate" process in Dynamics AX, I have the following project structure:
- Master Project
- Sub Project 1
- Sub Project 2
Hours forecast is recorded on the lower level as illustrated below:
- Master Project
- Sub Project 1 - Hour Estimate: 3000 USD
- Sub Project 2 - Hour Estimate: 6000 USD
Expense forecast is recorded on master level as illustrated below:
- Master Project - Expense Estimate : 1000 USD
- Sub Project 1
- Sub Project 2
On the project budget, the forecast above is imported to control budget on both; parent and sub project levels.
On Account Transactions
The on account transaction is filled out on the master project ( parent ) on which invoices will be issues
- Master Project - On Account Transactions ( 7000 USD for Milestone 1, and 8000 USD for Milestone 2 )
Transactions :
As the project starts, hours are recorded on the sub project level, the following two hour journals are posted to record actual hours.
- Sub Project 1 | Actual Hour 2000 USD
- Sub Project 2 | Actual Hour 2000 USD
Invoice Proposal
An invoice is posted on the master project for the milestone 1, for 7000 USD.
Question
When running the first estimate, here are the calculated values:
- Sub Project 1 | Cost to complete method is "Total Budget - Actual"
Total Cost 3000
Actual Cost 2000
Percentage Completion = (2000/3000) = 66.67
Accrued Revenue is zero
Total Cost 6000
Actual Cost 2000
Percentage Completion = (2000/3000) = 33.33
Accrued Revenue is zero
How can we ensure that accrued revenue is estimated on the sub project level as well ? The required of our company is to do the following:
- Hours forecast and actuals are recorded on the sub project
- Expense forecast and actuals are recorded on the Master project
- Invoices to be issues to the client on the master project ( as the project customer doesn't care about all the internal sub projects)
- Estimates to be done on the sub project, in order to allocate revenue per sub project
Thanks in Advance,
