With Sage X3 2022 R4, a new prerequisite was introduced for the Sage X3 console, the requirement to install PowerShell v7.2+ and, subsequently, the SqlServer module for PowerShell that allows database scripts to be executed when configuring the application…
In my previous post, I explained how to deploy a SQL Elastic Pool in Azure Portal. In this post, I am going to show how to perform a Sage X3 Solution configuration using the deployed Database, so let's dive right in.
To create a solution, open the Solutions…
You may have created some custom views in your Sage X3 system but are finding them slow to execute. The first step in diagnosing poorly performing SQL is often checking the SQL execution plan, but how can you do this with Sage X3 custom views?
First…
Hi, as the subject says, I am building a report to pull sales numbers per company by GLCode in sql server. I'm having a hard time getting data that looks correct. I have tried a few different ways of joining SORDER table to GACCOUNT table. I've tried…
As seen above, I am looking for received/delivered qty from a Purchase Order. Is it the Received STK or PUR in the PORDERQ table? so far I have been using received stk, but am unsure if that is correct
How are suppliers set up? I see in the ITMBPS table, there is a flag for default supplier which makes me think that if it is not a default supplier, is it the last supplier that updates anytime an item is received from a new supplier?
As seen in the subject, I am looking to join the STOJOU table to the SINVOICED table without the use of the ITMREF column. Data models show a one way arrow from STOJOU to SINVOICED with VCRNUM;VCRLIN. I am unsure of what to do with that, with VCRNUM only…
Good day everyone, I am looking for the sales FOB field in sage x3. If there is no field in x3, is there a column in sql? So far I have been unsuccessful in finding said field. Any guidance would be greatly appreciated. Thank you in advance!
Bonjour,
Quelqu'un a réussi à installer la dernière version de la V12 ( V12.0.21 - 2020 R1) avec SQL SERVER 2014 SE R1
je reçois ce message lors de la configuration de la base par la console.
merci par avance
Hi everyone
someone has successfully installed the latest V12 update ( V12.0.21 - 2020 R1) with SQL SERVER 2014 (not R2) I receive this message while configuring the database by the console
any help please
