06. Inventory Aging Actions

The Inventory Aging report has a Bulk Actions menu that lets you act on the aged stock you are looking at without leaving the report: set a new retail price on slow-moving variants, or correct their Moving Average Cost (MAC). MAC is the running average unit cost Qoblex holds for each product variant and uses to value your stock.

This article explains how to select rows, what each bulk action does, exactly what gets saved when you apply it, and the validation Qoblex enforces. After reading it you will be able to run a bulk retail-price discount and a bulk Moving Average Cost adjustment from the Inventory Aging report, and understand the difference between the two — one changes a selling price, the other changes how your inventory is valued.

A Moving Average Cost adjustment is an accounting action. It revalues the selected variants’ on-hand inventory in your books. Run it only to correct a genuinely wrong cost, and ideally with your bookkeeper or finance owner.

Where the actions live

The bulk actions belong to the Inventory Aging report only.

1. Go to Reporting > Inventory.
2. Open the Inventory Aging report tab.
3. (Optional) Filter the report so only the aged stock you want to work on is shown.
4. Tick the checkbox on each row you want to act on.
5. Open the Bulk Actions menu (top of the report) and choose an action: – Apply bulk discounts — set a new retail price on the selected variants. – Apply Mac Adjustment — set a new Moving Average Cost on the selected variants.

You need permission to view the Inventory reporting area to reach this report. If the Reporting menu or the Inventory report is hidden for your user, ask an administrator to grant your role the inventory reporting permission.

You must select at least one row first. If you open a bulk action with no rows ticked, Qoblex shows Select at least one item to proceed with this action ! and does nothing.

The variants you ticked are carried into the action dialog. Each dialog shows a table with one row per selected variant, and a remove (red ✕) button on every row so you can drop a variant from this run without going back to the report.

Apply bulk discounts (set a new retail price)

This action sets a new Retail Price for the selected variants. It updates the Retail price list only — it does not touch wholesale prices, purchase prices, or the variant’s cost.

1. Tick the rows you want to reprice in the Inventory Aging report.
2. Choose Bulk Actions > Apply bulk discounts. The Bulk Price Discount dialog opens.
3. Review the table. Each row shows: – Product — the variant, with its image. – Sku — the variant SKU. – Moving Average Cost — the current MAC, shown for reference only (read-only). – Current Retail Price — the variant’s current retail price. – Retail Price — the new retail price (editable; this is what gets saved). – Discount (%) — the resulting discount, calculated for you (see below).
4. Set the new prices in one of two ways: – Per row — type the new value directly in the Retail Price field on each row, or – All rows at once — tick Apply bulk discount (%), enter a percentage in the Discount (%) box, and Qoblex fills every row’s Retail Price with Current Retail Price − (Current Retail Price × percentage / 100).
5. Remove any row you do not want to change with its red ✕ button.
6. Select Apply Changes.

On success Qoblex shows Retail prices have been update. and closes the dialog.

The Discount (%) column is calculated as ((Current Retail Price − Retail Price) ÷ Current Retail Price) × 100, rounded to two decimals. It only shows a value when both the current and the new retail price are greater than zero; otherwise it shows 0. It is a display figure — the discount percentage itself is never saved, only the new Retail Price is.

What gets saved

For each remaining row Qoblex sends the variant and its new retail price to the price-update endpoint (POST /variants/prices), targeting the Retail price list. Nothing else about the variant changes.

Bulk discount validation

Qoblex blocks Apply Changes until every row is valid. Each row must have:

• A product variant.
• A product name.
• A current retail price.
• A new Retail Price that is greater than zero. A blank or zero/negative value is rejected with the message Quantity must be positive.

Apply Mac Adjustment (correct the Moving Average Cost)

This action sets a new Moving Average Cost for the selected variants. Use it only to correct a cost that is genuinely wrong — it is an inventory-valuation action, not a selling-price change and not a stock-quantity change.

1. Tick the rows whose cost you need to correct in the Inventory Aging report.
2. Choose Bulk Actions > Apply Mac Adjustment. The Mac Adjustment dialog opens.
3. Review the table. Each row shows: – Product — the variant, with its image. – Sku — the variant SKU. – Moving Average Cost — the new cost (editable; this is what gets saved).
4. Enter the corrected Moving Average Cost on each row.
5. Remove any row you do not want to adjust with its red ✕ button.
6. Select Apply Changes.

On success Qoblex shows Mac changes have been applied successfully and closes the dialog.

What this does to your inventory and books

When you apply the adjustment, Qoblex records a Moving Average Cost change for each variant (POST /variants/adjust) and, in the inventory ledger, posts a cost-revaluation entry for that variant. Specifically:

• The variant’s on-hand quantity does not change — only its cost does.
• The recorded value change is on-hand quantity × (new MAC − old MAC). Raising the cost increases the recorded value of that stock; lowering it decreases it.
• If the new cost is the same as the current cost, Qoblex skips that variant — nothing is posted.
• The whole run takes place in a single transaction: if any variant fails, the entire adjustment is rolled back and no variant is changed.

This revalues the selected stock in your accounting. It changes inventory value (and the related adjustment figure), not stock counts. Do not use it to discount a selling price — use Apply bulk discounts for that.

Moving Average Cost is only tracked when inventory value tracking is enabled for your account. If value tracking is off, applying the adjustment posts no ledger change.

MAC adjustment validation

Qoblex blocks Apply Changes until every row is valid. Each row must have:

• A product variant.
• A product name.
• A Moving Average Cost that is greater than zero. A blank or zero/negative value is rejected with the message Quantity must be positive.

Saving, cancelling, and closing

• While Qoblex is saving, Apply Changes is replaced by Saving… and shows a loading state. Wait for it to finish.
• Cancel closes the dialog without saving anything.
• Closing either dialog (whether you cancelled or it closed after a successful save) clears your row selection in the Inventory Aging report. To run another action, re-select your rows.

Troubleshooting