Inventory Reports - Replenishment

Overview

Inventory – Replenishment provides a snapshot of upcoming inventory changes and offers a quick way to order stock to meet the minimum stock holding requirements.

The following fields are set up in the Items module: Inventory (tab).

Field Description
Lead DaysThe number of days from placing an order to receiving the goods.
Min QtyThe minimum quantity you need to have in stock (the quantity that you sell over a period equal to the lead days above, plus a small buffer).
Reorder QtyThe quantity that you order when you replenish stock. The reorder quantity determines how long your buying cycle is.
Navigation Example

Main Menu > Procurement > Inventory > Menu (button) > Replenishment

Buttons Explained

Button Description
ViewGenerates a Replenishment Report based on the selected filters.
Actions > Replenishment Options
  • Purchase Orders (INV) (PO-INV): Creates Purchase Orders for the selected transactions.
  • Work Orders (WO): Creates Work Orders for the selected transactions.
OutputAvailable upon request.
MenuSee the Menu button described under Inventory Reports Settings.

Filters Explained

Filter Description
SetLists various date options (e.g. Today and No Date to view all the entries).
⬅ ➡Adjusts the date in the direction of the arrow.
DateLets you enter custom dates.
CustomerA dropdown list of customers, allowing you to view All or a specific Customer.
CategoryA dropdown list of categories allowing you to view All or a specific Category.
Location
  • A dropdown list of locations allowing you to view All or a specific Location.
  • The Location Filter only displays locations linked to your Entity.
  • If you are not linked to an entity, all the locations are available.
ActiveIf checked, only shows inventory items that have an Active status.
OutstandingDisplays items ordered but not yet received.
Show MovementWhen checked the Issue and Receive columns are populated. Warning: checking this box slows down the query.

Fields Explained

Field Description
Field Chooser (*)Add or remove columns.
IDA system-generated number for the inventory item.
Status (Location)The Status of the inventory item's location.
CategoryThe inventory item's Category.
DescriptionA description of the inventory item.
CodeThe inventory item's Code.
Unit (Base)An abbreviation describing the item's Base Unit.
LocationThe Location of the inventory item.
CustomerThe name of the Customer that is linked to the inventory item.
SubcategoryThe inventory item's Subcategory.
Bin NoThe inventory item's Bin Number.
Ave/MonthThe average quantity used in a month.
SuggestedThe suggested minimum quantity.
Min QtyThe Minimum Quantity that was filled in on the inventory item's Inventory (tab). This field is highlighted in red when it is greater than the available quantity.
ReorderThe Reorder Quantity that was filled in on the inventory item's Inventory (tab).
In StockThe quantity that is currently In Stock.
On OrderThe quantity ordered but not yet received. The Quantity is generated from Active Purchase or Work Orders if the item's Resolve setting = order.
ReservedThe quantity that is reserved for pending customer orders. The reserved quantity is generated from Active Sales and Work Orders if the item's Resolve setting = reserve.
Available (Inc Orders)The quantity that is available, including orders as shown in the On Order column. See Stock Quantities.
Available (Exc Orders)The quantity that is available, excluding orders as shown in the On Order column.
ReceivedWhen a Date Period is selected, it shows the Quantity received (e.g. Goods Received) in that period.
IssuedWhen a Date Period is selected, it shows the Quantity issued (e.g. Goods Issued) in that period.
Unit PriceThe Stock Price of the inventory item.
ValueThe Value of the Inventory on hand (unit price x quantity). If the value is negative (due to a negative quantity in stock) the value appears in red.
SourceThe source from which the goods are procured.
ResolveThe action that was taken (e.g. produce, purchase).
Min Order QtyThe Minimum Quantity that can be ordered at a time.
Unit (Trans)The item's Unit used in the transaction.
Price: (Price Local / Base Unit)The unit price of the base unit in the local currency.
Menu (...)A submenu that can also be accessed by right-clicking an item:
  • Open Item: Opens the item's setup page.
  • View Item Summary: Displays a summary of the item's activity.

Report an issue with this page

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