Home > Item Management > Items > Screen Shots/Explanations > Items - Range

Items - Range

This tab will show exactly where an item is being sold, its price and its stock details. Where the Costs/Sells tab shows a summary of the intended costs/sells over high-level location groups, this tab is a snapshot of actual current activity. See How Is The Store Range Created? for details on how and when these records are created.

Figure: Example Items Screen

Note: The function associated with the Range buttons is only available the item has been loaded.

Locations

The location that the details will be displayed for. If this is a group, only locations within that group will be displayed.

Once the location has been entered, press this button to get the details for that location. Instead of pressing this button every time you change the item, you can check on the Load Item Range Records Immediately option on the System tab of System Settings. Each time you recall a new item, the details for the location will be retrieved automatically. If you have lots of locations it may not be a good idea to turn this option on because it can impact on performance.

Rate of Sale Periods

The period range to use for calculating rates of sale. By default this will be a 13-week range ending the last week before the current week.

Sales Periods

The period range to use for calculating sales. By default this will be the last week before the current week. Must be set

Calc Sales/ROS

Press this button to calculate the sales and rates of sale for the locations using the selected period ranges. Instead of pressing this button every time you change the item, you can check on the Load Item Sales Immediately option on the System tab of System Settings. Each time you recall a new item, the sales and rates of sale will be retrieved automatically. If you have lots of locations it may not be a good idea to turn this option on because it can impact on performance.

Press this button to see detailed statistics for the selected location in the grid.

Press this button to see detailed statistics for all locations.

All Details

This tab will show all details for the item at the selected locations. Since there are so many details available, there are three extra tabs (Supplier, Sells and Inventory/Sales) which will show a subset of the details. The details of the fields can be found below in those tabs' descriptions.

Supplier

This tab will show the details related to supply of the item - supplier, cost, carton size, and so on.

Supplier

The supplier which this store purchases from.

Order Code

The supplier’s order code for this item.

Supplier Deleted

Indicates if the item has been deleted because the item is no longer available from the supplier.

Cost Type

The type of cost, for example Normal, Deal.

Cost

The invoice cost of the item.

Landed Cost

The landed cost of the item.

Carton Size

The carton size of the item

Landed Unit Cost

The unit cost of the item, that is Landed Cost/Size.

Avg Cost

The average cost of the item.

Last Inv Cost

The last invoice cost of the item.

Buy End

The date this cost expires.

Last Received

The date this item was last received on an invoice, goods receipt or transfer.

Sells

This tab shows the sell price details for the item.

Sell Type

The current sell type, for example Normal, Promo.

Sell End

The date the sell price expires.

Sell 1-5

Up to five sell prices of the item at the store.

Current GM 1-5%

The current margin based on the current sell and landed cost.

Normal GM 1-5%

The normal margin based on the normal sell and normal landed cost.

Last Sold

The date the item was last sold.

Inventory/Sales

This tab shows the current inventory details and the sales/rate of sale.

Carton Size

The carton size of the item.

Stocked

Indicates if the item is stocked at the store.

Purchase

If this is checked on (default), the location is allowed to purchase the item.

If this is checked off, the item cannot be ordered. If you try to use this item on a Purchase Order, the system will tell you that it is not allowed to be ordered. The item will be ignored from any suggested ordering. You can use the item on a goods receipt and a return to the supplier.

Although this option is only controlling the purchase of a single item at a time there is a function called PO Available Items (DataEntryItems.Exe POAvailableItems) that allows changing of the purchase status for groups of selected items.

Min SOH

The minimum stock on hand allowed. Used for suggested ordering.

Max SOH

The maximum stock on hand allowed. Used for suggested ordering.

Min Display Facing

The minimum number of units to be displayed to the customer on the shelf. Used for suggested ordering.

Min Reorder

The number of units required before reordering. Used for suggested ordering.

Rate Of Sale

The rate of sale for the item at the store. This is calculated for the Rate of Sale Periods selected at the top of the form. Note, it only includes the sales of this specific item, unlike Total Rate Of Sale below.

Total Rate Of Sale

This is the total rate of sale for the item at the store. This includes any use of the item. If you have an ingredient item that is used in multiple recipes, this number will include the usage of the item in sales of those recipes. If the item is sold in one location but stocked in another, the stocked location will show the usage of the item, regardless of where it was sold.

This gives a more accurate rate of sale for ordering purposes.

Stock Cover

The number of weeks stock available calculated as Stock On Hand/Rate Of Sale. If the item is a linked item, the stock cover is zero because the stock is kept against the original link parent. If the item is a link parent, that is other items link to it, the Rate Of Sale used in the calculation includes the rate of sale of all items linked to this item.

Stock on Hand

The current stock on hand.

On Order

The quantity currently on order.

Allocated

The amount of stock allocated for uncommitted sales, for example customer orders and laybys.

Qty Sold

The quantity (in units) sold for the Sales Periods selected at the top of the form.

Sales

The sales revenue for the Sales Periods selected at the top of the form. This may be inclusive or exclusive of tax depending on the Sales Figures Include Tax option on the System tab of System Settings.

Tickets Required

The number of tickets required at the store. This can be changed to let each store control the number of tickets required.

Profit Type

A flag that can be used to indicate the profitability of the item. This flag can then be printed on tickets so that the location staff can rearrange their stock to maximise their saleability, that is high profit items in the best location, low profitability in the worse. It does not matter what this flag is so long the values are used consistently across all items. If you use 'H' for high profitability then make sure you use 'H' everywhere, don't start using it to mean medium profitability.

Last Sold

The date the item was last sold.

Last Received

The date this item was last received on an invoice, goods receipt or transfer.

Converted from CHM to HTML with chm2web Pro 2.85 (unicode)