D365 Finance & Operations and Dynamics AX Forum

 View Only
Expand all | Collapse all

Customer retention on Milestone invoices for Fixed Price projects

  • 1.  Customer retention on Milestone invoices for Fixed Price projects

    Posted Sep 11, 2019 05:33 PM
    Edited by Christopher Ho Yee Sep 16, 2019 01:14 PM

    Hi Community,

    Hoping someone can help shed some light on this issue. 

    We would like the system to calculate customer retention amounts on Milestone invoices on Fixed Price projects and we are trying to determine how to do so. In the process of testing, we are unable to get this to work.

    We are on version 10.0.4, platform version: Update 28 (7.0.5314.35441)


    • Are you not able to do this by design?
    • Have we missed some configuration?
    • Is this a bug?

    Issues we see:

    • Even though customer retention terms are entered on the Project Contract, they do not default to the retention % field on the Milestone.

    Project contract


    Project Milestone


    • When generating the Invoice proposal for the milestone billing, the retention % does not default.


    • Even though there is a manually entered retention % on the Invoice proposal and the totals reflect the retained amount, the retention is not deducted when posted. The invoice posts at $ 100,000 value as opposed to the $ 90,000 value.

     Invoice totals

    Posted Invoice transaction


    Posted Journal Voucher


    Our configuration is as follows:

    • Setup Ledger account for Customer retention 


    • Setup Account for automatic transactions for Customer retention


    • Setup number sequence for customer retention terms


    • Setup Customer retention terms


    • Setup Shared Category, Project Category and Category Groups 

    • Customer retention terms are on the Project itself. 

    Appreciate any insight the community can offer.

    Christopher Ho Yee
    Altius Consulting
    Richmond BC

  • 2.  RE: Customer retention on Milestone invoices for Fixed Price projects

    Posted Apr 02, 2022 08:17 AM
    Edited by Raj Chattopadhyay Apr 02, 2022 08:17 AM
    Hi, Can anyone suggest about the solution of the reported issue.
    I am also facing the same issue.

    Raj K. Chattopadhyay

If you've found this thread useful, dive deeper into User Group community content by role