Brand new install of Sage 300 2024 and PU1 on 2019 Server and 2019 SQL Server - not new workstations. Always have problems with the same 2 out of 6 workstations (all within 1-4yo) when it comes to Sage 300 workstation installs. I'm putting this out here…
This weekend i upgraded our systems from BW 2021sp14 to BW 2023 sp2.
But how long did it take?
My system is network of 15 desktops running Win 10 and Win11, on Server 2016 ( Dell T550 with RAIDed SSD drives ) all gigabit network connections
Our…
Hello,
Could someone please tell me where to find the banking details for a customer - the APVNR table gives the name, REMIT and the address but not banking. I checked the ELVEND and the EFLTLOG files to find the banking details but could not. I have…
Has anyone had to create a new V11 (or really any version) application server and connect it to an existing SQL Database server? Assume we don't have access to the old app server (although we might).
I have some ideas, but I'd like to know how others…
Dear, I am facing a problem in sage 300, I already have two companies in sage 300, but when I open a new company one old one company disconnected from data base, now my old company
doesn't show any thing, but in sql server all data is avail able. kindly…
Sage 2019 on Windows 10 32 or 64 Bit - having issues running accpac (not as administartor) - not even getting a Sage accpac login screen the splashscreen comes up and then disappears. Does not work in Win7 Comaptibility mode unless you are troubleshooting…
I am an IT tech and quick question regarding Timeslips 19 as I am new to installing and setting it up.
I created a Hyper-V server which has a C drive for programs and D drive for Data. I created this way to seperate files from programs. My question…
After successfully upgrading sage 300 to 17.1 on a server, I go through the process of updating the company files from 15.1 without any issues. I can open all files except the main file and I get an error saying that " upgrade cannot continue due to consistency…
Hello, how can my client share thier "sage 50 pro" data file with me (I have the accountant edition of sage 50), so i can work on thier file remotely? And simultaneously? Also, is there a link and/or video that discusses the information to show the client…
Hi, I am trying to determine why my GL and AP control accounts dont balance.
Yes, I know I can isolate GL only transactions from my control account, but I would like to build a more robust answer.
To this end, I would like to build a query in sql…
Hi,
We want to upgrade one of our Sage databases to Sage 2017, while maintaining the other databases temporarily on Sage 300 ERP 6.0. The network will be same but different application and database servers. Will there be any major issues?
Priti
I was going through and trying to update one of the servers we have and found an older version of the MySQL Connector/ODBC and was wondering if anyone has had any experiences with upgrading the ODBC Connector from version 5.2(a) to 5.3.8 for "Sage 50…
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! My company has purchased Timeslips 2017 and I am upgrading from 2013 on a Windows Server 2012 this weekend. I will first do the data verification tonight, and hopefully all will go well with that. Then, over the weekend, I will upgrade the current…
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…
Can anyone offer any sample SQL scripts for getting information, such as Customer Information (given a customer ID), sales order information (given a sales order number or customer ID), and/or inventory information (given an Item ID) out of the database…
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?
MS SQL server 2012, Sage 300 2014 PU 3
I am trying to restore a test database using the most recent backup of its associated production database - in SQL Server Management Studio. I am restoring to another name and that task completes without errors…
When I go to Item number change and processing I have an error message:
Cannot open database "ccs.net.ccscom" requested by the login.The login failed.
Any idea
Dear Experts,
This is my first installation of Sage ERP X3. I followed installation document and installed everything accordingly. But in console application server Sage ERP X3 is not getting activated. Status is showing IDLE. It is running up to database…
The last updated datetime stamp for every record in Sage 300 is stored in two fields AUDTDATE and AUDTTIME and from the forum I've learned that AUDTTIME is in GMT time. From my own testing it seems AUDTDATE is also part of the GMT datetime format meaning…