Page tree
Skip to end of metadata
Go to start of metadata

The procedures below show you how to adjust the average cost of one or more Products. Doing these procedures creates a Transaction for each selected Product that skews the average cost of that Product. This is typically done when the Quantify database does not contain much data, such as the database of a new installation. This can also be useful when a company has data in their Quantify database and a significant amount of data in another repository and Quantify must be brought up-to-date.

Important: The Product average cost adjustment Transaction overrides any existing amounts for the last cost and/or average cost for an item.

To create a Product average cost adjustment:

1. Locate and click the appropriate Branch Office or Sub-Branch in the Organization Tree.

2. Click the Transactions tab.

3. Click the Add button () and select Product Average Cost Adjustment from the menu that appears.

The Available Average Cost Adjustment dialog appears.

4. Click the Created Date calendar icon ().

The calendar appears.

5. Locate and click the appropriate date.

6. Click in the Notes text field and enter notes for the Transaction.

7. Click the Products tab.

The Available Average Cost Adjustment dialog appears.

8. Locate the appropriate Product, click in its cell in the Quantity column and enter the quantity to purchase.

Note: In order to have accurate overall costs, this quantity should equal the total of your Product inventory at the Branch Office or Sub-Branch.  To find this total, click the Products tab for the Branch Office or Sub-Branch and refer to the Total amount.

9. Click in its cell in the Cost Ea. column and enter the cost of each one piece.

10. Repeat the above two steps as many times as necessary.

11. Click OK.

Quantify populates the Last Cost and Average Cost columns for the item in the Product Catalog.  As additional quantities of the same item are purchased using purchase Transactions, Quantify will update the average cost and last cost for the item accordingly.

  • No labels