Category Sage X3

Sage X3 Tip & Trick – How to create an Excel report that extracts Sage X3 data directly from the SQL database based on selected parameters.

Step 1 – Create a SQL user and password. The user should only have reading/viewing rights. This user will be used to extract the data into Excel. Step 2 – Now that the user is created, you need to setup the…

Read MoreSage X3 Tip & Trick – How to create an Excel report that extracts Sage X3 data directly from the SQL database based on selected parameters.

KB20230807/01: Sage X3 Tip & Trick – How to create a workflow that will automatically email an invoice to a customer.

Sage X3 has a number of add-ons that you can take advantage of to streamline emailing your documents to your customers, such as EDD (Electronic Document Distribution), EDM (Electronic Document Management) and PIA (Purchase Invoice Automation). But in standard Sage…

Read MoreKB20230807/01: Sage X3 Tip & Trick – How to create a workflow that will automatically email an invoice to a customer.