Hi.
Sage X3: v12 Patch 30
Console version: CFG 2.54.0.5
SQL Server: 2019 Standard
When I import a relatively small folder (about 20 GB).
```
Storage is not online
Database filegroups check failed
Error while creating database schema…
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…
Buenas. Desde el cálculo del mantenimiento de pedidos de compra estoy intentando abrir una consulta con una agrupación "group by" para obtener un resultado que almaceno en una tabla, y al entrar a la ficha de pedido de compra (porque ejecuto mi función…
Bonjour
j'essaie de créer une VUE sur X3 à partir d'une requête sql server et qui contient au niveau de la clause Where l'opérateur 'LIKE', en essayant de valider la Vue sur X3 j'ai une erreur applicative qui me signale l'erreur suivante :" _INT ->…
I have a client using Sage 100 Premium for core accounting for 200 companies installed in the default instance. I need to upgrade for 2019 to 2021, what is the procedure to keep using the default instance on a single server? Ideas? There are multiple…
Hi,
I need to upgrade Sage100 desktop application from Sage100 Advanced to Sage100 Premium.
Question 1 - What are the perquisites for upgrading/migrating?
Question 2 - What will happen to my data if I switched from Sage100 Advanced to Sage100 Premium…
Hello,
When i'm trying to access the X3 reference folder and the pilot folder i get below error.
Create session error : X3 engine error: [Microsoft][SQL Server Native Client 11.0][SQL Server]Invalid object name 'ADOVAL'. : SQL Server ErrorDeta …
Version: Sage 100cloud Premium 2020 (Version 6.20.0.01)
Additional software: Scanco Operations Management & Multi-bin, Some custom DSD programming
Hello all! First post here. Looking for some assistance when it comes to replicating data for reporting…
Hi all, I am looking at the price of SQL Server Web vs Standard and the price gap is huge. The web version is much more cheaper compared to Standard. In the installation guide of Sage CRM did not mention if we were suppose to choose Standard over Web…
I am trying to join one of the following tables to GACCOUNT. PORDERQ or ITMMASTER. There doesn't seem to be many ways to get from GACCOUNT to an ITMREF_0 or POHNUM.
I have tried a few different options but none seem to be working. Your help, as always…
I am looking to join the two above tables, According to the data models, the join is supposed to happen like this: 1;ACCCOD. How is that supposed to work if STOJOU doesn't have any accounting code? Also what does the 1 mean in the data model? Any and…
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…
I am building out existing access report in sagex3. Where can I find GLcode and descriptions? I've looked at the accounting data model tab and am just not really sure what I am looking for.
Thank you in advance!
I am looking to get the sql column name for total requirements qty located in available stock. If anyone could point me in the right direction, it would be greatly appreciated.
I am creating an invoicing table that has Item, Lot and QtyOrdered. Is it possible to see per lot allocation by sales order number? I know you are able to see the qty on hand/lot. For example, if I have an item that exists in multiple lots, I only want…
It's always the way isn't it? You don't see any articles about creating indexes then several come all at once! Chris Hann recently wrote the article " How to use the Database Optimization function " but what if you want to create a new index which uses…
Good Morning! I am currently working on swapping from Process Pro To Sagex3 and one of the columns in PP is Usage qty which is total qty used for the year. Is there a field in sagex3 for this? As always, your responses are greatly appreciated!
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
I'm confused about the relationship between Sage data files and the SQL database. If a server dies, or gets ransomed, my first step will obviously be to reload the application server from backup, then the SQL backups. There is potential for different…
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…
When we try to create an index in table GACCENTRYA including field CCE_1, SAGE X3 gives error. For now solution is to add the index manually directly in the SQL Server, any solution to make this solution permanent? Thanks.
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!