Troubleshoot Price List/Grid (Price Setting)

Owned by Ondřej Tesař
Sept 30, 2024
3 min read

If the Prices field is empty or encountering issues, it is time to troubleshoot. This guide explains how to identify calculation problems in price lists/grids managed by the Price Setting Package.

Review Warnings and Errors

When a problem occurs during calculation of a price list line, all the error messages are placed to Warnings and errors field in the price list/grid.

Example of Warnings and Errors from a line item of an independent price list.

Note that some of them are also duplicated into the price list Warnings field, but there they do not have all the details.

Example of Warnings from a line item of an independent price list.

Review the whole message, including the suggested solution, to find out the cause of the problem. Note that some messages do not necessarily mean that there is a real problem, but are more of a notification.

  1. Order – Review the messages from top to bottom because some minor issues at the beginning could cause bigger issues later and you could fix it by fixing the minor issue from the beginning. For example, a missing Cost value may not be a big problem in the general sense, but it could cause a failure of the Cost+ method calculation.

  2. Severity – When the Severity is “3 - Fatal”, the calculation cannot continue, and the process fails, so you do not even see the

  3. Message and Solution – Always review the whole message (it can be long, but it is worth it) and possible solution. It can give you a good hint about what to do.

  4. Type – Based on the Type of the problem, you can investigate further.

    • Data – There is a problem to find data. To find out which tables the accelerator tries to read, review also the “Data Lookups” field on the price list/grid item. It can give you an idea what tables and filters are used to look for data and it can help you to find the problem.

  5. Technical Element Name – This could give you an indication of when (during calculation of which field) the problem happened. This name does not have to match exactly the label of the field visible in the price list/grid, but it can still give you some idea where the problem occurred.

Review Config Lookups

If you have doubts whether your configuration in Company Parameters is used during the calculation, you should review the contents of the Config Lookups field.

It shows you which tables (in the PP Name column) were searched, in which order, and for what Product Segmentation values (Keys column).

Review Data Lookups

Is warnings indicate that some data are missing, you can also review the Data Lookups field which will show you which data were searched, with what filters and sorting. This is more or less technical information, but it could be a good indication for you during troubleshooting.