This view provides access to all the Inventory Prices in the Items module and can be filtered by: Category, Location and Status (Item Status).
The Inventory Stock Price is always based on the Base Unit of the Item and is editable in this View.
Navigation: Main Menu > Items > Pricing > Menu (button) > Inventory Prices.
Table of Contents
View: Generates a list of Inventory Prices based on the selected Filters.
Save: Saves any changes or refreshes the view.
Actions:
Batch Updates: Updates are applied to all the selected records when the Update (button) is clicked. Batch Update options are:
Auto Update
Toggles the setting to automatically update inventory prices to be Active (automatically updated) or Inactive (manually updated).
Checkmark = Active (automatically updated).
Status:
Toggles the inventory prices to be Active or Inactive.
Checkmark = Active.
Update to last Goods Received Price
Changes the stock prices (Stock Price column) of the selected records to match the last Goods Received Prices (Last GR column).
Will only update records where the Goods Received Prices are greater than zero.
Update to last Purchase Price
Changes the stock prices (Stock Price column) of the selected records to match the last Purchase Order Prices (Last PO column).
Will only update records where the Purchase Order Prices are greater than zero.
Update to Supplier Price
Changes the stock prices (Stock Price column) of the selected records to match the last Supplier Prices (Sup Price column).
Will only update records where the Supplier Prices are greater than zero.
Update to Cost Price
Changes the stock prices (Stock Price column) of the selected records to match the last Cost Prices (Cost Price column).
Will only update records where the Cost Prices are greater than zero.
Update Prices - Weighted Average - Last Month
NB! For this to work, you need to turn off the automatic Inventory Price updates.
Uses the previous month's transaction to calculate the weighted average price.
Function allows you to update the prices of all the selected items where their updates are set to manual (e.g. before you create periodic transactions).
A Note is added to the Price History table in the Items Edit View to explain how the Price was updated. Eg: Opening (2025-01-01): 0 ea, Value 0.00; Received: 270 ea, Value 427,208.91; Issued: 39 ea, Value 72,439.77; Current (2025-01-29): 231 ea, Value 354,769.13; Old Unit Price: 1,857.43; New Unit Price: 1,535.80
Update Prices - Weighted Average - This Month
NB! For this to work, you need to turn off the automatic Inventory Price updates.
Uses the current month's transaction to calculate the weighted average price.
Function allows you to update the prices of all the selected items where their updates are set to manual (e.g. before you create periodic transactions).
A Note is added to the Price History table in the Items Edit View to explain how the Price was updated. Eg: Opening (2025-01-01): 0 ea, Value 0.00; Received: 270 ea, Value 427,208.91; Issued: 39 ea, Value 72,439.77; Current (2025-01-29): 231 ea, Value 354,769.13; Old Unit Price: 1,857.43; New Unit Price: 1,535.80
Output: Generates price lists.
Menu:
Reset Data Filter: Resets the selected data filters.
Views
Supplier Prices: Switches the view to Supplier Prices.
Selling Prices: Switches the view to Selling Prices.
Inventory Prices: Switches the view to Inventory Prices.
Service Prices: Switches the view to Service Prices.
Items
Add new Item: Allows users to add a new item.
Add new Supplier Price: Allows users to add a new Supplier Price to an existing item.
Price Lists
Edit Price Lists: Allows users to add or edit a price list.
Link Customers to Price Lists: Allows users to add customers to a price list.
Email Excel: Allows users to email the list view by opening the default email template with the view attached in .xlsx format.
Save
Save (All Users)
Restore Default (All Users)
Category: A dropdown list allowing users to select a specific Category or All Categories.
Location: A dropdown list allowing users to select a specific Location or All Locations.
Active: Checkbox. Checkmark = Only Active Prices will be shown.
Show Qty: Toggle showing or suppressing the Quantity In Stock (In Stock column). Checkmark = quantity will be shown.
ℹ️ Fields marked in blue can be edited. However, if the Stock Price is amended, the Variance columns might not update until the Inventory Report is closed and opened again.
Field Chooser: Allows users to add or remove columns.
ID: A system-generated number for the inventory price.
Category: The item's Category.
Sub-category: The item's Subcategory.
Status: The Status of the price.
Description: The item's user-defined Description.
Reference: The item's user-defined Reference.
Code: The item's user-defined Code.
Customer: The Customer name that was entered in the item's header information.
Location: The Location of the stock: the inventory item is displayed multiple times if there are multiple locations.
PO Date: The Date of the last Purchase Order.
GR Date: The Date of the last Goods Received.
In Stock: The Total Quantity In Stock (or blank if the Show Qty checkbox is not checked).
Warning: This column displays the Total Quantity In Stock across all Locations and displays that number next to each location.
Unit: A code describing the Unit.
Cost Price: The Total Cost Price on the Pricing section of the Item's Costing & Pricing tab. (Unit Price + Adj% = Supplier Price + Cost Adj%.)
Sup Price: The price matching the supplier whose name appears in the Supplier column. which is the Highest Supplier Price converted to Local Currency and converted to the Item's Base Unit.
Supplier: The name of the Supplier selected under Supplier Prices in the Item's Costing & Pricing tab. If there are multiple suppliers, the supplier with the Highest Unit Cost will be shown.
Last PO: The inventory price on the most recent Purchase Order which is converted to Local Currency using the Exchange Rate on the last Purchase Order.
Last GR: The inventory price on the most recent Goods Received which includes Landing Costs.
Stock Price: The current Inventory Price.
Var CP: The difference between the Stock Price (Stock Price column) and the Cost Price (Cost Price column).
Var SP: The difference between the Stock Price (Stock Price column) and the Supplier Price (Sup Price column).
Var GR: The difference between the Stock Price (Stock Price column) and the last Goods Received Price (Last GR column) if the Last GR field is not blank.
Auto Update: A checkmark indicating whether the price is automatically or manually updated. Checkmark = the Stock Unit Price can be updated from Transactions e.g. from a Purchase Order.
Update: The Date on which the item was last updated.
Updated by: The User who last updated the item.
Menu (...): A sub-menu that can also be accessed by right-clicking the line.
Open Item: Opens the item's setup interface.
Open Item Dashboard: Opens a Dashboard with a Summary of the item's activity.
View Item Summary: Displays a Summary of the item and transactions on the right.
Open last Purchase Order: Opens the last Purchase Order in which the item was used.
Open last Goods Receive: Opens the last Goods Receive transaction in which the item was used.
Open Transaction View: Opens a list of Inventory Transactions over the inventory report.
Click the large arrow ◀ next to Inventory Transactions to return to the inventory report.