We have a custom field on our Sale Order screen that is set to the party responsible for delivery charges. Our business rules indicate that if the value of this field is set to Our Company paying for the delivery charges, there is a specific Non Stock Inventory ID that must be on the Sales Order.
My concern with setting up an approval map to catch when this field is set but the required Inventory ID is not included in sales lines is with how I assume Acumatica will do the matching.
If my rule says Sales Order → Delivery Charges Paid By = Our Company and Sales Order Lines → Inventory ID <> INSTALLATION, it will be matching every line of the sales order and putting the document into approval, rather than the logic if NONE of the Sales Order Lines match.
Am I correct in my assumption of how this will be processed? If so, is there a workaround to achieve the desired result?