Glossary: Location Status

Field Name Description Location The store's name Stocked When tagged, indicates the item is stocked at the current location. The stocked flag will automatically flag when the user orders, invoices or sells the item. Maintain SOH This indicates whether the SOH is tracked and therefore updated. Whether or not this option can be edited at store level is dictated by the Maintain SOH in the main details of the item and the field is set to be editable by default in Site Configuration. Status Item Maintenance can be used to display how the item is being used at store level. different status can influence different behaviour towards the item per store level
If an item is marked as Deleted it will automatically update to Unstocked once the SOH reaches zero as part of the overnight process. SOH Stock On Hand Scripts On Hold Amount of Script on Hold in the store. When a script is dispensed, the on hold amount will increase, then the script is sold the SOH and on Hold amount will decrease by the quantity sold Hold SOH Amount of Stock on Hand that is on hold On Order Amount of stock requested from supplier (stock on order). The on order quantity will increase every time an order is raised for that item. On Order will decrease when a purchase order is matched to an invoice that receipted through the system. On Order quantities can be used by suggested order methods when creating and order Special On Order Orders can be raised specifically not to affect the on order quantity. These are quarantined orders, which use a special on quantities to track what is out standing on order. Min SOH Used for suggesting orders with the Min / Max option. Nominate the minimum stock holding and this value will be used as the Min SOH for the order. NB when using Min/Max ordering you must populate both the Min and Max.
Optional: If the feature is enabled in Site Configuration an option appears when suggesting orders to use Min SOH as an absolute minimum holding. If selected this option will apply the Min SOH to an order suggested using any order type. Max SOH Used for suggesting orders with the Min / Max option. Nominate the maximum stock holding and this value will be used as the Max SOH for the order. NB when using Min/Max ordering you must populate both the Min and Max.
Optional: If the feature is enabled in Site Configuration an option appears when suggesting orders to use Min SOH as an absolute maximum holding. If selected this option will apply the Max SOH to an order suggested using any order type. Use In Suggest Untag to prevent this item being included in suggested orders. ROS Rate of Sale. Weighted average quantity of sales per week (last 12 weeks). More recent weeks have more bearing on this figure. Avg Cost Average Cost, ex GST. The total purchase cost of the item divided by the number of units purchased, over the entire life of the item. Weeks Min Used for suggesting orders with the Dynamic Min / Max option. Nominate the number of weeks' minimum stock holding and this value will be calculated based on the current ROS and used as the Min SOH for the order. Setting this value at an item level will override a value set at the category level via the Store Category Info utility. Weeks Max Used for suggesting orders with the Dynamic Min / Max option. Nominate the number of weeks' maximum stock holding and this value will be calculated based on the current ROS and used as the Max SOH for the order. Setting this value at an item level will override a value set at the category level via the Store Category Info utility. Last Cost The last invoiced cost of the item, calculated from the invoice as Line Cost Ex divided by Inv Qty Last Sale The date that the item was previously sold Last Order The date that the item was last on order Last Invoice The date that the item was last received, therefore put on an invoice Last Stocktake The date of last stocktake the item was included on Default GP % The Default Gross Profit figure represented as a percentage Suggest Method Allow store to select suggested order method at the Item level. This feature works in conjunction with order templates. From Item Maintenance, Item stock information (bottom right of screen) we have new field called 'Suggest Method'. You have the option to select from 5 standard ordering methods. When you set up your order templates you have the option to select 'use individual item settings'. When you request a PO from this template the system will look directly to the Item to create the order. This feature allows you to do an order using a combination of order methods.
Date Modified The date the information was last modified Modified By The user that modified the information last Modified Source The POS Works Program the information was modified in