web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics AX (Archived) / Where did the Payment ...
Microsoft Dynamics AX (Archived)

Where did the Payment go? Credit memos and cash payments to paid invoices?

(0) ShareShare
ReportReport
Posted on by Community Member

I've been getting requests lately to find which invoices and customer transactions a payment was applied to in AX 2009. This isn't too bad for me to do since I can just run a few queries and get to the bottom of things. I've been debating whether or not to add a tool to AX to do this, but I can't help thinking that it's probably already in there ... somewhere.

Does anyone know how my end users can do this on their own? Specifically, they are going to start with a customer number and either a cash payment voucher number or a credit memo invoice number. They will be successful if they can get one or more invoice numbers where the payment was applied to.

*This post is locked for comments

I have the same question (0)
  • Suggested answer
    Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at

    Hi Frazier,

    Are the payments directly posted against a bank account?

    If this is the case then you can make use of the bank module reports and inquiries to identify what payments have been made and settled against which invoices.

    Best regards,

    Ludwig

  • Community Member Profile Picture
    Community Member on at

    I don't think so. None of our customer records have the bank account field populated. I think they are posting to the customer account. Then at a later date or time another employee will settle one of the customer's invoices with the credit using open transaction editing. Fast forward into the future and the customer wants to use the credit on an order, but our AR clerk replies that it has already been used. And the customer says "what for?" And he answers "I'm not sure". Then he comes to visit me. I can query the customer transactions table by looking for the CUSTTRANS record whose invoice number matches the credit memo or I can query the CUSTSETTLEMENT table looking for records whose OFFSETTRANSVOUCHER matches the payment voucher number. From there I need to cross reference the customer transaction whose voucher number matches the last settlement voucher. Once I do that it's not too hard to open the customer transactions in the AX client, navigate to the one returned, and use the history button to see the settlement. This allows someone to see what the paid the bill on an invoice, but my end users would like to see what invoices got paid. I hope I'm phrasing this correctly and I appreciate your time and patience.

  • Verified answer
    Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at

    Hi,

    The AP side has a payment history functionality available at the vendor master level.

    It's not to difficult to make it also available for customer payments.

    Maybe that can be an option for you.

    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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1
Martin Dráb Profile Picture

Martin Dráb 4 Most Valuable Professional

#1
Priya_K Profile Picture

Priya_K 4

#3
MyDynamicsNAV Profile Picture

MyDynamicsNAV 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans