The SSP integrity check is run interactively when the SSP group is activated or when the Integrity check option is selected on the Work with classification definition, Standard sales price groups, Current panel. SSP integrity checking is also run during item creation.
When creating a new item, or when changing the item status to active, the following tasks are executed:
- Integrity checks for SPP Groups
- Integrity checks for SSP Groups
The purpose of this routine is to check if the SPP, SC, SCS and SSP can be calculated for the created item from the item classification definition and that there is only one way to calculate these prices and costs. Integrity checking is run for all active SSP groups. Because of this, it is strongly recommended that all expired (according to date range) price groups are deleted.
Formula validation is not performed during the integrity check because deletion or any changes of the formula used in the definition of any active SPP group or SSP group is forbidden and characteristic names are not allowed within the pricing related formula.
Checking modes
There are two modes of the SSP group checking program:
| Mode | Description |
|---|---|
| P | Errors are checked from SSP maintenance for single SSP group and all items from item classification profile 1/ item classification profile 2 set:
|
| I | Errors are checked from the item creation routine, (Item characteristic maintenance program (DIR996)) and when the price download is started from Item price list maintenance (i.e. Download prices option on DMR00601 panel). In this case checking is done for the single item and all active SSP groups from item classification profile 1/ item classification profile 2 set:
|
The Characteristic exception processing is different depending on the Combined rules flag setting in the SSP group header. (See Combined rules flag for characteristic exceptions in Item Classification pricing for more information).
- If Combined rules is set to YES, only simple conditions (characteristic, operator, value) are allowed. Conditions are sequentially processed and SSP is recalculated according to exception formula if the item is described by characteristic value that fulfils exception condition. If more than one condition formula defines the price with no relation to previously calculated value (fix price or the formula that is not based on the SSP), the lowest price is to be used. Integrity checking is not needed in this case.
- If the Combined rules flag is set to NO, multiple simple conditions can be entered with the same sequence number. They are treated as complex condition composed of single conditions connected with AND operator. The complex conditions define sets of items with fulfilling characteristic set-up. These sets should be separate (not overlapping). Otherwise the item price is ambiguous. Integrity checking is necessary to avoid this situation.
The SSP integrity checking program creates the Standard sales price downloading history file (SROMGPSSHI) when another entry parameter WFIL is set to “Y”. Records in this work file contain the information about processed items and its new prices or error status. Work file is created when integrity checking program is called from item simulation, activation of the SSP group and creation of the new item. Work file is not created when integrity checking program is called via the Integrity check option.
Standard sales price downloading history file records contain the following fields:
- Item classification profile 1
- Item classification profile 2
- Price list
- Currency
- Classification unit
- From date, to date
- Version number
- Item code
- SPP value defined for SPP group (retrieved from SPP group header)
- SPP after applying exceptions
- SC value (calculated during integrity checking)
- SCS value (calculated during integrity checking)
- SSP defined for SSP group (retrieved from SSP group header if it is available)
- SSP header formula code, description and parameter values
- SSP after applying exceptions (calculated during integrity checking)
- Flag informing that item exception was applied during SSP calculation
- Item exception operator and factor
- Flag informing that characteristic exception was applied during SSP calculation
- Characteristic exception formula, its description and parameter values. This formula is saved when Combined rules is set to NO
- The internal sequence number of the quantity dependent prices set
- Date, time and user that run the simulation/download
- Error code indicating that item SSP cannot be calculated
- Error detailed code informing what error occurred:
- 01: price could not be calculated because of characteristic definition integrity
- 02: price could not be calculated because the item was not active in main cost warehouse
- 03: formula error occurred
- 04: SPP download information is missing