Browse By Tags

We currently have Sage 100 Contractor being hosted on Azure VM. I would like to know if it's possible to connect Power BI to our Sage database to create dashboard from Power BI.

I am trying to find a way to return the description of a UDF using SQL. I am currently using the following: Select * FROM JT_Employee But I need to bring forward the descriptions of the UDF's. So for example, "UDF_F_Name" would return "Employee…

Documentation to migrate from Sage 100 Premium on-premises to Sage 100 SQL in Sage Partner Cloud SPCSage100MigrationGuide_forSQLServerData.pdf

A user of ours has recently been set up on a newly refurbished device. Device is on Windows 11 While logged into Sage 2022 they can drill down to specific location but when trying to print or preview the get the following alert "The database login…

Hello folks, We are starting the process of upgrading from an older version of MAS 90 which ran on Providex to 2023 Premium. There are a number of custom apps that we've developed over the years to run with our MAS data and they all used the MAS ODBC…

Hi, I am trying to build a excel report using SQL to give me MRP demand. I have built 90% of the report but need to add in the works orders required/demand quantities which haven't been allocated to stock. Below is my current query - any help would be…

We are currently upgrading our sql servers and have a setup where we have sqla and sqlb which both replicate each other in case of any issues one then fails over to the other (high availability). We are having an issue where it looks like our sage200…

Microsoft SQL Server “Forced encryption” flag is not supported for Sage X3. Microsoft SQL Server secure connections can be set up through the Sage X3 Management Console from Sage X3 2023 R2. The Console documentation details how to secure Microsoft…

When making changes to a production system such as updating SQL passwords, changing SQL servers, or using a different SQL account, how do we get to the edit screen for the Vault and Store databases configurations? Alternatively, is there a way to make…

Our business would like to print packing slips before delivery confirmation. In most cases, I can see the lot numbers from screen WK4STD1 but I cannot find the table where that lot is stored. SDELIVERYD seems to only have a lot number for some records…

Bonjour, J'utilise dans X3 une requête SQL qui va notamment chercher des données dans un menu local (3101 : plan d'amortissement). Ce menu local est paramétré avec une largeur max de 25 caractères : Lorsque je génère la requête, à l'écran, le résultat…

Hi all, We do most of our customer reports based off the GL_DetailPostings table. I have a few reports filtered to only show "SO" module transactions and I pull in some additional data from the InvoiceHistoryHeader table but now am being asked to…

Hello I'm upgrading from 2018 Advance to 2022 Premium. When on the server we can run canned reports within Sage 2022 without error. When we try and run reports from a client 2022 workstation we get "The database login failed. Error in File GL_ChartofAccountxxx…

Hi community, We have a small issue with the POP List. Sometimes, an order is fully received but hasn't been invoiced yet. In the system, it still appears as "Live." It's okay, but we need a better way to see what's going on. Each user as their specific…

OK This isn't a question, more a handy workaround. I worked up a SQL query in the MS SQL interface on the server and it was working well (the idea was an expanded "trial kitting" report for subcontract BoMs to be able to model how much we would need to…

Currently on Sage 100 Premium 2021; I need to track changes to AR_RepetitiveInvoiceHeader and AR_RepetitiveInvoiceDetail, but no built-in audit log exists. I've toyed with scripting to a UDT but now that we've moved to Premium, the power of MS SQL is…

Como fazer a ligação de um pc posto ao pc servidor na aplicação 50c?

We are planning on upgrading our SQL from 2012 SP3 to SP4 (11.0.7001.0). I just wanted to see if others have already done this, and if they had any issues.

Hi there, I was wondering if someone could point me in the right direction perhaps please? so I am trying to find out what group a stock item (inventory item) belongs. SELECT * FROM StkItem WHERE Code = <code> SELECT * FROM _btblInvoiceLineDetails…

Good day any information on the Task will be much appreciated What ever this task is, is very resource resource driven and customers are not happy. Customers computers become very solo, till the point where it's unusable and the keep needing to…

I am facing an issue while connecting the DBMS tools installation path, although I get the path automatically but when I select that I see the error (attached below) . I have added the version and sql path in the solutions.xml file but still no luck…

Hola, Hay alguna documentación actualizada sobre la base de datos de Sage50? La unica que he encontrado es esta ( https://sage50c.sage.es/help50c/Content/estructura-DB-excel.htm ) y no me cuadra cuando hago una consulta personalizada Gracias y un…

Hi there, hope everyone is well. Quick Question if I may. Is there training or documentation on the SQL table structures and queries for Evolution 200's database? I mean with trail and error and the Database Dictionary one gets to a SQL query that…

Hi, I have the below code but need to add in the the delivery postcode (highlighted yellow below) - how would I add this in, I'm not to sure of the joins? SELECT DocumentNo, DocumentDate, DocumentTypeID, DocumentStatusID, SOPOrderReturnLine.ItemCode…

Good day, I am in the process of buying SQL for our Sage Evolution package. We have 20 licenses at the moment for Sage (for our finance team who uses the front end). I know we need to get a Standard License, Media Pack, and then CAL's. CAL's are extremely…