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 GP (Archived) / Open AR invoices showi...
Microsoft Dynamics GP (Archived)

Open AR invoices showing payments

(0) ShareShare
ReportReport
Posted on by Community Member

I am having an issue with some "received" payments in the Sales module. I have a number of invoices for two customers that have payments attached however my AR clerks have no record of these payments. If I pull up one of the invoices in question in the Sales>Transaction by Customer it shows as Open, however when you pull up the Receivables Transaction Inquiry Zoom window and click Apply you can see a payment associated with that invoice. I have run Check Links against the entire Sales module and have also completed a Reconcile on Current Customer Information and Outstanding Document Amounts but get no results indicating issues with the customers in question. How do I get the payments removed so we can apply the real payments to them?

*This post is locked for comments

I have the same question (0)
  • Tim W Profile Picture
    Tim W 2,925 on at

    Should '...and click Apply you can see a payment ...' be 'can't' see a payment?

    If not, and you have the AR Invoice as 'open' and see the payment that seems correct to me.  When SOP posts an Invoice with a payment an RM Open document gets created, a payment gets created and they are applied to each other.  Open in RM is posted, Hist in SOP is posted.

    I might be missing something here.

  • Community Member Profile Picture
    Community Member on at

    Tim,

    Thank you for your response.

    What I wrote is correct. The payments attached to these invoices were applied accidentally or by magic. (I'm not being funny, my AR department can't give me a straight answer on why these payments are on these invoices.) All of these invoices show in the RM20101, Open Transactions, table.

  • Tim W Profile Picture
    Tim W 2,925 on at

    That is standard function assuming you have taken a payment in the SOP (Sales Order Processing) Payment window off the Sales Entry window.  When you post that invoice (with a sales payment record in SOP10103).

    We love this (use it as a cornerstone of our integration automation), it really is magic.

  • Community Member Profile Picture
    Community Member on at

    That is the problem, these payments are erroneous and don't belong to the invoices. This money was received through Cash Receipts.

  • Tim W Profile Picture
    Tim W 2,925 on at

    Ahh.. I see.

    If the payments are still open (likely, as you said RM20101) you can just un-apply the payment from the apply window.  Sales - Transactions - Apply. Enter Customer, scroll for payment, un-apply.  RM you can apply/un-apply unless you have run paid transaction removal.  AP quite different as you have ot void to un-apply.  

    I looked at the RM apply table and it does not have a user who applied field.  Someone might have hit the AutoApply button or something.

    Best

    Tim

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 GP (Archived)

#1
Community Member Profile Picture

Community Member 2

#2
mtabor Profile Picture

mtabor 1

#2
Victoria Yudin Profile Picture

Victoria Yudin 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans