• 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…
  • 4GL embedded Sql query presenting error on script run.

    Let me start by saying: Everything is DONE, except the sql query fails. This is the last piece holding up deployment. I am trying to embed a sql query in a 4gl script to pull specific data into a variable set, then email the results on a nightly scheduled…