---
title: "Creating a Product Average Cost Adjustment"
slug: "creating-a-product-average-cost-adjustment"
updated: 2026-08-13T12:39:53Z
published: 2026-08-13T12:39:53Z
canonical: "docs.avontus.com/creating-a-product-average-cost-adjustment"
---

> ## Documentation Index
> Fetch the complete documentation index at: https://docs.avontus.com/llms.txt
> Use this file to discover all available pages before exploring further.

# Creating a Product Average Cost Adjustment

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 ( ![](https://cdn.document360.io/ae69c864-58f0-4711-91e1-d1c2f7dff95f/Images/Documentation/eeb384e1-1703-4294-a2c6-30eaba48df3b.png)) and select **Product Average Cost Adjustment** from the menu that appears.

![](https://cdn.document360.io/ae69c864-58f0-4711-91e1-d1c2f7dff95f/Images/Documentation/cost%20adjustment.gif) The *Available Average Cost Adjustment* dialog appears.
4. Click the **Created Date** calendar icon ( ![](https://cdn.document360.io/ae69c864-58f0-4711-91e1-d1c2f7dff95f/Images/Documentation/c37c4b7a-7254-4962-b7e8-615d3f190935.png)). This specifies when the costs were adjusted. ![](https://cdn.document360.io/ae69c864-58f0-4711-91e1-d1c2f7dff95f/Images/Documentation/image-RBV8RY7F.png) The calendar appears. ![](https://cdn.document360.io/ae69c864-58f0-4711-91e1-d1c2f7dff95f/Images/Documentation/image-AIRV6SL1.png)
5. Locate and click the appropriate date.
6. Click the **Products** tab. ![](https://cdn.document360.io/ae69c864-58f0-4711-91e1-d1c2f7dff95f/Images/Documentation/image-68G9HOQ0.png) The *Available Average Cost Adjustment* dialog appears.
7. Locate the appropriate Product, click in its cell in the **Quantity** column and enter the quantity to purchase.

> [!TIP]
> **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.
8. Click in its cell in the **Cost Ea**. column and enter the cost of each one piece. ![](https://cdn.document360.io/ae69c864-58f0-4711-91e1-d1c2f7dff95f/Images/Documentation/image-LATYP3TC.png)
9. Repeat the above two steps as many times as necessary.
10. Click **OK**. Quantify creates the Transaction ![](https://cdn.document360.io/ae69c864-58f0-4711-91e1-d1c2f7dff95f/Images/Documentation/image-NLOUR3JH.png)

Quantify updates 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.

![](https://cdn.document360.io/ae69c864-58f0-4711-91e1-d1c2f7dff95f/Images/Documentation/image-SPFSM2ZA.png)