Home > Item Management > Dept/Cat/Groups > Concepts > Other Codes

Other Codes

This tab contains three grids which contain special information about the combinations that have been defined. As you highlight a specific department/category/group/subgroup on the tree, the system will automatically display the following details for that specific combination.

Default Margins

The first grid contains default margins. The default margins are used when proposing new sell prices. A margin can be set for any department, department/category, department/category/group or department/category/group/subgroup. You can also specify that the margins apply to a specific manufacturer. This means that if you have a range of items from a 'superior' manufacturer, you can set a higher default margin.

The system will use the most specific margin it can find. It will look for margins in the following order:

Location + Department + Category + Group + Subgroup + Manufacturer

Location + Department + Category + Group + Subgroup

Location + Department + Category + Group + Manufacturer

Location + Department + Category + Group

Location + Department + Category + Manufacturer

Location + Department + Category

Location + Department + Manufacturer

Location + Department

Location + Manufacturer

Location

If a suitable margin cannot be found for that location then it will look for a margin for that location's parent. It will continue to do this until no more locations are available.

To add a new default margin, expand the tree to the required level and click the btnSmallNew.gif (1125 bytes) button. You must enter the location for which this margin will apply. This can be a specific location or a group. You then specify the margin rule.

Each margin rule consists of up to five margins and five types. The type indicates how the margin percentage will be used.

This will generally be left as 'GM%' which means use this percentage as a margin on the cost. However, it can also be set to 'Adj Sell 1', 'Adj Sell 2', and so on. This tells the system to modify the corresponding sell price by the percentage instead of using the percentage as a margin on cost. This would allow you to set the system up so that Sell Price 2 was 10% higher than Sell Price 1. You cannot set the percentage to adjust a later sell price. For example, '% Type 2' cannot modify sell price 3 because sell price 3 has not been calculated yet.

To delete a default margin, expand the tree to the required level, highlight the margin row and click the Delete button.

Rounding Rules

Rounding rules are used when proposing new sell prices to round a price to a more acceptable format, for example $6.96 to $6.99. You define a set of rounding rules using the Sell Price Rounding Rules task. You can then use this section of Category Maintenance to assign rounding rules to different department/category/group/subgroups. If you wanted to apply a single set of rounding rules to the whole system, you would select the System icon from the tree and enter the rounding rule in this grid.

The system will use the most specific rounding rule it can find. It will look for rules in this order:

Location + Department + Category + Group + Subgroup

Location + Department + Category + Group

Location + Department + Category

Location + Department

Location

If no rounding rules are found for that location, the system will try that location's parent. It repeats this until there are no more locations. If no rounding rule is used, the sell price is simply not round.

To add a new rounding rule, expand the tree to the required level and click the btnSmallNew.gif (1125 bytes) button. You must enter the location for which this rounding rule will apply. This can be a specific location or a group. You then select the rounding rule to be used.

To delete a rounding, expand the tree to the required level, highlight the row containing the rounding rule and click the Delete button.

Cross Reference Codes

The second grid contains cross-reference codes. These are used to convert department/category/group details between our system and third party venue systems and supplier electronic host files. When used in Venue Updates, the system will look up the item’s department/category/group in this list for the appropriate system and translate them into new values suitable for the required system. Currently cross-references can be set up for HIS, ISS60, SBA and ScanMan venue systems. The details are also used by some Host Updates to translate the incoming department/category/group details to our codes.

Currently only the Davids VAX Update is supported.

Cross-references can only be set up for a specific department/category/group. If you select a department/group, the data-entry grid will be disabled and you will not be able to enter any details.

There can be multiple cross-references recorded against the department, category and group for conversion to multiple systems, for example one for HIS, one for SBA, and so on. However, the System in each record must be unique.

To add a new cross-reference, expand the tree to the required department/category/group and click the btnSmallNew.gif (1125 bytes) button. Enter the System this cross reference is for and the required codes and descriptions.

To delete a cross-reference, expand the tree to the required department/category/group, highlight the cross-reference row and click the Delete button.

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