Posting example 1 - fixed-price project
Important
This content is archived and is not being updated. For the latest documentation, see Microsoft Dynamics 365 product documentation. For the latest release plans, see Dynamics 365 and Microsoft Power Platform release plans.
Applies To: Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2, Microsoft Dynamics AX 2012 Feature Pack, Microsoft Dynamics AX 2012
The following tables provide an example of posting a fixed-price project.
Ledger posting examples
Project group parameters |
Revenue recognition accounting rule |
Matching principle |
On-account invoicing |
|---|---|---|---|
Completed percentage |
Sales value |
Balance |
Tip
These project group parameters are set up on the Estimate FastTab in the Project groups form. Click Project management and accounting > Setup > Posting > Project groups.
Statistics - before estimate posting
Statement P&L |
Positive amount |
Jul |
Aug |
Sept |
Oct |
Nov |
Dec |
Total |
|---|---|---|---|---|---|---|---|---|
Accrued revenue - sales value |
Credit |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
Revenue |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
|
Cost |
Debit |
12,000 |
30,000 |
24,000 |
36,000 |
18,000 |
0 |
120,000 |
Gross margin |
-12,000 |
-30,000 |
-24,000 |
-36,000 |
-18,000 |
0 |
-120,000 |
Statement WIP (balance) |
Positive amount |
Jul |
Aug |
Sept |
Oct |
Nov |
Dec |
Total |
|---|---|---|---|---|---|---|---|---|
WIP - sales value |
Debit |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
Gross WIP |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
|
WIP - invoiced - on account |
Credit |
80,000 |
0 |
50,000 |
0 |
70,000 |
0 |
200,000 |
Net WIP |
-80,000 |
0 |
-50,000 |
0 |
-70,000 |
0 |
-200,000 |
Posting of estimate
Statement P&L |
Positive amount |
Jul |
Aug |
Sept |
Oct |
Nov |
Dec |
Total |
|---|---|---|---|---|---|---|---|---|
Accrued revenue - sales value |
Credit |
20,000 |
50,000 |
40,000 |
60,000 |
30,000 |
0 |
200,000 |
Cost |
Debit |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
Statement WIP (balance) |
Positive amount |
Jul |
Aug |
Sept |
Oct |
Nov |
Dec |
Total |
|---|---|---|---|---|---|---|---|---|
WIP - sales value |
Debit |
20,000 |
50,000 |
40,000 |
60,000 |
30,000 |
-200,000 |
0 |
WIP - invoiced - on account |
Credit |
0 |
0 |
0 |
0 |
0 |
200,000 |
0 |
Statistics - after estimate posting
Statement P&L |
Positive amount |
Jul |
Aug |
Sept |
Oct |
Nov |
Dec |
Total |
|---|---|---|---|---|---|---|---|---|
Accrued revenue - sales value |
Credit |
20,000 |
50,000 |
40,000 |
60,000 |
30,000 |
0 |
200,000 |
Revenue |
20,000 |
50,000 |
40,000 |
60,000 |
30,000 |
0 |
200,000 |
|
Cost |
Debit |
12,000 |
30,000 |
24,000 |
36,000 |
18,000 |
0 |
120,000 |
Gross margin |
8,000 |
20,000 |
16,000 |
24,000 |
12,000 |
0 |
80,000 |
Statement WIP (balance) |
Positive amount |
Jul |
Aug |
Sept |
Oct |
Nov |
Dec |
Total |
|---|---|---|---|---|---|---|---|---|
WIP - sales value |
Debit |
20,000 |
50,000 |
40,000 |
60,000 |
30,000 |
-200,000 |
0 |
Gross WIP |
20,000 |
50,000 |
40,000 |
60,000 |
30,000 |
0 |
200,000 |
|
WIP - invoiced - on account |
Credit |
80,000 |
0 |
50,000 |
0 |
70,000 |
-200,000 |
0 |
Net WIP |
-60,000 |
50,000 |
-10,000 |
60,000 |
-40,000 |
0 |
0 |
See also
About the fixed-price project posting examples
About invoicing fixed-price projects