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…
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…
Hello,
I was wondering if anyone else ran across this issue and if so, how it was resolved.
We have identical item numbers that appear when we search for an item in item inquiry and item maintenance. Selecting one of the item numbers results in…
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…
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…
Has anyone had experience with archiving the PO module? According to KB articles, moving POs and COs to history is the first step in improving performance in the PO module. Clean out all those old records. I have done this in a test environment and can…
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…
Sage300 CRE Version 17.1 Rev6
We had a power issue and the database server shut down unexpectedly during operations. After the server was powered on again, several users complained they were getting errors in the application. We tried restarting the…
I am using Dell Boomi software to retrieve data from our customers Sage Pervasive DB.
In order to do that, Boomi needs class name and connection url. It uses java and jdbc to connect to db.
Class name is: com.pervasive.jdbc.v2.Driver.
URL is in…
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…
The Sage 300 CRE C: drive filled up and caused the Data folders to look as if the rights had been removed.
It was caused by .slg files like this: "C:\Users\Public\Documents\GlobalSettings\SageReplicator\4148 - 131882004005307603.slg"
There were only…
Created a New Company for testing purposes - copied all applicable files into new company per online instructions. Everything in new company seems to look OK, except the GL accounts had a different format (the - and . appear to have been removed). In…
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…
Does anyone have any comprehensive form of databse schema or detailed data dictionary for Sage 300 CRE when trying to access using ODBC? I have been trying to find one for some time that details the table locations of data fields and have found Sage documentation…
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…
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…
Another program is accessing your Sage Timeslips database.
When using a 16 bit program, you may need to reinstall Sage Timeslips and its database into a file path limited to 8 characters per folder with no spaces in the names.
Area: Table Error Code…
While trying to restore a SQL server backup for one of our Sage databases, the process returned a restore error. Upon research i found out that the DB may have been corrupted. What can be done to recover from this?
Priti
We're currently on Sage 100 2014 (Non SQL) and we're currently running into the issues where we are being sent names containing certain ranges of extended ascii characters.
For now, we are going to limit ourselves to the first 127 in the ascii table…
Have an issue with what I believe is a corrupted date value. It resides in purchase order detail required date and PO header PO date.
Running the open order report on "required expire date" for date greater than 12/30 will result in "Vendor Code 9"…