Manual Stock Adjustment

Purpose

The Manual Stock Adjustment module is used to directly adjust stock quantities in E-Retail. This is necessary in the market for situations such as:

• Writing off damaged, expired, or missing stock.

• Writing on found, returned, or unrecorded stock.

• Correcting discrepancies discovered outside of regular stocktake.

• Adjusting stock due to packaging changes, returns, or warehouse handling errors.

Maintaining accurate stock levels is critical to ensure reliable reporting, replenishment, and margin control.

Prerequisites

• Access to Inventory Control Module > Manual Stock Adjustment.

• Adjustment reasons configured in the system.

• Bin locations maintained for bin-managed warehouses (if applicable).

Steps

Step 1 – Create Adjustment Document

1. Go to Inventory Control Module > Manual Stock Adjustment.

2. Click New.

3. Populate the top panel:

   • Location – Select Warehouse or Store.

   • Manager – Person in charge.

   • Adj Reason – Select the adjustment reason (e.g., damaged goods, found stock).

   • Reference – (Optional) Input related reference document.

   • Note – (Optional) Enter remarks.

Step 2 – Input SKUs

Option 1 – Direct Input

1. Manually add SKUs into the module line by line.

2. Enter the adjustment Quantity:

   • Positive (+) = Write On (increase stock).

   • Negative (–) = Write Off (reduce stock).

Option 2 – Import via Template

1. Click Download Template.

2. Populate the following fields in Excel:

   • SKU Code

   • QTY (positive for write on, negative for write off)

   • Bin No. (only required for bin-managed warehouses, else leave blank)

3. Save the file.

4. Back in the module, click Import and select the populated file.

Step 3 – Review Adjustment Details

After SKUs are entered/imported, the module will display key columns:

• SKU Code

• Description

• Stock on Hand (before adjustment)

• Adjustment Quantity

• Retail Value

• Cost Value

Verify accuracy before proceeding.

Step 4 – Save, Confirm & Export

1. Click Save to keep as draft.

2. Once verified, click Confirm to finalize the stock adjustment.

   • The system will immediately update stock levels.

3. (Optional) Click Export to download the adjustment document for audit, reporting, or record-keeping.

Notes / Tips

• Always double-check positive vs negative quantities to avoid incorrect stock postings.

• Bin No. is mandatory only for bin-managed warehouses.

• Keep adjustment reasons standardized for proper audit trails.

• Use Import for bulk adjustments to save time.

• Use Export for maintaining adjustment history or sharing with other departments.