Anyone found an easy way to track AP Prepayments? I am trying to create a crystal report, but finding there are several roadblocks and the report is quickly becoming unmanageable.
Here is the email from my customer. Has anyone had luck with BI Explorer or something else? Or am I destined to create the report from Hell??
""I am more looking for what is sitting on PO's waiting for invoicing. For example: I have placed on PO XXXX $50,000.00. I have been invoiced $15,000.00. Ideally I would like to have a report that says $8000.00 was invoiced #12345 -- $7000.00 was invoiced #12346 -- $35,000.00 remaining on prepay. I could pull the report to show what is applied and what is left in prepayments for several PO's and vendors.""
(This would also need to take into consideration any prepayment amounts that are applied to PO's that have not yet been invoiced... but if invoiced not received, it would show on both the PO and the AP Invoice History) Am I over-thinking this?