Update Unit Cost Button
Click this button to update the unit cost of the selected records. These are formulas that are applied to calculate the unit cost of the current item:
Formula | Description | Definitions |
---|---|---|
TVA * LIUC = LI | Multiply the cost for the line items not related to the current line item by the To VoucherAdjust amount. This cost represents costs tied to this item. |
LI = Line Item LIUC = Line Item Unit Cost TVA = To VoucherAdjust |
LI + LI + LI... = OLI | Add the line items calculated above. | OLI = Sum of Other Line Items |
(DA - OLI) / TVA | Subtract the sum of line items from the distribution amount, then divide by the To VoucherAdjustment amount. |
TVA = UC UC = Unit Cost DA = Distribution Amount |
EXAMPLE: Three PO line items from one PO line were received at $35.00 each for a total of $105.00. When the invoice was received, the vendor gave a price break. The actual cost invoiced for the 3 items was $100.00. When the voucher is generated, the Unit Cost of each item must be recalculated to match the total invoiced amount (entered in the Dist Amt field) of $100.00.