Background: AP Price Variance Report

Use the AP Price Variance Report (NPV) program to print a report for your login branch that compares the PO unit cost with the invoice cost. See Road Map for work flow.

The costs are rounded to two decimal places. For example, 1.02549 rounds to 1.03.

The report includes this information:

  • Item number

  • Vendor number

  • Purchase order number

  • PO line

  • Purchasing branch

  • Item description

  • Vendor Name

  • Receiver number

  • Receiver line number

  • Date received

  • Invoice number

  • Currency

  • Cost:  Standard unit cost if you selected S for the Use S=Standard cost or M=Std matl cost Program option

    Standard material cost if you selected M for the Use S=Standard cost or M=Std matl cost Program option

    Cost per piece from the purchase service operation if you selected S for the Use S=Standard cost or M=Std matl cost Program option and the purchase order is for outside service.

  • Quantity received

  • Purchasing unit of measure

  • PO cost/Pur UOM: PO cost for each purchasing unit of measure

  • Inv cost/Pur UOM: Invoiced cost for each purchasing unit of measure

  • Var for Pur UOM: Invoice cost - PO cost

  • Ext var f/pur UOM: Variance x Quantity received

  • Var from std: Invoice cost - Standard unit cost if you selected S for the Use S=Standard cost or M=Std matl cost Program option

    Var from std matl: Invoice cost - Standard material cost if you selected M for the Use S=Standard cost or M=Std matl cost Program option

    0 for a non-stock item.

  • Quantity paid

  • Unit of measure conversion

  • PO cost/Stk UOM: PO cost for each stocking unit of measure

  • Inv cost/Stk UOM: Invoiced cost for each stocking unit of measure

  • Var for Stk UOM: Invoice unit cost - PO unit cost

  • Ext var f/Stk UOM: Variance x Quantity received

  • Ext var f/std: (Invoice unit cost - Standard unit cost) x Quantity received) x Unit of measure conversion if you selected S for the Use S=Standard cost or M=Std matl cost Program option

    Ext var f/std matl: (Invoice unit cost - Standard material unit cost) x Quantity received) x Unit of measure conversion if you selected M for the Use S=Standard cost or M=Std matl cost Program option

The report includes these totals:

  • Total number of purchase orders

  • Number of POs with low variance

  • Number of POs with high variance

  • Total extended variance from standard cost if you selected S for the Use S=Standard cost or M=Std matl cost Program option

    Total extended variance from standard material cost if you selected M for the Use S=Standard cost or M=Std matl cost Program option

  • Total extended variance from PO cost

  • Total extended variance from standard cost if you selected S for the Use S=Standard cost or M=Std matl cost Program option

    Total variance from standard material cost if you selected M for the Use S=Standard cost or M=Std matl cost Program option

  • Total extended purchase order cost

  • Total extended invoice cost