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.
I am trying to apply the Sage 2020.1 update. During the update, when it scans for corruption it says that PL_JournalPDFLog.M4T has an ambiguous "file discrepancy" in it. The instructions say to simply Rebuild Key Files for any discrepancies, but alas…
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…
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…
Project and Job Costing (Job related) PO Receipts getting the error "Damaged data. Receipt. Table PORCPH1 not found.". All other PO receipts have no issues. Please help us to solve this issue. Our Version is Sage 300 ERP 2019 and Database is Sql server…
Hello All,
We are using SAGE 100. Somehow On PO qty coming in Stock status report is not Open PO Qty.
SAGE is pulling a open PO qty from somewhere - SAGE ppl kindly share your thoughts
In the below example, in main I m seeing a open PO qty but in…
Hello,
We had something strange happen once last week, and now once again today.
We had an order which was not acceessible through Sales Order and Quote History, so accounting contacted me. After checking our database, I noticed that there was no…
When MRP Generation is running, does it look at the open PO's, what does it look at? Does it look at Header or Detail line tables? Or does it go by the PO Log? Reason for asking is that I see a lot of entries in the PO Log that are not in the Header/Detail…
Hello,
We have been trying to troubleshoot our slow performance with SAGE 100 PREMIUM 2018 and are running out of options. I have read all the articles here and on the knowledge-base, and nothing seems to be improving our performance. My last inquiry…
Hi Everyone :),
First time here so please go easy on me.
I am in charge of IT at this institute and yesterday my CFO called me and said that the accountants told her about a wrong entry that has been made couple of years back (3).
the entry is…
Hello,
Our company MAS system has been running very slowly and I would like to delete some records form our database. There does not seem to be information on certain tables inside of SAGE under File Layouts and Program Information. Specifically, I…
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 recently found a discrepancy in values between the quantities tab and the cost detail tab within Item inquiry on a few items.
After researching in the Knowledge Base, I came across the following steps to clear out the issue:
Update all transactions…
Sage 100 Version 5.20
Crystal 2011 for Sage
Window server 2012 R2
Ok, here is an odd one. We had been having incorrect data running a Inventory List via Crystal. We have a total of 600 items. When I add a filter for Category 2 data I am getting…
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…
We use Abacus for calendaring and entry of time by Attorneys. We then push the time into Time slips for the billing/reporting. A few weeks ago, we started receiving this error message:
Sage Timeslips could not find the expected record. The record may…
I am trying to support a client running Timeslips 2006 (I know, I know), and he is received error messages when opening the program: "your database has an error in an index file. This is not dangerous to your data and can be easily corrected"...and so…
Can someone advise if it is possible to find deleted POs? We are missing some documents that we know exist but cannot be found. It is possible that they might have been deleted by the users. Can we run a script in SQL manager?
I have a client who I just started with. They are seeing lots of issues which look like bad data corruption. The previous guy recommended they reboot the server whenever things hung up, so I think whole batches of data have been lost. BW still functions…
