Notifications
Announcements
No record found.
Hi,
Is there any way to tell the actual date that a payable transaction was voided?
I know you can look at the Void GL Posting Date and the Void Date to see when it was voided in payables and in the GL, but is there a way to find out exactly when it was voided in real life?
Thanks,
Linda
You will need to use SQL and see the PM30200 table, where voided = 1 and restrict by the voucher number... i can't remember exactly the field name, but you can also check the dex_row_ts (i think).. which is a time stamp when the record was created (i think)... the moment the void happens, the document will be moved to the PM30200 table.
Another option that's dependent on a setting.
Go to Tools>Setup>Posting>Audit Trail Codes.
Select purchasing.
If you have a checkmark for reprint next to the void open\historical options you can check the pm reprint tables.
80100 for headers (if you know the audit trail code of the batch)
80200 for payment voids
80300 for everything else.
As an example, you could use the below script.
select a.POSTEDDT,b.VCHRNMBR from PM80100 a join
PM80200 b on a.TRXSORCE=b.TRXSORCE
where b.VCHRNMBR='XXXXX'
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.
As AI tools become more common, we’re introducing a Responsible AI Use…
We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Martin Dráb 659 Most Valuable Professional
André Arnaud de Cal... 533 Super User 2025 Season 2
Sohaib Cheema 289 User Group Leader
