Remove or Void a PM Transaction

(0) Share

Report

Posted on by Community Member

I currently have a transaction in the following tables (one transaction), it seems that it is Posted and in History table.

Is there a way to void, delete within GP? Or could it be deleted in the back end?

[PM10200].[APFRDCNM]
[PM10201].[DOCNUMBR]
[PM20000].[DOCNUMBR]
[PM30200].[DOCNUMBR]
[PM30300].[APFRDCNM]
[PM80200].[DOCNUMBR]
[PM80500].[APFRDCNM]

*This post is locked for comments

I have the same question (0)

All responses (4)

Answers (0)

Suggested answer

MG-16101311-0 26,225 on at

Like (0)

Report

That depends what you posted. If you are referring to the invoice, it should be in the PM20000 waiting to be applied by a credit document (credit or payment). If you suspect the invoice has already been applied, you must first void the payment (Purchasing > Transactions > Void Historical Transactions), which will them move the invoice to open, from which you can once again void, if needed (Purchasing > Transactions > Void Open Transactions). I suggest you stay away from removing records at the table level in SQL as the application data model is fairly complex and you can miss key records in the process. As an example, you did not include the GL tables above in your findings.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

This transaction shows up under "Void Open Transactions" but I get the following error when clicked on the checkbox to "Void": This document cannot be marked for voiding, it has been either partially applied or is on hold.

Was this reply helpful? Yes No
Rosemary 10 on at

Like (0)

Report

Hi,

asiadynamicsgp.blogspot.com/.../gp-this-document-cannot-be-marked-for

Have a look at this document, I have used creating of the 'dummy invoice' to deal with this type of scenario.

Regards

Rosemary

Was this reply helpful? Yes No
Jen Kuntz 3,220 on at

Like (0)

Report

MALAM, I would take this message literally and check to see if the transaction is partially applied (or on hold although the likely reason is a partial apply). I would look at this document in an inquiry window to see if it has a balance. I agree with Mariano, I wouldn't attempt to clean anything up in SQL. If GP can't void it, there likely is a legit and simple answer why.

Was this reply helpful? Yes No