Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics GP forum
Suggested answer

Payables document posted but showing as open - missing details

Posted on by 10

Hello! Our accounting dept reached out regarding a possible duplicate transaction but we aren't too sure what's going on.

The vendor is showing an unapplied payment which should be zero: 

pastedimage1673626644381v3.png

When I go into the apply payables document. I can see the Open document for the vendor however there is no line items, I'm assuming there should be to make up the amount?

pastedimage1673626695954v4.png

 

Only thing I can really think of is maybe the line items are posted but the header or whatever it's called for payables is still Open and needs to be processed into historical?

I tried running check links for the whole purchasing module but it didnt find anything related to this.

From searching around this is what I have been able to find in SQL.
When I look at SQL Table PM20000 - I can see the document.
When I look at SQL Table PM30300 - I see the 4 line items that make up the document amount.

Any help would be appreciated!

  • RE: Payables document posted but showing as open - missing details

    Hello, There are no line items in Payables, only POP documents.   You will have to research if this is a duplicate payment or not.   Review the records you found in the PM30300 table and see if they are applied to this particular payment.  If not, then you void the payment if it is a duplicate.    If it is the one applied to the records in history, and the apply records equal the full amount of this payment, then you can update the CURTRAMT on it in the PM20000 table and run check links again to move it to history.  If you need help, please open a support case.

    Thank you,

    Cheryl W.

    Microsoft Support

  • codyto19992 Profile Picture
    codyto19992 10 on at
    RE: Payables document posted but showing as open - missing details

    Thank you for the suggestion but I did try that with all the purchasing tables with no errors. I just tried again with just the logical table and no errors found.

    Thanks!

  • Suggested answer
    Lisa at AonC.com Profile Picture
    Lisa at AonC.com 3,024 on at
    RE: Payables document posted but showing as open - missing details

    Step 1 is to make certain you have a SQL backup.

    Step 2 is to run Check Links on Payables Transaction Logical File.

    pastedimage1673640252393v1.png

    You should get an error long that references the abandoned apply records being removed.

    You may want to ask the user if they had any issues with the vendor/transaction and whether the transaction is now showing correctly in GP/Aging.

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

Anton Venter – Community Spotlight

Kudos to our October Community Star of the month!

Announcing Our 2024 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Dynamics 365 Community Newsletter - September 2024

Check out the latest community news

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 290,537 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 228,520 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Product updates

Dynamics 365 release plans