When adding/updating records within a profiler screen if the data item is a numeric item type (K/L/M) then options exist to validate that the entered value is less than or greater than a set value. This new feature allows you to validate that the ‘change’ in the entered value is not greater than another data item.
One option for this might be where users can enter their own expense values and they have an allowed ‘limit’ they can use per month, if they exceed the value then it requires an authorised user to enter the expense. Other options could be where stock items are ‘called off’ from a allocated booking and you need to validate the quantity against the total allocated value.
The validation option has been added as one of the X-Special Actions that are available within the data item parameters.
The configuration setting is defined as 141 NNN where NNN represents the data item number to validate the change in value against.When set you can amend the line to change the value downwards without restriction (to zero) but you can only increase the value by the amount in the referenced data item.
Article ID: 2448
Created On: Tue, Mar 24, 2026 at 2:28 PM
Last Updated On: Tue, Mar 24, 2026 at 2:29 PM
Online URL: https://kb.datafile.co.uk/article/screen-actions-data-item-quantity-validation-2448.html