Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics AX (Archived)

Customer Reserve Amount

Posted on by Microsoft Employee

A new customer for my company provides payments every two weeks with a remittance settlement report. This settlement includes payment for all the sales orders that have been paid against plus a reserve amount from the previous period, minus a reserve amount for the current period.

We are struggling with how to apply the payment. It is difficult for us to determine exactly which sales orders were held in reserve, and truthfully it doesn't always match to a specific set (the customer does not mark this). We would also desire to not have to attempt to split the previous settlement report and the current one to mark some invoices as paid and others as not. What is the best way to handle this?

We are considering treating the Reserve Amount as a deduction, then reporting it as received on the next settlement report, using the Post Dated Check functionality, implementing a clearing account, as well as simply continuing on with the manual time consuming process we currently have.

Is there a better solution? What is your recommendation?

*This post is locked for comments

  • Suggested answer
    Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    RE: Customer Reserve Amount

    Hello maklais,

    To my knowledge there is no comparable functionality to the project retention feature available in the other standard modules.

    If you have a similar requirement you can either try to extend the existing functionality and adjust it for your processes by doing some development.

    Alternatively, you check out available ISV solutions/add-ons that might have such a functionality incorporated.

    Both options will, however, cost some money.

    Best regards,

    Ludwig

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: DAX 2012 Accounts Receivable Customer Reserve Amount

    Dr. Reinhard, thank you for your fast response.

    We currently do not use the Project Management and Accounting Module and so don't have a lot of insight into it.  We had not checked that one, but looking into it, it seems close to what we would need. But it appears that we would have to set up a project for this customer? How would that work as it is an ongoing concern? This is a retail reseller and as such there is no project associated with the orders. They simply retain a certain amount from each 2 week period to cover refunds, returns, ...

    Also, since the value retained is dependent on the value of the product sold, we don't have a predetermined value or percentage to base that retention off of. From Microsoft About Customer Payment Retention
    "The retention amount for a customer invoice is automatically calculated and subtracted from the invoice amount based on the retention information that you define."

  • Suggested answer
    Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    RE: DAX 2012 Accounts Receivable Customer Reserve Amount

    Hi,

    The project module has an incorporated customer retention functionality.

    Have you checked this one and whether you can apply it for your case?

    Best regards,

    Ludwig

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,253 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,188 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans