x Want to participate? Join the group to interact

  • Invoice Lines SQL Query

    anybody knows how i can get the backend SQL query for 'Invoice Lines' for <<sage X3 sale >> under invoices

  • Required stock in-transit reconciliation report.

    Amount is being posted into In-transit account through inter-site transfer and container management, but not able to reconcile. Hence need a report to reconcile the transactions with Goods In-transit A/c.

  • 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

  • Companies and Sites in Sage X3

    Hello Team, Could you please help me with the following questions? My Customer wants to filter invoices by Company and Site codes in Sage X3. But, I cannot find how to filter Customers by Company and Site codes. For example. I created two invoices. Both…

  • 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…

  • format datetime$ to a string

    Hello, I'd like to convert datatime in a field to a string. Using datetime$ gives me '2018-06-20T07:47:32Z'. How can I get rid of all the signs between the digits? Thanks Ania

*Community Hub is the new name for Sage City