Handling Unapplied Open Balance on Purchase Order Prepayment

The ability to create purchase order prepayments was introduced w/ GP 2013R2.  With any new feature, there is almost always rooms for improvement and POP prepayments is no exception.  One of the areas of improvement is such a cluster that we felt a blog describing the issue and the necessary workaround was warranted.

Issue:

When a PO prepayment has a remaining balance and the corresponding Purchase Order is moved to history, it becomes nearly impossible to apply the prepayment to any future vouchers.

When closing a Purchase Order under Purchasing>>Transactions>>Edit Purchase Orders, the following screen appears which prompts you that there is an unapplied balance on a prepayment.

Perfect World:

All is well up until the point that the Remove Completed Purchase Orders routine is run.  During that process, there are no warnings that you’ll no longer be able to apply invoices & nothing that stops you from proceeding to create the scenario that we’ve highlighted above.  Here’s to hoping that the developers at Microsoft prevents Purchase Orders from moving to history if there is an outstanding balance on a prepayment OR they provide a more direct route to move a POP prepayment to regular payables.

Until then, this will assist you in clearing up those A/P trial balances and remaining documents come month/year-end!

Share It
Share It
Tweet It
Picture of Kyle Malone, CPA
Kyle Malone, CPA

Dynamics GP Nut | GPUG All-Star 🏆 | Techo-Functional Consultant

Leave a Comment

Your email address will not be published. Required fields are marked *

30 Dynamics GP Tips & Tricks That You Cannot Live Without

Provide your email and we’ll send you our list of 30 things in GP that will have you feeling like

Send me 30 Tips & Tricks! (absolutely free)

Top-Tier Professional Consulting
Rates Lower Than The Others

Always non-billable introductory / discovery calls

$140 hour which includes ANY/ALL GP services:

  • GP Training
  • Module Implementation
  • Everyday Support
  • Report Development
  • Integration Development

We Want to See You Get Value From Your Investment In Dynamics GP!

Contact Us

ALaCarteGP, LLC | (740) 604-0099 | Madisonville, LA