You’re offline. This is a read only version of the page.
Hi All,
I have stumbled across an issue this morning with a payment that I have voided.:
I had entered a Supplier payment that I had posted by accident a couple of months ago. I realised there was a mistake and voided it on the same month.
The I posted it again the following month and tried to apply it to the relevant invoices/debit notes. I noticed while doing this that certain debit notes had a zero balance and some were showing a balance.
I have a credit note that I can search "Transaction by Document" for by number: XYZ123. When I search for it, it is returned in the grid showing against Creditor ABC. When i drill into the detail of the note, it shows "Creditor not found".
When I search for "Transaction by Creditor" for Creditor ABC, the credit note XYZ123 doesn't appear in the results.
I have run a Checklinks and it picked up an issue with the credit note, the message was something along the lines of: "The Tax rows have been removed for this transaction". But it hasn't resolved the issue with the note.
Any assistance would be greatly appreciated and as always, thanks in advance.
Alex
*This post is locked for comments
Hi,
One risk is that dynamics may have so other code running for those delete/update procedures that you aren't aware of. Just be sure you have a complete backup of your database Just in case it doesn't turn as we expect. If you have found the record and can complete the missing codes, that could be the best answer. You could potentially get the document pack in a Work state.
Kind regards,
Leslie
Hi Mick,
Thankyou for your suggestion.
I managed to find the record in PM20000 by VCHRNMBR. It seems like there are other fields missing from the record such as:
- DOCNUMBR
- BACHNMB
The CURTRXAM Amount is also set to 10.60 however the DOCAMNT is 0.
The reocrd just seems corrupt to me. Are there any implications with repopulating that table with the correct details?
Many Tanks
Alex
You would most likely find the VENDORID is missing in the PM20000 Table for that record.
The reason it displays on the Transaction By Document Window, is that detail comes from the PM00401 Table.
UPDATE PM20000 SET VENDORID ='ABC' WHERE DOCNUMBR = 'XYZ123' AND VENDORID = ''
Mick
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,113
Super User 2024 Season 2
#2
Martin Dráb
229,918
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (