We seem to struggle with the AR Advance Billing and Deposit and are looking for any suggestions/workarounds that others may be using to make this work and report correctly. I have outlined our situation below, thanks.
When requesting an advance payment from a customer we enter an Advance Billing Invoice:
AR Invoice Entry – New Advance Billing or New Advance Deposit
This is entered by identifying the SO and Line that the advance payment will pay for.
The customer then pays the invoice and the shipment is clear for release.
If there is only one release – the shipment is invoiced, showing the advance billed amount deducted from the balance due and the Advance Billing/Deposit report no longer includes the amount .
If there is more than one release – the first release invoices the same as above. The additional releases invoice showing the advance billed amount deducted, but the amount is not removed from the report. The Advance Billing/Deposit report no longer balances with the G/L account. The Epicor fix involves additional invoices and credits which then do not give a true picture when looking at the customer statement. Or Epicor suggests you wait and invoice after the last shipment. This is not an option for our record keeping.
We were thinking of entering a credit to offset the advance billing and then enter the payment received as unapplied cash. We could then apply partial amounts to cover the invoices generated with each shipment. Unfortunately, this becomes a very manual application and the customer invoice no longer shows the advance payment as a deduction on the invoice.
