I am trying to develop a query that involves aggregating invoice lines such that values for kits are the sum of their components.
I can see there is a flag (LINTYP_0) to determine what is a kit and what isn't, however I am having a hard time figuring…
I have the following Graphical query, the two tables are BPCUST AND SINVOICE.
How can I set a criteria for it to pull invoices that have a date of 5/01/2018 to 5/30/2018.
When I search for this its outputting all the invoices and duplicating…
