Some of the raw materials we purchase are advanced payment methods.
But, I had to figure it out myself because there was no procedure or training on the advance payment processing process.
The entire process of processing the advance payment as I understood it is as follows. Could you please let me know if what I have figured out is correct or if there is a process that needs to be added?
Purchase Order Entry : Create a purchase order
AP Invoice Entry : Create an advance payment AP invoice with that PO
Payment Entry : Create a payment with that advance payment AP invoice
Receipt Entry : Create a Receipt when the raw material is actually received
AP Invoice Entry : Create an AP invoice with that Receipt (Put the previously created Adv Invoice into the Ref Invoice field)
Apply Debit Memo / Prepayment (I’m not sure if this is required or not)
I’d really appreciate it if you could let me know if I’m misunderstanding something.
On the AR Side, when you generate the shipment invoice, lets say for $500, if you have an advance billing for the Sales Order for say $100, the invoice is automatically generated for $400.
I assume it is similar to AP, but I could be wrong, be sure to test it.
Yes, although one is a “Prepayment” and the other is an “Advance Billing”, I guess it depends on each companies specific process, how you receive the money from the supplier, and based on that which one to use. Test both and choose the one that aligns better with your company.
I am a bit late to the party but have been trying to put the same process down on paper and trying it out. I have done exactly what you have done in the steps that you have taken but I find that when I get to creating the final invoice for the receipted goods Epicor tells me that the Adv Pay is automatically populated with the sum of any advance payments but this is not the case in my example as the field although enabled is empty. I ran a BAQ and the PODetail.AdvPayBal (which is apparently where the figures comes from) does indeed show the advance payment balance but Epicor does not bring it onto the invoice detail screen and if I enter it manually it is not accounted for in the group edit list which makes me think I am missing a step somewhere.
Thanks Greg - that is the exact method I am following but the advance payment is not showing in the less adv pay field. I will try again and document each step before submitting a case to support as I am obviously doing something wrong.