Sage 100

Does any field in the SO_SalesOrderHeader table change when the order is in invoice data entry but not updated? Trying to find a way to sort these out of a BIE view. Any ideas are appreciated.

Yes, check out the field CurrentInvoiceNo. That field is populated with the invoice number and is used as a flag to block users from changing the S/O after its in invoicing.

Worked like a charm - Thanks Dawn!!