Home › Discussions › Questions & Answers › Cost Variance Analysis for Invoicing

Cost Variance Analysis for Invoicing

Avatar photoCustomer Questions & Answers 7 replies

We need to analyze variances generated during the invoicing process, specifically Invoice Price Variance (IPV) and Exchange Rate Variance (ERV) for a specific date range of payables invoices. Which Blitz Report should I use?

7 replies

  • Support Enginatics

    Use the CAC Invoice Price Variance report. It displays IPV, ERV, and A/P Accrual Write-Off Variances for an entered date range.

  • How does the report distinguish between IPV and ERV in the output?

  • Support Enginatics

    For a given invoice line, both the IPV and ERV amounts will be shown on the same row, in separate columns, and these entries have the Type ‘IPV-ERV’.

  • Does the report also capture A/P Accrual Write-Off Variances, and if so, how are they categorized?

  • Support Enginatics

    Yes, the report includes A/P Accrual Write-Off Variances, which appear as separate rows with the Type ‘INV WO’ for invoice write-off amounts. They are included because they typically use the IPV account.

  • What two mandatory parameters define the time frame for this analysis?

  • Support Enginatics

    You must enter the ‘Transaction Date From’ and ‘Transaction Date To’, which represent the starting and ending accounting date for the payables invoices.

  • You must be logged in to reply to this post.