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.
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 all,
I've come across an issue that I can't seem to find a solution for. My PC at home is Windows 11, all drivers and OS is fully updated. Even have a 64bit adobe reader installed as per another post similar to this.
I'm a student, using cloudpaging…
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 customer has a third party quoting and bidding software running with SQL Express. They want to move it into the same instance in standard SQL as Sage300 to allow more memory availability. Any issue with this or would a separate instance in standard…
Hi All,
Need object reference & table name for Item Maintenance --> More --> Item Pricing Maintenance --> Customer Price Schedule --> Pricing Method --> Price Discount Amount to pull the discounted price by running the script.
I right clicked on the…
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…
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…
When configuring the solution, the data server shows active, after setting appropriate paths, then clicking the "Application" button near the top of the screen, I'm getting the error below. I've followed the instruction documents and had no issues with…
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…
Hello,
I am trying to do a SQL query to see which users have had activity on a specific company ABC by doing a SQL query on the SY_ActivityLog table.
When I do a query where CompanyCode = 'ABC', I get MOST of the users that have had activity on ABC…
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…
We are planning to Re-installing Sage X3 ERP, CRM and HRMS with DB in a Single Server on our office to use as a test environment. Is this possible? if so, could someone link me to the right direction on how to achieve this?. Online references will be…
I have a challenge...can someone familiar with the Sage 300 database tables give me some advice?
I would like to query the database to find out if a certain document date correponds with a fiscal period that is currently locked for Accounts Payable…
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…
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
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…
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…
We were really hoping to stick with a 2008 box for the Accpac install. Did we miss our window of using 2008 by a version or two or are we long done with those versions?
We're also looking at the possibility of using server 2016. Is there any chance…
