Inventory Replenishment Interface

The Inventory Replenishment report can be added as a standalone module to any Menu Group. It can also be accessed from any Transaction Type with the applicable setting activated.

Use this report to view the stock that must be ordered, edit the stock prices and change the minimum quantity of stock that should be on hand.

Inventory Replenishment module listing items with stock levels, minimum quantities and prices to order
Inventory Replenishment Module

Buttons Explained

Button Description
View

Lists the items that match the selected filters.

A Replenish option must be selected first. Otherwise, the message “Please select a Replenish filter.” appears.

Arrow on ViewReset Data Filter: Clears the filters.
MenuLayout

Filters Explained

Filter Description
Category

Select a category to show only its items, or all the categories.

  • If you select a main category, all its subcategories are included.
  • If you select a subcategory, only the items in that subcategory appear.
LocationSelect a location, or all the locations.
Supplier

Select a supplier to show only its items, or all the suppliers.

Available only when Replenish is set to Purchase. For Produce and Transfer, the filter is locked to All.

Replenish

Shows only the inventory items that must be replenished. Select one of these options:

  • Produce: Shows only Assembly (ASM) items with a Cost Price in a costing unit.
  • Purchase: Shows only material items with a Supplier Price. Includes all Material types, including ASM (e.g. some items can be purchased or produced). All the Supplier Prices linked to the item appear.
  • Transfer: Shows inventory that is stored at multiple locations and must be transferred between these locations (e.g. from a warehouse to a store). Applies to items that are linked to Inventory and have a price of the type set by the Transaction Type’s Pricing setting (see Unit Price below).

A Replenish option is required to generate the list.

On OrderCheckbox. If checked, shows only ordered items (that is, a Purchase Order was created but the inventory is not yet received).
All Units

Checkbox. If checked, every unit linked to the item appears, not only the units linked to a price.

Note: All units appear, regardless of whether they need to be replenished.

The unit cell is highlighted in green where the unit is linked to a price (that is, you can add it to a transaction).

Entries without a price cannot be selected.

Search

Enter text to find items by the item’s description, code or category, or the location’s description or code.

Entering text in the search block resets the other filters.

Fields Explained

Field Description
Field Chooser (*)Add or remove columns.
IDThe system-generated number allocated to the entry.
Item IDThe system-generated number allocated to the item.
Location IDThe system-generated number allocated to the location.
Status (Item)The item’s status.
DescriptionThe item’s description.
CodeThe item’s code.
CategoriesThe item’s categories.
Status (Location)The location’s status.
LocationThe location’s name.
SupplierThe supplier.
Base UnitThe item’s Base Unit.
Unit

The entry’s unit.

If All Units is checked, the cell is green where the unit is linked to a price.

Min QtyThe minimum quantity that should be on hand.
Order QtyThe quantity that should be ordered.
In stockThe quantity in stock.
On OrderThe quantity ordered but not yet received.
ReservedThe quantity that is reserved for orders.
AvailableThe quantity that is available.
Unit Price

The item’s unit price for the displayed unit.

  • Purchase: The Supplier Price.
  • Produce: The Cost Price.
  • Transfer (opened from a transaction): Follows the Transaction Type’s Pricing setting. It is one of these:
    • The Sell Price (or the customer’s Price List, if the customer uses one).
    • The Supplier Price.
    • Otherwise, the Cost Price.

Priced rows only appear when Inventory Replenishment is opened from a transaction, and the price then comes from the transaction (e.g. the Supplier Price or Sell Price). If you open it on its own with Transfer selected, no priced rows appear.

When the report is opened from a transaction, supplier prices appear in the transaction’s currency.

CreatedThe date on which the item was created.
UpdatedThe date on which the item was updated.
Updated ByThe user who last updated the item.
Last Order

The code and number of the last order placed for the item at the same location and in the same unit.

Only filled in when the item is on order. The last order is the latest order that is not cancelled, even when its status does not update stock.

Last Order DateThe date of the last order.
Widget

A menu that also opens when you right-click the entry. The options are:

  • Open Linked Item: Opens the linked item’s record.
  • View Item Summary: Shows the item’s summary on the right, with the entry’s location selected.
  • Open Last Order: Opens the last order transaction (e.g. Purchase Order or Work Order).

Report an issue with this page

For more useful feedback, select the text on the page you are reporting on, then click Feedback again — or continue without selecting anything.