---
title: "Average Cost Adjustment Import"
canonical: "https://kb.myframeworks.com.au/space/FRAM/28409282/Average%20Cost%20Adjustment%20Import"
format: markdown
---
# <span style="color: #172b4d">Overview</span>

The Average Cost Adjustment Import allows to make bulk adjustment to the current average cost of products.

> ❌ To access the **Average Cost Adjustment Import **you will need to enable **Average Costing **from the Company Maintenance tab.

> ℹ️ This process explains how to use the Average Cost Adjustment within Frameworks.

# Accessing the Average Cost Adjustment Import

To access the **Average Cost Adjustment Import**, perform the following:

1. Click **Frameworks **then navigate to **Inventory > Transaction Processing > Average Cost Adjustment Import **from the navigation tree.
2. The **Average Cost Adjustment Import **page will open the **Import Criteria **page.

# <span style="color: #172b4d">Downloading a Template</span>

<span style="color: #333333">To make it easier to import your Average Cost Adjustment, you can also download a template. By downloading a template, you will ensure that you have the correct fields available to update and/or modify. To download a template, from the </span><span style="color: #172b4d">**Average Cost Adjustment Import > Import Criteria **</span><span style="color: #333333">tab, perform the following:</span>

1. From the **Update Field **menu select which fields you want to update/import. By default, all the fields are selected, hold the **CTRL** key down to select multiple fields.
2. Click **Download Template** to download the .csv template (avg_cost_adjustment.csv) that will include all of the products and fields based on the above selections.
3. Open up the downloaded .csv template (avg_cost_adjustment.csv) and add/edit the required product fields in the file.
4. **Save **the file, keeping the .csv file format, ready for importing.

# <span style="color: #003366">Uploading the Average Cost Adjustment Import</span>

1. Click **Upload CSV** and choose the file created in the above steps and then click the** Upload** button. Once the .csv file has been up uploaded next to **Import File:** it will display the filename that is going to be imported.
2. **Enable **the checkbox for **Report Only **to confirm the changes before importing or **disable **to import the changes into Frameworks.

> ℹ️ If you are performing a large product import you might want to delay the import to not impact performance. To do this update the **Start date** and **time** or use the date finder **Show Date Chooser** icon to search for an appropriate date and time to run the task.

3. From the **Schedule **tab, select the task notification options to **Send a notification** or **Send an email** once the import has run.
4. Click **Submit **to import the .csv file. An information box will pop up advising that the task has been submitted. Click on **OK.**
5. On the **Output** page, under the **Generated Reports** section, click on the **report** links to review the import.

> ⚠️ If the** Report Only** option was **enabled **and there were no errors in the generated report repeat the above and disable **Report Only**. If there were any errors in the generate report, resolve the errors before importing and possibly run the report only option until it is error free.

6. Click on the **Close **button in the bottom right once the tasked in completed.

# Additional Information

> ✅ Refer to [Average Cost Adjustments](https://sterlandsupport.atlassian.net/wiki/spaces/FRAM/pages/28384044) for more information.
> ✅ 
> ✅ Refer to [Scheduled Task - Scheduling and Output](https://sterlandsupport.atlassian.net/wiki/spaces/FRAM/pages/28402256) for more information.