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). 

The Inventory Stock Price is always based on the Base Unit of the Item and is editable in this View.

Filters

• Category

• Active - this filter is applied to the Item Status as well as to the Inventory Status of the Item.

Fields

• Status - The Inventory Status.

• Supplier - The Supplier with the Highest Price linked to the Item

• Sup Price - The highest Supplier Price converted to Local Currency and to the Item's Base Unit.

• Var SP - The difference between the Supplier Price and the Inventory Price

• Last PO - The last purchase price, which is converted to local currency using the exchange rate on the last Purchase Order. Right-click and select Open last Purchase Order to open the transaction.

• PO Date - The date of the last Purchase Order

• Last GR - The last Goods Received price, including Landing Costs - right-click and select Open Last Goods Receive to open the transaction.

• GR Date - The date of the last Goods Received transaction

• Var GR - The difference between the Inventory Unit Price and the Last GR

• Auto-Update - When True, the Inventory Unit Price can be updated from Transactions - eg. from a Purchase Order.

Actions

• Batch Update - Auto-update and Status (Inventory Status)

• Update to last Purchase Price - This will only be applied to the selected records where the Last PO price is greater than zero. 

• Update to last Goods Received Price - This will only be applied to the selected records where the Last GR price is greater than zero. 

• Update to Supplier Price - This will only be applied to the selected records where the Supplier Price is greater than zero.