• COGS reporting

    Looking for any insight. As far as I can tell there is not direct report that links COGs to deliveries. I've created a quick SQL query that provides me the necessary details from GACCENTRYD based on the TYP = stock. This works for a very base understanding…
  • Invoice Lines SQL Query

    anybody knows how i can get the backend SQL query for 'Invoice Lines' for <<sage X3 sale >> under invoices
  • Query tool - How to get data from custom fields

    Hello everyone, I am running a Query to get some info about a item. Table ITMMASTER ; Field ITMREF ; Others Fields by default. The info that i need is related with a Custom Field, where i need the value of the field and their descripton. Table…
  • Filtering Customers by Company ID in Sage X3

    Hello Team, Could you help me with the following question. Is it possible to filter Customers by Company ID in Sage X3? If yes, could you describe how to do it? Regards, Andrew