Deviation in Discount on AR Document
I am setting up an approval process whereby when a user changes the established discount that a client is allowed on an AR Marketing Document the process gets triggered.
I have managed to set it up document by document using the various table and field names but want something more elegent. As that the discount field has the same Field Index for all AR Documents and it is a Title Field I should be able to use
SELECT DISTINCT 'TRUE'
WHERE $[24.0.0] != (Select Discount from OCRD where cardcode = $[$4.0.0])
no matter if I change the discount or not I always get an internal error message but the transaction still gets posted.
what's up with this then???