Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / Check listed as Both O...
Microsoft Dynamics GP (Archived)

Check listed as Both Open and Hist with Zero $ amount S/B History Only, Fully Applied

(0) ShareShare
ReportReport
Posted on by Community Member Microsoft Employee

I attempted to fix a batch which got hung up in the posting process.

Originally there wasn't a record in the PM00400 table for the Payment. I inserted the proper value there, and verified that the data in the PM30200; PM30300; and PM30600 tables was correct.

However when I do a Document Inquiry for Check # 1234, it appears as both Open and Hist as a PMT for the proper vendor. When I inquire Checks # 1233 through 1236, the other checks appear to be correct.

When I inquire these documents in the PM00400; PM30200; PM30300; and PM30600 tables, all appears to be uniform.

I ran a Reconcile routine for Only this Vendor, which resulted in the Open Document being deleted from the PM20000 table, and the Vendor now showing as a Zero Balance. (Correctly BTW.)

I'd like to have the information on the UI be 100% consistent with what I know to be correct on the system. Therefore, if I have to run Checklinks, I'll do so (Although I prefer not to.)  Also, if there are any other tables I could review to compare a valid transaction to this one, I'd appreciated your input. (We don't have any records in the PM30700 or PM30800 tables.)

Regards,

J. Falk

*This post is locked for comments

  • Suggested answer
    soma Profile Picture
    soma 24,406 on at
    RE: Check listed as Both Open and Hist with Zero $ amount S/B History Only, Fully Applied

    If you want to confirm the information on UI be 100%, run the AP Trail Balance report for this vendor and also check the applied documents belongs to this vendor payment to check whether if anything is mismatch to this vendor. I hope your vendor transaction is corrected now.

    Hope this helps!!!

  • Mahmoud Saadi Profile Picture
    Mahmoud Saadi 32,738 on at
    RE: Check listed as Both Open and Hist with Zero $ amount S/B History Only, Fully Applied

    Hello Mr. James

    It's one of the first times that I go through such a case, in which the person has completed almost 99% of the home work,  I am really impressed !

    As I said, your troubleshooting is quite thorough and correct. Although, I am a bit puzzled about one point, now the duplication has been removed and the transaction exists where it is supposed to be. Are you seeking further assurance ? What do you mean exactly by "I'd like to have the information on the UI be 100% consistent with what I know to be correct on the system" ?

    I suppose your posting corruption is handled for this specific transaction, do you mean you want to apply quality checks on all the posted transaction to ensure that everything is properly posted?

    Looking forward to hearing from you

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!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,235 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans