Finance | Project Operations, Human Resources, ...

Payables actual void date?

(0) Share

Report

Posted on by Linda Brock

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

Categories:

Microsoft Dynamics GP

All responses (2)

Answers (0)

Suggested answer

Josh Page on at

Like (0)

Report

RE: Payables actual void date?

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'
Leng Papio 855 on at

Like (0)

Report

RE: Payables actual void date?

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.