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!