Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics GP (Archived)

Payment applied to incorrect account

(0) ShareShare
ReportReport
Posted on by Microsoft Employee

Hi everyone,

We are having a small problem with payments in GP. We created invoices to be imported into GP using Integration Manager. Everything imported correctly. But when we went to apply the payment, it used an incorrect account for accounts receivable. I know that we have GP Sales Order Processing setup for accounts to be posted by item, but these invoices had no items with them. Also, I checked and we have all of the accounts set up correctly in the the Posting Accounts window. I am wondering if the item setup affected how the payment was applied. 

If there is no inventory item that goes with the invoice, where does GP pull the account from?

Or am I thinking about this completely wrong and is this a problem with how we set things up in the integration?

Thanks,

RM82

*This post is locked for comments

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Payment applied to incorrect account

    If you want a different AR account, that should be done at the invoice level.  If you have the invoice debiting one AR account and then crediting another when the payment is applied, that would definitely make a mess for your accounting department.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Payment applied to incorrect account

    Thank you! That helps clarify. I looked back at the invoice and it is using that account. Just out of curiosity, is there any way to change the AR account when you apply the payment to the invoice if you don't want to use the same account that is on the invoice?

  • Suggested answer
    L Vail Profile Picture
    L Vail 65,271 on at
    RE: Payment applied to incorrect account

    Hi,

    When the cash receipt comes in and is applied to an invoice, the original AR account for the invoice is used. If the receipt isn't applied, it is posted to the default AR account at the Customer, if none is specified at the customer, the default company posting account is used. If you initially do not apply it and then apply it later, the AR account is not changed to match the original invoice.

    The item does not have an AR account.

    Kind regards,

    Leslie

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

Congratulations 2024 Spotlight Honorees

Kudos to all of our 2024 community stars! 🎉

Meet the Top 10 leaders for December

Congratulations to our December super stars! 🥳

Start Your Super User Journey

Join the ranks of our community heros! 🦹

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,458 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans