I’ve looked through previous posts concerning my question but have not found anything that resembles it.
I’ve been asked to produce a report that let’s Customer Service know if an order has been closed but the Misc. Charge was never invoiced.
I have a BAQ that seems to be working but I’m wondering if I’m overthinking this whole thing.
Currently I’m looking at OrderHed, OrderDtl, OrderRel, InvcHead, InvcDtl, InvcMisc and OrderMsc.
Right now I’m looking at Closed Lines, Closed Releases off of OrderDtl and OrderRel. Then I’m looking to see if there is a Misc. Charge with no associated invoice, therefore I want to know the OrderNum.
With the tables I’m pulling does this sound correct?