Price Update View
The Inventory module is a reporting module that can be used to check your inventory (using several views). The Price Update view provides functionality and actions to update Inventory Prices.
Navigation
Inventory > Menu > Price Update View
Search - This shows your active filters (in this image, Active, as the Active check box is checked) as well as allows you to search on any text or number.
Customer - This allows you to sort Inventory records by Customer.
Category - This allows you to sort Inventory records by Item Category.
Location - This allows you to sort Inventory records by a Location.
Active - This allows you to sort Inventory records by Status Active, or dormant.
Description - This shows the Item Description.
Code - This shows the Item's code.
Category - This shows the Item Category.
Location - This shows the Location of the Item.
Unit - This shows what Unit the Item is listed as.
Min Qty - This shows the minimum quantity that the Supplier will accept for re-orders.
Reorder Qty - This is the default reorder amount that can be set at Item-level, and will auto-populate the Purchase Order. It can be overwritten at Purchase Order level.
In Stock - This shows how many units of this Item are in stock.
Last PO Price - This shows the last Purchase Order price for this Item.
Cost Price - This shows the listed Cost Price for the Item.
Var (SP - CP) - This shows the variance between Stock Price and Cost Price.
Stock Price - This indicates the average Stock Price.
Set Cost Price = Last PO Price - This allows you to set the Cost Price to be the same as the last Purchase Order Price.
Set Stock Price = Last PO Price - This allows you to set the Stock Price to be the same as the last Purchase Order Price.
Set Stock Price = Cost Price - This allows you to set the Stock Price to be the same as the Cost Price.