Pricing - Inventory Prices
Overview
This view provides access to all the Inventory Prices in the Items module and can be filtered by: Category, Location and Status (Item Status).
Inventory prices are used to calculate the value of stock on hand.
The Inventory Stock Price is always based on the Base Unit of the Item and is editable in this View.
List View
Buttons Explained
| Button | Description |
|---|---|
| View | Generates a list of Inventory Prices based on the selected Filters. |
| Save | Saves any changes or refreshes the view. |
| Actions |
|
| Output | Generates Price Lists. |
| Menu |
|
Filters Explained
| Filter | Description |
|---|---|
| Category | Select a specific Category or All Categories. |
| Location | Select a specific Inventory Location or All Locations. |
| Active | Checkbox. Checkmark = Only Active Prices appear. |
| Show Qty | Toggle showing or suppressing the Quantity in Stock (In Stock column). Checkmark = quantity appears. |
Fields Explained
Info
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 | Description |
|---|---|
| Field Chooser (*) | Add or remove columns. |
| ID | A system-generated number for the inventory price. |
| Category | The item's Category. |
| Status (Item) | The item's status. |
| Status (Inventory) | The price's status. |
| Subcategory | The item's subcategory. |
| 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 appears 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 unchecked).
|
| 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%.) |
| Supplier 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 appears. |
| Last PO (Cur) | The inventory price on the most recent Purchase Order in the currency used on the Purchase Order. |
| 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. |
| Updated | The Date on which the item was last updated. |
| Updated by | The User who last updated the item. |
| Menu (...) | A submenu that can also be accessed by right-clicking the line.
|