Hi Susan,

That'll work. However, it would be faster just to check the flag in the Sales Order Header that indicates whether costing has been done ("Costed Status"). It will be TRUE() if the invoice/credit note has not been run through day end.

It depends a little on the ultimate list you are trying to create. If it is just a list of items, then hitting the item master alone will be much faster than going through OrderEntry.

If you just want information of the Invoice header, then use the "Costed Status" in the sales order header.

You can validate the information you are seeing by checking the "shipped not costed" field as well, but linking across three files (order details, order header and inventory master) is fairly disk intensive.