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.
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.
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.
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.
Converted from CHM to HTML with chm2web Pro 2.85 (unicode) |