Skip to main content

Notifications

Microsoft Dynamics GP (Archived)

Payment - Purchasing Module

Posted on by Microsoft Employee

Hi,

I have done a payment to a vendor (Purchasing Module) and assigned a number of invoices to this payment. I had posted the payment in question but then realised that two of this invoices where applied to by mistake.

Is there a way to have these two invoices open again please? And allocated the payment again correctly?

Best regards,

*This post is locked for comments

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Payment - Purchasing Module

    Hi,

    I have done the below and found these as my findings.

    The payment is showing as voided in Dynamics GP which that is correct.

    When I checked for the invoices in the PM20000, these were not there but instead I found them in PM30200 table which represent the Historical Paid Transactions. That is why they are still showing as History.

    In the PM10201 there are no records related of the voided check.

    Thanks and regards,

  • Frank_Heslin Profile Picture
    Frank_Heslin 895 on at
    RE: Payment - Purchasing Module

    If you look up the payment, does it show as being voided?

    To research this is going to require access to sql.  

    For the invoices, I would check to see if the Current Transaction Amount (CURTRXAM) in PM20000 is equal to the amount that was applied from the now voided check (or equal to the Original Amount {DOCAMNT}).  It should not be zero.

    I would also make sure that there isn't a record in PM10201 related to the voided check.

    Let us know what you find.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Payment - Purchasing Module

    Hi Frank,

    Yes, that is what I am finding strange that they are being kept in History.

    I opened one of the invoices and found that the Unapplied amount is showing as 0 which means it is still looking as fully applied. While the original amount is showing the original amount of the invoice.

    Regards,

  • Frank_Heslin Profile Picture
    Frank_Heslin 895 on at
    RE: Payment - Purchasing Module

    That should not be the case!?!  Once you void a payment, the invoices that it was applied to should move to OPEN status.  Even if there is another payment applied to the invoices, there should be a remaining amount.  I just did this on my test box, and the invoices now show as OPEN.

    If you look at one of the invoices is the Unapplied Amount different than the Original Amount?

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Payment - Purchasing Module

    Hi Frank,

    Thanks for your reply. I have voided the payment from the Historical as stated.

    When I tried to do a new payment and apply it to the same invoices I was not able to since the invoices are still showing as history.

    Do you have any idea what needs to be done to have these invoices open again so I can re-apply payment.

    Regards,

  • Suggested answer
    Frank_Heslin Profile Picture
    Frank_Heslin 895 on at
    RE: Payment - Purchasing Module

    You will have to Void the payment; either Historical or Open depending on if the payment is fully applied.  This will open all documents that were paid by that payment.  Go To Purchasing > Transactions > Void (Historical or Open) Transactions.  Then just create a new payment & apply everything the way it needs to be applied.

    Let us know if this works for you or if you have any other questions.

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!

Community AMA December 12th

Join us as we continue to demystify the Dynamics 365 Contact Center

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,149 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans