Purpose

Average Cost Adjustment is used to update the cost price of SKUs to reflect the latest market conditions. Keeping average cost updated ensures that sales margins, inventory valuation, and profitability analysis remain accurate in today’s changing market.

Prerequisites

• Access to Inventory Control Module > Average Cost Adjustment > Average Cost Adjustment.

• Correct SKU codes and updated market cost information.

Steps

1. Go to Inventory Control Module > Average Cost Adjustment > Average Cost Adjustment.

2. Click Add.

3. Choose one of the following options:

   Option 1 – Manual Selection in Module

   1. In the SKU Code column, click the three-dotted button (…) to search and select products.

   2. Refer to the Current Cost Price column.

   3. Enter the updated value into the New Cost Price column.

4. Option 2 – Import via Template

   1. Click Download Template.

   2. Save the template to your preferred PC directory.

   3. Populate the following required fields:

      • SKU Code

      • New Cost Price

   4. In the module, click Import and select the populated Excel file.

5. Review the adjustments:

   1. Verify New Cost Price values.

   2. Check the Cost Variance column for differences between old and new cost.

6. Click Save to save as draft.

7. Once confirmed, click Confirm.

   1. The updated cost prices will be applied to the selected SKUs.

Notes / Tips

• Always double-check the Cost Variance column before confirming to avoid incorrect adjustments.

• Use Save as draft if further review or approval is needed before confirming.