Skip to Content
0
Former Member
Apr 14, 2010 at 09:44 PM

Sales Reports with Partial Shipments

80 Views

Hello,

I need to write a sales report for open orders. If the order has been partially shipped, I just need to pull what remains to be shipped and display this total.

If the order has not been partially shipped, I need to pull the doc total.

How do I specify if an order has been partially shipped or not? Is there any way to say, "If a line in RDR1 has been shipped or partially shipped, sum the totals of OpenCreQty * Price, else pull DocTotal"?

I need to display the report in 1 line per sales order.

Thanks in advance,

Chris