Posting example 1 - fixed-price project [AX 2012]

Updated: November 11, 2011

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.

Project group parameters

Revenue recognition accounting rule

Matching principle

On-account invoicing

Completed percentage

Sales value

Balance

Tip 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.

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

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

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


Announcements: To see known issues and recent fixes, use Issue search in Microsoft Dynamics Lifecycle Services (LCS).

Community Additions

ADD
Show: