web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Microsoft Dynamics GP (Archived)

AP Voucher Apply Issue

(0) ShareShare
ReportReport
Posted on by 582
Open Voucher and the process of applying a Manual Payment to that Voucher got interrupted by an error.
“An open operation table ‘coPeriodCache’ has filled the disk.” 
so even though the Payment was showing as unapplied, the voucher went into a state where it was showing OPEN but nothing was available to Apply.
Unfortunately, one of the troubleshooting steps that was taken was to run Check Links (without doing a backup) which marked the Voucher as HIST, but there is nothing applied and the Payment was still showing as OPEN. 
Customer deleted the unposted Payment, because as of this moment there is no way to record that payment and have it applied to the Voucher.
Attempted to remove the Historical Transaction through Utilities and received an error "unable to remove this transaction and open apply record exists"
Is it possible to temporarily un-check "Post to General Ledger" in Purchasing and re-enter the voucher, post it and then re-enable "Post to General Ledger" and then enter and apply the payment to the re-entered Voucher?
 Otherwise, I am pretty sure I am in a territory where there is some sort of backend database edits that I need to do, but I am not the least bit confident in what that might be.

*This post is locked for comments

I have the same question (0)
  • Community Member Profile Picture
    on at

    Can you void the historical voucher? If you can not void, then there are 2 tables to check

    PM10200 and PM20100

    They will have the orphan apply information that prevented the utilities

  • Suggested answer
    Lyn Barr Profile Picture
    1 on at

    Try running the Payables Reconcile Utility, to see if that might clear out the apply record. (Microsoft Dynamics GP >> Tools >> Utilities >> Payables >> Reconcile)  You can limit the reconcile process to just this vendor, if you like. I would probably run the reconcile once for each of the first four options (summary, fiscal, calendar, batches).

    If you can get the apply record cleared, you should then be able to remove the voucher from history, so that you can truly just re-enter it.  If the reconcile utility doesn't clear the apply record, you probably do need to have someone go into SQL to find & remove it.

    You can enter a non-GL-posting replacement voucher, if you like, but it might cause problems with your subledger-to-GL reconciliation and/or your historical payables trial balance report. - Nothing that can't be fixed, but something to keep an eye on & to be aware of. BTW, if I were entering a "non-gl-posting" voucher, my method would be to simply debit & credit the same GL account, thereby negating any GL update. IMO, that is easier & faster than turning off GL posting.

    Post back if you need help or have more questions.

    Good luck!

    ~Lyn

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Meet the Microsoft Dynamics 365 Contact Center Champions

We are thrilled to have these Champions in our Community!

Congratulations to the March Top 10 Community Leaders

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans