You’re offline. This is a read only version of the page.
Hi everyone,
So this is a little bit complicated but hopefully I can relay our issue clearly. Feel free to post any questions you may have.
We recently had an issue with the historical tables in Purchasing. This is basically all of the PM30000 tables. We had to go into the sql table directly and correct these issues. It seemed as if everything was fine, but at the end of the day the client informed us that they had received errors when posting their credit memos and that they had went ahead and posted 3 of them.
I was able to go back into sql and find where the errors were located and fix them. Now the issue is the 3 credit memos that were posted. I cannot find the transactions in GP or the tables. If I pull up the invoice, I can click the apply button and see the Credit Memo and that it applied against the invoice.
For example, the invoice was for $500 and a credit memo of $150 was applied. Now the invoice shows the correct number of $350.
My question is how did this affect GP? It seems like it did not hit the historical tables at all. Would it be okay to just leave it like that? Any thoughts?
Thanks,
RM82
*This post is locked for comments
I have the same question (0)
It seems like the transaction Record is missing for the Credit Memo. Only the Apply Records was saved, so you could see applied record only. It may be better to remove the partial records for that Credit Memo and re-enter the Credit Memo. You may need to remove the Apply Records from Apply Tables.
Test everything in Test Company first.
Following Blog of Victoria Yudin has the tables that you need to check.
https://victoriayudin.com/gp-tables/pm-tables/
After deleting any Apply Record (from PM30300, PM10200) , Reset the remaining amount in the Invoice by updating PM20000.CURTRXAMT back to $500. If the damaged Credit Memo has posted amount to Financial module, enter any adjustment in Financial to undo posting by the damaged Credit Memo.
Share
Report
All responses (
Answers (
3,951
