Sage X3 View + Query Tool
Sage X3 View + Query Tool This is to show you how to create a View in Sage X3, apply the view in graphical query tool, and displaying it via navigation menu or home page. Scenario: We want to create a query to display product category, product code, statistical group 1, product site, available stock quantities and reject stock quantities of each sites. Create a new Product Quantity View with query below: SELECT ITM.TCLCOD_0, ITM.ITMREF_0, ITM.ITMDES1_0, ITM.TSICOD_0, ITM. TSICOD_1, ITF.STOFCY_0, ITV.PHYSTO_0, ITV.REJSTO_0 FROM ITMMASTER ITM INNER JOIN ITMFACILIT ITF ON ITF.ITMREF_0 = ITM.ITMREF_0 INNER JOIN ITMMVT ITV ON ITV.ITMREF_0 = ITF.ITMREF_0 AND ITV.STOFCY_0 = ITF.STOFCY_0 Development > Data and parameters > Views, Query tab: Field tab: Keys tab: Create a second Miscellaneous table View for group 1 (20) with query below. This is to retrieve group 1 text from miscellaneous table. SELECT IDENT2_0, TEXTE_0 FROM SEE