Reconcile an Order for a Commodity Vendor

When an order is invoiced (manually or electronically) for a vendor with the "Use Line-Item Credits to Adjust Invoice Price" preference enabled, the Vendor Order Reconcile screen displays additional columns for these orders.

Note: These instructions are specific to orders fulfilled by vendors configured to supply commodity products.
For detailed steps to reconcile orders, see "Vendor Order Reconcile Screen".

Product Columns

Lot Flag (not labeled) – A red flag will appear here if Lot Numbers are required on the Allocate tab. These flags will turn green once they have been entered.
Product Number – Displays based on 'Show Vendor Numbers' or 'Show Company Numbers'.
Product Name – Displays based on 'Show Vendor Numbers' or 'Show Company Numbers'.
Order Quantity – Displays the order quantity followed by the "Order Unit" along with the order unit Conversion to the vendor unit.
Unit Price – Displays the price per vendor unit from the original order.
Invoice Quantity – This must reflect the quantity on the vendor's invoice.
Physical Quantity – This must reflect the actual quantity received.
Unit – Displays the Vendor Unit from vendor bids in Enterprise Manager.
Conversion – Displays the vendor conversion from Vendor Bids in Enterprise Manager.
Contract Price – Displays the vendor's Bid Price effective for the actual delivery date of the vendor product; this can only be edited by authorized users.
Vendor Invoice Price – This must reflect the price on the vendor's invoice.
Credit Value – This must reflect the credit or allowance from the vendor's invoice that will be used to adjust (discount) the receiving value of the line item.
Invoice Price = [ ((Invoice Quantity x Vendor Invoice Price) + Credit Value) ¸ Invoice Quantity, rounded to 4 decimal places ]; this cannot be edited by the user. This is the price that will be used to update the inventory cost and displayed in the purchasing reports. (This therefore requires that the vendor preference for "Update Product Pricing Based On" be set to 'Invoice Price' or 'Lowest'.)
Invoice Extended Value = [ Invoice Quantity x Invoice Price ]
Tax Value = [ Invoice Extended Value x (1 - Total Tax Rate for the selected "Tax Code" ]
Tax Code – Displays the tax code from the original order.
Gross Extended Value = [ Invoice Extended Value + Tax Value ]