Business Scenario Company is having a fixed price project signed with one customer with below criteria - Milestone are o First Milestone - 100,000 $ o Second Milestone 200,000 $ o Last Milestone 300,000 $ - Retention term 10% to be deducted from each milestone till the work is completed 100% - Its mentioned in the contract if the company will not complete the milestone in the scheduled date, 1% from milestone value will be deducted from total invoice amount First milestone: After completing first milestone in the agreed date, invoice for the 100,000$ is issued to customer, the invoice should contain the below details Work Done 100,000 Retention 10,000 Invoice Amount (90,000) So the voucher should be as below Dr. Customer 90,000 $ Dr. Retention 10,000 $ Cr. Unearned Revenue 100,000 $ In this entry, system is 100% fit the business need Second Milestone When having a delay in delivery for the second milestone, deduction should be added to invoice amount, so invoice will contain the below details Work done 200,000 Retention 20,000 Penalty Deduction 2,000 Invoice Amount 178,000 So the voucher Generated from system should be Dr. Customer 178,000 Dr. Retention 20,000 Dr. Delay Penalty(expanse account) 2,0000 This entry is missing in D365 FO Cr. Unearned Revenue 100,000 This is for Fixed Price project. This Request is logged on behalf of the partner Mohammed Rasheed (SR 119030519729898)
Comments
This is very important subject.
this stopped us from implementing project accounting in Ax 2012 in some implementations, since accounting treatment is not aligned with IFRS
so we have completed our implementation in Ax 2012 by adjusting the core code from Microsoft, but it took a lot of time time to do it and test it.
Unfortunately extensible subject will not allow us to do the same D365 - unified version.
Still we are searching how to reach this.
hope Microsoft will complete this in the near future.
Category: Project Accounting
Administrator on 5/6/2019 3:55:08 PM
Thank you for the suggestion! This has been added to our roadmap and will be considered for a future release.
Regards,
Kim Nelson
Program Manager, Project management and accounting
Microsoft