Home > Item Management > Items > Concepts > Products, Supplier Range, Items and Store Range > How Is The Store Range Created?

How Is The Store Range Created?

As described in What Is An Item? Store Range is a summary of the item, cost and sell for each store. But how is the Store Range record actually created? It can be created by:

In the first two cases, the system will only create the record if certain conditions are met. The system will not try to create records unnecessarily. In the third case, the record is created because its required to update the stock on hand details. It will always be created for inventory transactions, regardless of whether the required conditions are met or not.

So what are the conditions for creating the record? The first thing to understand is that just because an item could be at a store, doesn't mean its actually there. Consider a music store. There are thousands and thousands of CD's that could be stocked but only a small number that actually are. So just because the system could create a record, it doesn't mean that it should.

In order to create a record, the following conditions must be met:

If you were a location with a small number of items, its generally easier to have the Always Create New Store Range Records option checked on. However, if you were a store that had lots of items available but only a small number in stock, you would have Always Create New Store Range Records checked off. You would then rely on the system creating Store Range records either for mandatory items or when you do an inventory transaction, for example purchase order, stock adjustment.

The item must have a classification that can be used by the store. When you define a location, you can tell the system that any classification is valid, or you can list the classifications that are valid (see the Classifications tab in Locations). So for a large store they might be allowed to use items in the BIG, MEDIUM, SMALL classifications while a small store can only use items in the SMALL classification. Items that are not assigned to a classification are controlled by the Order Items Without A Classification option on the Inventory tab in System Settings. If the option is checked off, the item will not be used. If it is checked on, the item can be used. In summary, the item classification must pass one of these tests.

Item ranging can involve the use of location groups that are not the stores natural parent, but still have the store as a member, to be considered part of the hierarchy when determining the best sell for an item. For more information see Costs/Sells.

The parent hierarchy, if it has a sell, will always take precedence, but if no sell is found for that level the alternatives will be considered and the cheapest sell used for ranging. The cost ranging is controlled via the 'Use Parent and Group Sell Ranging' option on the System 2 tab in System Settings.

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