Hi,
I am trying to generate a dashboard for our warehouse manager. What I want to do is count the number of unique sales orders by dates that are released but not 'back orders' ie, have no prior shipments.
So, How do I count unique sales headers for each order date, where status=released and there are no sales shipments?
Thanks,
Dan
Date
Votes
1 comment
-
Jet Reports Historic Posts Hi Dan -
How do you distinguish a "sales shipment"?
Would that be if there are no entries for any associated line in the "Sales Line" table which contain a shipment date? Or, maybe "Qty. Shipped (Base)" equals zero?
If that last example applied, you could probably do something like:
=NL("Count","Sales Header",,"Order Date",{some date here},"Status","Released","=NL(""Sum"",""Sales Line"",""Qty. Shipped (Base)"",""Document No."",NF(,""No.""))","NUMBER&0")
It simply returns the count of the "Sales Header" records (based on date and status) where the sum of all the "Qty. Shipped (Base)" fields of the related records in the "Sales Line" table is zero.
I hope that helps.
Please sign in to leave a comment.