View Average Cost Adjustments


Inventory Control Menu -> Sales Inventory/Rental Inventory -> Avg Cost Each- icon -> View Average Cost Adjustments

This utility can be used to track the changes to the average cost on this product, for all locations, or for a specific location.
The average cost of inventory can be changed several ways, including transfer rental to sale, or sale to rental, operator manually changes cost, warehouse receiving, bulk disposal, A/P invoicing, or operator changes tag information.
It can be accessed for a specific product from Sales Inventory or Rental Inventory by clicking on the icon beside the Avg Cost Each field.

The cost adjustment inquiry lists the date and time of each change to the cost, with the location, old CCQ only for sales parts (Cost Calculation Quantity), old cost, new CCQ only for sales parts, new cost, document number, and the document date.
The CCQ does not apply to rentals as costs are tracked by the Fixed Asset Tag.

Click EXP/CON or press <F9> to view additional information about the change in cost transaction including source, vendor, and any tag information.

Average cost changes for a range of products by date can be printed from Average Cost Changes Report.

  1. Cost changes from Accounts Payable purchases:
    When entering inventory purchases in A/P Invoices and A/P Invoices By P.O. the A/P invoice number is displayed in the Document field and the Description field on the second detail line will display A/P INV QTY: with the quantity on the invoice, the total gross cost, and the tag number for rental products. The Source shows as Auto.

    For sales products the average weighted cost of each item is automatically recalculated, based on the following Cost Calculation formula as outlined in Cost Calculation Quantity.

  2. Manual Cost overrides:
    The average cost for sales products can be manually changed using Update Product Costs & Prices .
    The average cost for rental products can be changed on the specific Fixed Asset Tag.

    When the cost is change manually the old cost and new cost are automatically tracked.
    The Document field in this inquiry displays the operator code and the Description field on the second detail line will display UPDATE COST: OPERATOR CHANGED COST the tag number for rental products. The Source shows as Manual.

    The dates of manual adjustments can be changed in the Product Average Cost Changes utility.

  3. Warehouse Updated the Cost:
    As an alternative to having the Accounts Payable purchases update the cost, the software can use the purchase costs from the Purchase Order to update the cost during Warehouse Receiving.

    This would apply only if Company Inventory Parameters flag to Update Avg. Cost In Warehouse is set and any inventory received was entered using Warehouse Receiving and the cost changes were posted using Post Warehouse Cost Adjustments.

    For these cost changes, Warehouse is displayed in the Document field and the Description field on the second detail line will display WAREHOUSE QTY with the quantity, total gross, and the tag number for rental products. The Source shows as Auto.
    The CCQ formula in 1. above still applies.

Note: The CCQ numbers can be reset to the current inventory quantities, using the Reset Cost Calculation Quantity (Single product) or Reset Cost Calculation Quantity (Global - all products) utilities.


Topic Keyword: RSCA02 (3944)
Converted from CHM to HTML with chm2web Pro 2.85 (unicode)