SQL & Graphical Query

Question

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 lines as the invoices might muliple lines. How can I search for a certain month and take away the duplicated lines.Also, under net price+tax its showing product name instead of the price. Also, what would be the SQL code.

Esfahani · Answer

Hello, For the date criteria, you would need to use gdat$ to build the date, take a look at ACH032 graphical query for example. 
 For querying distinct record you might want to use SQL query tool , or use the option of creating View, which is discussed in below post. https://sagecity.na.sage.com/support_communities/sage_erp_x3/f/sage-x3-general-discussion-forum/84704/if-then-possible-with-graphical-query-tool/252220#252220 
 Regards

Sage X3

SQL & Graphical Query

COMMUNITY

COMPANY

PARTNERS

SUPPORT & TRAINING