Joined: 26 Jan 2011
Location: United States
Online Status: Offline
Posts: 28
Topic: Sales Orders having 2 different fields Posted: 06 Apr 2011 at 4:58am
I am trying to filter a report to include sales orders having two specific items. My report needs to show all open sales orders having doors and lite kits. I have filtered the report to only include doors and litekits and have grouped the report by sales order number with a count summary and filtered the count to be greater than 1. This almost worked, but some orders have more than one door on the order and no lite kits. The distinct count summary will return the same result because the they are different type doors. Ex. DR Foam-H, DR Foam-UL. Any ideas of how to resolve this?
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot delete your posts in this forum You cannot edit your posts in this forum You cannot create polls in this forum You cannot vote in polls in this forum