Logo
Documentation

Inventory Adjustment

This section is part of the inventory management, where you can adjust inventory settings.


Upload Opening Inventory in Axon ERP Through Excel

Watch: Upload Opening Inventory in Axon ERP Through Excel

The purpose of this tab is to manage opening stock at the end of the month and make adjustments as needed.

Overview

The Inventory Adjustment list displays the following columns: Transaction Code, Transaction Date, Warehouse, Reference No, Memo, and Status.

Each adjustment can have one of the following statuses:

  • Draft — Adjustment has been created but not yet approved
  • Approved — Adjustment has been approved and applied

Creating an Inventory Adjustment

Click the Inventory Adjustment button to create a new adjustment. Fill in the following fields:

  • Warehouse (required) — Select the warehouse to adjust
  • Transaction Date (required) — Set the date of adjustment
  • Adjustment Account (required) — Select the cost account (e.g. Inventory - Cost)
  • Is Opening Stock (optional) — Check this if adjusting opening stock
  • Memo (optional) — Add a note or description
  • Reference No (optional) — Enter a reference number

Invoice Lines

In the Invoice Lines tab, add items to the adjustment:

  • Item — Select the item from the dropdown
  • Description — Enter item description
  • UOM — Select the unit of measure
  • Quantity (required) — Enter the quantity
  • Costing Method — Select Auto or Manual
  • Unit Price — Enter the unit price

Click + Add Line to add more items. The Total Quantity is shown at the bottom.

Accounting Lines

The Accounting Lines tab shows the accounting entries generated by this adjustment.

Attachments

Use the Attachments tab to upload supporting documents for this adjustment.

Actions

Click the Actions button to access:

  • Import (Excel) — Import adjustments in bulk via Excel file
  • Export (Excel) — Export the adjustments list to Excel

WhatsApp