You’re offline. This is a read only version of the page.
Invoice is showing a $0 unapplied balance on the payables side however this was never applied. We tried to void it on the payables side but the system will not let us. Please advise on how this invoice can be voided on AP only?
*This post is locked for comments
So, was anyone able to get this resolved? I have the same issue on about 50 invoices and don't know what to do.
You may find that there are orphan apply records in PM30300. You may need to delete those and then run check links to tidy everything up. Obviously, test environment or full back up before trying anything like that.
Thanks...it was worth a try.
I'm sorry, I don't remember.
What resolution did you come up with on this? I am having the same problem on a vendor but there are about 150 invoices affected. It appears that the payment that was to clear these out applied on the AP side but the payment is not showing on the vendor and it is not reflecting on the bank account and there is no open batch or recovery batch for this.
CheckLinks moved the one document from PM Transaction OPEN to History. It is still listed as $0 available balance with no transactions. I am told this morning that, when it was in open, gp generated a 'Cannot void a partially or fully applied document' error. I am only seeing option to void historical transactions, but there are no transactions listed against this document to void.
Ok, it ran overnight on the historical links, only affected a handful of current batches.
It did give an error about the stored procedure pmCLTransactionLogicalTableGrp returned the following results: DBMS: -127, Microsoft Dynamics GP: 0
I tried searching for what that error means, but could not find. Has anyone seen a DBMS -127?
I've tried to run it, but it took an hour and the program froze up. Is there any way to tell if check links is running? It seemed odd that the Error File checkbox was grayed out on top of the window when it asked if I wanted the results to go to screen, printer, or file.
Hello
This seems definitely one of the glitches encountered due to various reasons. The initial prerequisite is to run the reconciliation and check links for the payable series. Supposedly, if there are no apply records in the apply tables, the system shall recalculate the current transaction amount, applied and unapplied amount and get them updated accordingly.
If this has not been resolved, let us know so that we dig into further details.
Your feedback is highly appreciated,
Hi T -
Have you tried running Check Links for Payables Historical Logical or Transaction Logical files? Make sure you have everyone exit Dynamics GP and make a backup of your database before running this.
--Sean
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,253
Super User 2024 Season 2
#2
Martin Dráb
230,188
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (