Client running Sage 100 v2018. Trying to export purchase order information based on two select criteria that is outside standard fields. I'm able to create a Perform for the individual selections and when I add one of the two perform functions to the export it works. But when I assign them both using the Sequence option it doesn't work. I tried to figure out how to join the two Select statements into one perform but I'm not a programmer and can't seem to figure it out. The two perform selects are :
cSelectStatement$="IF PO_PurchaseOrderHeader12.DateUpdated$ <= DTE(JUL(DTE(0)) - 60:""%Y%Mz%Dz"") { selected = isTRUE } ELSE { selected = isFALSE }"
The above perform will only select purchase orders that have been updated 60 days prior to the run date.
cSelectStatement$="IF PO_PurchaseOrderDetail01.QuantityOrdered = PO_PurchaseOrderDetail01.QuantityReceived { selected = isTRUE } ELSE { selected = isFALSE }"
The above perform will only select purchase orders where the quantity ordered and quantity received are the same.
What I'm trying to do is select purchase orders that have not had any activity for 60 days and where the ordered and received quatities are the same.
