Is there a report that totals prepayments by purchase order? I am only looking for amounts that have actually been paid, not in process.
Hi
There is a AP Payment register with Prepayment drop down option,
Please review and alter the report as needed.
hello
Did you try adding Prepayment amount to the Purchase Order preview list? Users with Customization role can edit generic inquiry/Preview Lists.
If you are seeing Payments that are not open, not released, use the steps above to add APRegister DAC to your generic inquiry, and add Conditions to Conditions tab of your G.I. to include where APRegister.Status does not equal Hold, Balanced, Pending Approval, etc.
Laura
I am working on this. I haven’t quite got the right answer yet as I haven’t been able to sum all of the prepaids that make up the total for a single PO. I think it is the last step you mentioned that I need to tweak as we have some prepayments that have been paid and some that are waiting to be paid and the only ones I want are the ones that have been paid. We have more milestone payments and we set up the milestones as prepaid requests so we can track the expected date of payment.
Hello,
The Grouping setting together with the Aggregate Total = SUM is what provides the total on the Prepaids per each PO.
Laura
Thank you all for the responses. These are very helpful!
Reply
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.