910
One of my users have posted vendor payment through the manual payment screen in the purchase module, the payment is not showing in the purchase module, vendor ledger, GL or Bank ledger but the invoices have been reduced to 0 amounts. Now, when the user tries to knock-off the invoice from another payment MS GP is not allowing it as the invoice amount is 0. Kindly provide solution as to how the invoices can be applied again.
*This post is locked for comments
Dorothy, the first thing I would try is running Checklinks on the Payables tables (Payables History and Payables Transaction Logical Files). I doubt that will fix it but it's worth a try. If that doesn't work, then you're going to have to perform some surgery on the records in the Payables tables to clean up the mess that your system freeze created. You' may need to get your GP partner involved to help with this if you don't have the requisite knowledge in-house.
Hope this helps,
This is a one-time thing. I was recording a manual payment. I applied the document to three invoices and clicked post (no batch). My system froze up and I had to restart my machine. When went back in the manual check was not posted but the three invoices that it applied to all show open but fully applied. I cannot find the check anywhere in the system and I cannot select these invoices to be paid. My AP aging report does not agree with my GL account so the aging report is acting as though the check cleared those invoices.
I have no idea how to post a record from the PM10200 table.
Hi Ahmed,
Can you post the record from the PM10200 table.
Depending on what state it is in, it might be easier to delete the transactions - but there will be other tables affected (the PM apply to for example). It warrants further digging to see exactly what went wrong. Is there any trace of it in the PM History tables? you will want to search by the vendor ID etc as the document number could be blank in history.
Dorothy, is yours an isolated issue or is it recurring?
We are having the same issue - has anyone found a solution yet?
I have found the data for this payment, it is residing in PM10200 but not showing in MS GP or smartlist. Kindly suggest should i delete the record from the database or update the record.
thanks for your reply.
The invoices are open, we have tried check links, reconcile, void document, nothing works.
How can we solve this any suggestions.
This is data corruption. First try a check links. If this doesn't resolve the issue, you're into looking at the data in SQL to try and find out exactly what went wrong.
It might be as easy as resetting the current transaction amount in the PM tables - but you won't know until you look into the data.
Are th Invoices classed as Open or History in the Vendor Enquiry window?
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,280
Super User 2024 Season 2
#2
Martin Dráb
230,214
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (