I am trying to generate a report to look at specific contracts. The first section uses NL rows to list the sales order lines.
The second section is to run a NL Rows for all production orders for the items listed by the first sections.
What is the best way to do this?
There is always more than one way to get to the data, but I would probably use NL("Filters") to get down to right set of the results.
1st Filter to retrieve all Sales Order Line based on whatever filter criteria is appropriate. 2nd Filter to retrieve all the Item No. based on the line numbers returned in Filter 1. Then a 3rd Filter to retrieve all Production Orders based on the item numbers returned in Filter 2.
Something like this...
