Home Discussions Questions & Answers Cost Variance Analysis for Invoicing

Cost Variance Analysis for Invoicing

Avatar photoCustomer March 23, 2020 at 10:21 pm

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?

Viewing 6 reply threads
  • Author
    Replies
    • Support March 24, 2020 at 12:06 pm  

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

    • Avatar photoCustomer March 26, 2020 at 3:34 am  

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

    • Support March 26, 2020 at 2:26 pm  

      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’.

    • Avatar photoCustomer March 26, 2020 at 11:05 pm  

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

    • Support March 27, 2020 at 3:09 am  

      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.

    • Avatar photoCustomer March 28, 2020 at 1:18 pm  

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

    • Support March 29, 2020 at 6:25 am  

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

Viewing 6 reply threads
  • You must be logged in to reply to this post.

Login with: