Announcements
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
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.
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
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.
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.
#1
Almas Mahfooz
3
User Group Leader
Share
Report
All responses (
Answers (
