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.
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.
Where can I find the time an order was created? I can only seem to find the day in the ORDDATE field in the OEORDH table. Does Sage store this somewhere in the database tables?
Thank you
I have been trying to transfer items from one location to another but every time I try, I receive an error with the importation.
What I did was try to export a single transfer, however, it exported everything even the ones that are posted from way…
We have Sage 300 2020 running on a Windows RDS server with multiple users accessing the application via RemoteApp programs. Everything has been running fine for a couple of years but randomly last month our users cannot export files any more.
A user…
We are on Sage 100 Advanced v2022.1 and I don't see anywhere a Sales Forecasting report or option to enter numbers or imported via VI.
We have a new Sales Executive and he wants me to import sales forecast numbers, by Customer and Item to produce a…
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…
We restored a backup of one of our companies to test and now when we enter sage login info it just crashes with no error. Other companies work so it has to be the database but it is the same as in production. I change the database setup to go straight…
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…
I just upgraded from Sage 2020 to Sage 2023 and can't get any of my existing (or new) VI Import Jobs to work. When I try to actually run the job and test them, I get the message:
"VI JOB_NAME Unable to open [wdx][odb]<dsn_name>"
I don't get this message…
Hi,
We are experiencing an odd situation. When in location details and drilling down on the quantity on S/O we are missing orders. It shows the correct quantity but you are unable to see the list of orders.
-Customers allow backorders, are not on…
Hi I installed Sage 300 ERP software on a client machine. The installation is complete and successful. But when I run the sage software, this error message "Database is locked". The client is a windows 10 64 bit. I need your help ? THANKS
Has anyone run into an issue with a general journal posting that occurred months earlier now showing a different result if you were to run the report today? In January we had one entry, and if we run the report today, it shows 3 of the same entry. For…
Hi All,
In my table, there is value 3, 4, 5 in RECSTATUS column for BKTRANH table.
But there is no entries for 3, 4, 5 in AOM.
Can anyone help me on what is the RECSTATUS value for 3, 4, 5 in BKTRANH?
Thanks.
Hi everyone. I'm hoping someone here can answer this, rather than having to jump into the support gauntlet.
I work for an IT firm and a client of ours is presently running Sage 300 on a server VM, connecting to an MS SQL database on another VM, which…
I am trying to export the component list for parts within Business Works. There is no way to do this through the program, but was told you can do this through a query in excel. Does anyone have experience with this? Can someone provide steps to query…
Would you kindly let me know the Max. Length of SQL password Sage Intelligence Acceptable?
My customer change SQL Password to 64bits length…
After change, all Sage300 feature works fine but only Sage Intelligence caused password invalid.
Hi all,
On my Sage 300 v2023 > Database Setup, I have 2 existing System databases for testing, which is PCISYS and SAMSYS below.
I wanted to create another 1 but get this error instead. I have run RVSpy & DBSpy but no error visible.
Anyone know…
I'm customizing the Ardinvo report in crystal reports. I took a copy of the report, saved it as a different file name.
Now I want to add some fields to it that are not in the set of data tables already in the report.
In the "Field Explorer" I right…
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…
I'm installing Sage 50 Premium in a Convenience Store which has a POS system. This POS system generates a plethora of reports & data, all of which is available in Excel format. The daily sales report it generates would be the feedstock for the SAGE invoicing…
Hi all,
We are having an issue while adding a SAGE300 component into a Visual Studio form (.NET project).
The error we received is: Failed to import the ActiveX control. Please ensure it is properly registered.
We have registered the accpacic1500…
Hello,
Could some one please advise where the description would be stored on the sql server please ? Which table would it be under as I am not able to find it. Thank you - Shashank