Hi,
I have a payable document in history but its not applied such that outstanding amount is greater than 0.
Is there a routine to take it back to open?
If I want to move it using Sql which other table have i left apart from pm20000,pm30200,pm20100,pm30300,pm00400.
RomRyan
*This post is locked for comments
Try to run the Check Links(Dynamics GP-->Maintenance-->Check Links) for Payables Transaction Logical Files & Payables Historical Logical Files in Purchasing Module.
Note: Before running Check Links, make sure you have latest back up of your company database.
Hope this helps!!!
Have you checked whether the invoice is voided(If this invoice voided, then you can see the * symbol to the document origin of the payables transactions inquiry window)?
or Run the below query against your company database as attach the result.
select VCHRNMBR,VOIDED,*From PM30200 where DOCNUMBR = 'XXX'
Note: XXX replace with your invoice document number
select *from PM10200 where APTODCNM='4000' and APTODCTY=1 and APTVCHNM='XXX'
select *from PM30300 where APTODCNM='4000' and APTODCTY=1 and APTVCHNM='XXX'
Note: XXXX replace with your invoice voucher number which is return from the first column of first query mentioned above.
Hope this helps!!!!
You can move the Payable invoices from history to open by voiding the applied payable payments for those invoices. But, can't move the Payable Payments & Voided Transactions from history to open.
Back-end update is not a recommended solution. I would not suggest.
Hope this helps!!!
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,280
Super User 2024 Season 2
#2
Martin Dráb
230,235
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (
