When I go to add Historical Transactions to Customers the window that pops up is called Historical Sales Invoice and it requires the items purchased and the account/s they would go to. These are things I do not have.
I have entered Historical Transactions…
Looking for a downloadable data dictionary for all Sage products but specifically Sage CRM that shows fields with data type, definition, values, table, schema, etc.
I am attempting to create a Power BI report with some of the data from Sage. It needs to pull data about the job checklist items. However, for some reason the Checklist_12 item is not updating in the replicator database (The one we use to push Sage data…
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.
How do we get the credit status on the sales order to display 'Prepayment'? We have the payment terms configured as prepayment and the parameters in TC, TRS and VEN appear to be set accordingly.
Hoping someone can assist. Thanks, Christine
Is any one else having issues with SQL crashing in the middle of the day, just randomly? I can be working fine all day, and not necessarily be working in SAGE and I get an error message "Failed to connect to the specified SQL Server. Connection to the…
I am trying to use BOI to create orders. I am able to initiate a session on a server running the Advanced version of Sage 100, but not on a server running the Standard version.
I thought I had to do some type of registration at first, but then I tried…
Hello,
We just upgraded from an older version of MAS 90 / Providex to Sage 2023 100 Premium.
It appears that all of the NULL values in our company tables have been converted to empty data, with the exception maybe of the date fields.
This is causing…
I am trying to open a company for my Sage 50 class but when I try to open the PDF file, it says "Sage 50 cannot open the database because the database engine reported an error. Please see the error log for more information"
I have tried re-installing…
Sage X3 v12p34, SQL Server 2022 Standard edition.
Full error as follows: `Connection to server failed : X3 engine error: [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]The SELECT permission was denied on the object 'APLLCK', database 'x3v12'…
I added the JrnlHdr to the report twice in hoping the link the second JrnlHdr to itself. How do I do this? My first instance JrnlHdr is restricted to JrnlHdr.JournalKey_Journal 11 - Sales Orders. While my second is restricted to JrnlHdr.JournalKey_Journal…
Can anyone tell me where, in the database, I can find the invoice matching data? I am looking at the GACCENTRYD table but it seems to have some holes in the data. Any guidance would be much appreciated.
Regards,
Dave
Bonjour
Je suis débutante sur Sage et j'ai accès à une base de test SQL "bijou". Je souhaite de dé-comptabiliser une facture et apporter les modifications nécessaires. Serait-il possible de me fournir la requête SQL appropriée ?
Merci d'avance.
Long time ERP consultant here, but new to Sage 50. I have years of experience with Actian Zen (fka Pervasive SQL). But at a Sage 50 install, where the heck is Actian Control Center? Where would I go to write a simple SQL statement? Also missing are DDF…
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…
Is there a way to add Invoice header text after the invoice has been posted? I'm looking in the tables and there is a code but where is the actual text placed? any help appreciated. thanks.
Hi all,
It looks SAGE ERP is compatible only with Non-CDB Oracle DB.
So this will create problems if we would adopt DBCS as SAGE ERP DB, correct?
Any similar experience on SAGE to share?
Is there any workaround you can suggest in order to make…
Hi ClarkM and Erzsi_I
I see that that a similar question was posted by slacka 6 months ago, and remains unfixed.
I don't understand why this issue hasn't been taken seriously. This seems to be a critical issue in the way a client is able to, or in…
I turned my timeslips 2017 and the main.db was missing. i now can't find it to access my data. can someone please call me at 310-556-1001 or refer me to someone who can find it? I found my tseg.fdb file but that is it.
I am only looking to find specific inventory movements in the STOJOU table and need a way to determine the Type of the Transaction
I see the TRSTYP_0 field but cannot find the definition of what those values represent.
Can anyone help?
I have successfully upgraded my Sage 300 install from version 2022 PU2 to 2024 PU1. Thus far no problems have been found running it.
On the Database Server, in MS SQL Server Management Studio however, multiple new users were created during the install…
Hello, I am trying to get data about transactions made per account between dates and get information about related documents with transactions. Payable and receivable. So I need Purchase Orders and Sales Orders documents etc. What I know / discovered…