IF CalculatedCorrectly2 AND ((RFStatEntryTotal2."Outstanding Quantity" <> 0) OR RFEmployeeSetup."Ignore Action Outst. Qty of 0") AND ((RFStatEntryTotal2."Available Volume" >= OutboundWhseRequestFilter."Minimum Avail. Volume") AND ((RFStatEntryTotal2."Available Volume" <= OutboundWhseRequestFilter."Maximum Avail. Volume") OR (OutboundWhseRequestFilter."Maximum Avail. Volume" = 0))) AND ((RFStatEntryTotal2."Available Gross Weight" >= OutboundWhseRequestFilter."Minimum Avail. Gross Weight") AND ((RFStatEntryTotal2."Available Gross Weight" <= OutboundWhseRequestFilter."Minimum Avail. Gross Weight") OR (OutboundWhseRequestFilter."Maximum Avail. Gross Weight" = 0))) AND ((RFStatEntryTotal2."Net Weight (Base)" >= OutboundWhseRequestFilter."Minimum Avail. Net Weight") AND ((RFStatEntryTotal2."Net Weight (Base)" <= OutboundWhseRequestFilter."Maximum Avail. Net Weight") OR (OutboundWhseRequestFilter."Maximum Avail. Net Weight" = 0))) AND ((RFStatEntryTotal2."Available Qty. (Base)" >= OutboundWhseRequestFilter."Minimum Avail. Qty. (Base)") AND ((RFStatEntryTotal2."Available Qty. (Base)" <= OutboundWhseRequestFilter."Maximum Avail. Qty. (Base)") OR (OutboundWhseRequestFilter."Maximum Avail. Qty. (Base)" = 0))) AND ((RFStatEntryTotal2."Available Amount" >= OutboundWhseRequestFilter."Minimum Avail. Amount") AND ((RFStatEntryTotal2."Available Amount" <= OutboundWhseRequestFilter."Maximum Avail. Amount") OR (OutboundWhseRequestFilter."Maximum Avail. Amount" = 0))) AND ((RFStatEntryTotal2."Outstanding No. of Lines" >= OutboundWhseRequestFilter."Minimum Outst. No. of Lines") AND ((RFStatEntryTotal2."Outstanding No. of Lines" <= OutboundWhseRequestFilter."Maximum Outst. No. of Lines") OR (OutboundWhseRequestFilter."Maximum Outst. No. of Lines" = 0))) AND (((ValueType = 0) AND (RFStatEntryTotal2."Outstanding Quantity" <> 0)) OR ((ValueType = 1) AND (RFStatEntryTotal2."Available Quantity" <> 0)) OR ((ValueType = 2) AND (RFStatEntryTotal2."Total Available Quantity" <> 0)) OR ((ValueType = 3) AND (RFStatEntryTotal2."Outstanding Quantity" = RFStatEntryTotal2."Available Quantity")) OR ((ValueType = 4) AND (RFStatEntryTotal2."Total Available Quantity" > RFStatEntryTotal2."Available Quantity"))) OR ((ValueType = 5) AND (RFStatEntryTotal2."Inv. Reserved Quantity" <> 0)) OR ((ValueType = 6) AND (RFStatEntryTotal2."Outstanding Quantity" <> 0) AND (RFStatEntryTotal2.Quantity = RFStatEntryTotal2."Outstanding Quantity")) OR ((ValueType = 7) AND (RFStatEntryTotal2."Outstanding Quantity" <> 0) AND (WarehouseRequestTmp."Shipment Date" < WORKDATE)) OR ((ValueType = 8) AND (RFStatEntryTotal2."ATO Quantity" <> 0)) OR ((ValueType = 10) AND (RFStatEntryTotal2."Outstanding No. of Lines" = 1) AND (RFStatEntryTotal2."Outstanding Quantity" <> 0)) OR ((ValueType = 11) AND (RFStatEntryTotal2."Outstanding No. of Lines" = 1) AND (RFStatEntryTotal2."Available Quantity" <> 0)) OR ((ValueType = 12) AND (RFStatEntryTotal2."Outstanding No. of Lines" = 1) AND (RFStatEntryTotal2."Total Available Quantity" <> 0)) OR ((ValueType = 13) AND (RFStatEntryTotal2."Outstanding No. of Lines" = 1) AND (RFStatEntryTotal2."Outstanding Quantity" = RFStatEntryTotal2."Available Quantity")) OR ((ValueType = 14) AND (RFStatEntryTotal2."Outstanding No. of Lines" = 1) AND (RFStatEntryTotal2."Total Available Quantity" > RFStatEntryTotal2."Available Quantity")) OR ((ValueType = 15) AND (RFStatEntryTotal2."Outstanding No. of Lines" = 1) AND (RFStatEntryTotal2."Inv. Reserved Quantity" <> 0)) OR ((ValueType = 16) AND (RFStatEntryTotal2."Outstanding No. of Lines" = 1) AND (RFStatEntryTotal2."Outstanding Quantity" <> 0) AND (RFStatEntryTotal2.Quantity = RFStatEntryTotal2."Outstanding Quantity")) OR ((ValueType = 17) AND (RFStatEntryTotal2."Outstanding No. of Lines" = 1) AND (RFStatEntryTotal2."Outstanding Quantity" <> 0) AND (WarehouseRequestTmp."Shipment Date" < WORKDATE)) OR ((ValueType = 18) AND (RFStatEntryTotal2."Outstanding No. of Lines" = 1) AND (RFStatEntryTotal2."ATO Quantity" <> 0)) THEN BEGIN
Answers
Remove the third closing bracket the following line like this
and add a third closing bracket the last line like this
Independent Consultant/Developer
blog: https://dynamicsuser.net/nav/b/ara3n