We’re having an issue allocating payment made from this supplier to their various invoices in GP. The invoices are showing as open on the system which means that no payment have been applied to them. However, when we go to apply the payment to them, the system is saying that all those invoices are fully applied.
*This post is locked for comments
Doing a quick read of what Leslie posted 2 years ago, I would believe it still applies. This is very much core of the Payables module and I don't believe that the tables have changed.
Make a backup of your company data before you try any of the steps outlined above. While good in practice, it can cause great deal of pain if you make a mistake. Better to have a backup first.
Hi,
I am having the same issue, but when I inquire about the document. I can see the document in OPEN transactions.
Will it be the same solution for me what you mentioned Ms Leslie Veil?
Thanks for your support.
Hi thanks for helping me out i was away
Leslie - i found very difficult to identified My db as am very little working with GP db. i will try my best to fix this i will give update.
Yes, both invoices and payment are still open
Alfred,
First I'm going to presume that when you do an inquiry, you do not see your document number in both the Open and History tables.
Do you have access to the SQL tables? I've seen this come up when the Current Transaction Amount is wrong.
Here's what I'd check.
1 First, get the voucher number of the problem document
2 Open the PM20000 table, find your voucher number in the VCHRNMBR field.
3 Compare the DOCAMNT value to the number in the CURTRXAM field. If they match, the system thinks the document is fully applied.
4. Next, open the PM10200 table to see if there are any records actually applied to that document.
5. Look for your voucher number in the APTVCHNM ( applied to voucher number) field. If you find it, go to the APFRDCNM (applied from document number) field and record the number.
6. Finally, look at the VCHRNMBR (voucher number) field. This will be the voucher number of the document that the system thinks was applied to that document. Go look for that voucher number in the PM20000 table.
In the event that the applied to document is in the history file and the document itself is in the open file, look here:
7. Open the PM30300 table and look for the same information that you did in the PM10200 table.
That's all I've got. I have successfully changed the current transaction amount if that's the only thing I could find messed up and all worked out. There are more tables than just the ones I mentioned, so i wouldn't try this at home unless you are very familiar with the data model.
Kind regards,
Leslie
As usual Leslie is spot on. The trick is to see if you see any payments applied to these invoices. If you do you can investigate. If not, rebuilding the Payables Key Master file may help. If that does not work then it may be best to open a support case with Microsoft because some back-end data manipulation will be in order. It may be that at one time a batch was entered with payments for these invoices but was then deleted and some of the data was not completely removed. Running check links will fix this. Make sure you run a backup before running check links.
you mean Enquiry->Purchasing-> There is no Transactions By Vendor only Transaction by Creditior, Transaction by Document and Payables summary...
#1
André Arnaud de Cal...
291,391
Super User 2024 Season 2
#2
Martin Dráb
230,445
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (
