Browse By Tags

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…

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…

Sage 50 is not allowing me to go in new year and shows the message to check the data integrity through Advance database check. While following the message, it shows the message "sage 50 database verification tool has found a problem in your company file…

Hi Sage City community, I am currently working with Sage 300 ERP 2023 and trying to access general ledger account balances programmatically. I need to retrieve this data for a custom integration that I am doing. Could anyone guide me on which specific…

I’m trying to determine what table & field name lies behind the field in the yellow box below? Looks like I’ve got to drive some conditional logic with it for a report, but I can’t find it in the database. You get to it by clicking the Item/Tax button…

Hello, i've database file. i need to load data in my sage cre 300. I've installed sage cre 300 in my local machine but not found database dump and database load application. Could you guys help here how to connect with this database? Thanks, …

A general and important question When you insert a item into the estimate from the database the change date is the current date. What I want to know can a column for the data base change date be visible in the estimate file. This would make it easier…

Hi all. I am looking for the Column that store the deposit date of AR Receipt Batch. But ARBTA does not have Deposit Date column. Then I go to ARPJH and update the column DATEDEPST (Deposit Date), but the new value does not reflect on the AR Receipt…

Azure SQL Elastic Pools is heavens-send for a lot of partners and customers who are looking for an affordable, yet scalable SQL Database service for their Sage X3 projects. Making sure you are compliant with Microsoft's rather complicated SQL licensing…

Hi, i am experiencing error 40960 when i tried to login into sage 300 database on 3 separate workstations while other two workstations connected successfully. I have checked the DSN, redirected it and ensure everything is right BUT the issue still persist…

From the screen I can see the value for LOC, but not in database, the value is empty.

Survey: Did you already purchase Sage 2023 because of the "third-party database" issue and are disappointed that the 50% off deal only showed up today - seven months after the issue arose? We Did. Unless we missed an email somewhere along the way…

We have a legacy standard database that is set as a 3 digit phase code suffix, example 03000.000. We would like to convert it to a 2 digit suffix, example: 030000.00. I tried to merge a 2 digit and 3 digit but the merge routine rejected the operation;…

Dear Fellows, As you may all know that when you delete a folder in X3 it will not be deleted from database with all its references which will eventually increase your database size, and therefore i created an sql procedure that safely delete the folder…

I have updated few "JC phase" items in the estimate and then tried to update these item in "DATA Base" with utilizing " I have gone through all steps from inserting "Update DB" col and check make the items and also followed all steps after. …

Good morning everyone I would like to know if it is possible to make a connection to the Sage 50 DB, I currently have the US 2018 version. The reason is because I would like to be able to get information with a separate development and if it is possible…

Environment : Sage 50 version 2021 ( Canada ) recently upgraded from Sage 50 version 2020 ( Canada ). The .SAI and .SAJ files are stored on Microsoft OneDrive. My https://ceo365portal.na.sage.com/ has been activated and the Microsoft 365 Integration…

Hello, I'm working on a project and I need to be able to pull the same information the "Invoice History Printing" report pulls for a date. For my selected date, in our database we have about 3,000 invoices. The report, however, only pulls about 140…

Hello, I am completely new to this. I am a SQL DBA and I have been asked to take our OLD MAS90 system convert the data to SQL and write reports to allow accounting people to find data from our old system. We currently use MS Dynamics NAV. We switched…

We will be upgrading to Sage HRMS 2017 and Sage Employee Self Service 2017 soon. As our company has two data centers I am interested to know if these products support a SQL HA cluster so that I could offer failover capabilities that we've not had previously…

Sage50 Pro 2013 I am currently using a laptop, and trying to move to a desktop. The laptop was purchased new 9 months ago - was Vista "refurbished" to Windows 10 Home 64-bit before I purchased it. I installed the program with the offline installer…

We've recently moved from Sage 100 providex to SQL. Upon looking at our tables in SQL it appears that every field of type datetime now has been set to not allow null values. As a result all of those fields now automatically populate with 1753-01-01 (SQL…

Hello, I was hoping someone might be able to assist me. I am trying to create a report using the Sage 300 2014 database. I need to see the date that a user was created in the system and also need to know what type of license the user is assigned to…

Hi, We are using Sage 2014 and We have the following error message when we load data ( error=856, native code=476485). any clues? thanks

Hi, We ran the Data Integrity Check and we have the following error message:"E: Database XXDAT uses an application CS that is not installed. 1 Error found in Administrative Services. Any ideas?