We are trying to start using the new POP Prepayment functionality. We have enabled the feature in POP Setup and have specified the prepayment account. The problem we are having is the GL distributions don't work at the end of the process. For example:
We create a PO to a vendor with a total price of $5000 and a prepayment of $1000.
When we create the manual payment the Vendor Advances account is debited for $1000 and the cash account is credited for $1000.
When we receive the PO, the expense account for the PO line item is debited $5000 and Accrued Purchases is credited for $5000.
When we input the invoice via Enter/Match, Accrued Purchases is debited $5000 and Trade Payables is credited $5000. Once the invoice is posted, the prepayment moves from the PM20000 (open) table to the PM30200 (history) table and is applied to the invoice.
When we pay the rest of the invoice, Payables is debited $4000 and Cash is credited $4000.
The net result is that the Cash account has a credit balance of $5000 (Correct), the Expense account has a debit balance of $5000 (Correct), the Vendor Advances account has a debit balance of $1000 (Incorrect), and the Trade Payables Account has a credit balance of $1000 (Incorrect).
I've tried running this several times in various test companies and with various vendors. Are we missing a step somewhere or what is going on that is leaving balances in both Vendor Advances and Trade Payables?
Thanks!
*This post is locked for comments