Page Comparison

...

1. Click the Add button and enter a Label and the Target Date or the Relative Target Date. The target date will be used in the calculation to select the correct input data, for example, Company Parameters. The relative target date is relative to the current date.

2. Select the new set in the CFS list and click the Configure button. A new dialog Calculation Setup will open.

3. In the first tab Source Selection, select the type of table to be used as a source. Possible Source Types are:

   • Product – The set will be based on products and the results written to the product master.

   • Customer – The set will be based on customers and the results written to the customer master.

   • Company Parameter – The set will be based on a parameter and the results written in the selected parameter. In this case, the parameter has to be selected.

   • Product Extensions

   • Customer Extensions

   • Price Records

   • Rebate Records

   • Manual Price Lists

4. Select a subset by setting a simple or advanced filter.

5. Optionally, set a Concurrency Key Suffix. Normally (if you leave the field empty), all CFSs for the same underlying object (e.g., product master) are executed in sequence, one at a time. If you want to run two or more CFSs in parallel for the same object, you need to specify a suffix. If you define, for example, two CFSs with suffix 1 and 2, both will run in parallel at the same time for the same underlying object. 
    Executing two or more concurrent conflicting CFSs can make them to block each other. Therefore it is important to sequence those CFSs which could be in conflict.

6. On the second tab Calculation Setup, select a Calculation Logic from the drop-down menu. (The calculation logic must already be created, have the 'Active' status and appropriate Display Mode.)

7. Optionally, set up other options:

   • Allow distributed calculation – Performs calculations simultaneously. This is useful for large tables as it increases the calculation performance but you cannot insert/update/delete rows. Detailed settings can be made in the pricefx-config.xml file.
     Note that only the support team can change the server configuration.
      References and dependencies within a Price List need to be considered in the price logic.

   • Preserve Last Update Value – If checked, the fields Last Update and Last Update By in the source (target table) are not updated by the Calculated Field Set.
      Last Update will only be updated if the update record differs from the record in the target object. If you push the same item to the database, the update is ignored and hence Last Update Date and Last Update By is not updated.

   • On error: Clear field value – If checked, in case of an error the field in which the calculated value should be written is cleared. If not checked, the previous value will remain.

   • On the right side, you can map the results from the calculation to existing fields (columns) of the source.
      The data in these fields will be overwritten by the calculated data.

   • In addition, the specific calculation logic may require entering values for some extra parameters.

8. Save the changes.