Browse By Tags

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…

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…

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…

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…

Last night I was doing some maintenance on one of our warehouse (zeroing out product), and noticed a problem I'm not quite sure how to solve for. I found that we have an item in our SQL database (Running Sage 2014 premium) that says we have .014400…

We have noticed that the CompanyID field in the GLJED table does not tie up with the actual company AUDTORG field. The bulk of the record have the correct company ID, however many have either blanks or random company ID's I have checked this at several…

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"…

Once every 1-2 weeks I rebuild all sort files and am wondering if I should also be rebuilding the key files? Is there any risk/downside to rebuilding the key files? Also, when I am running the utility do I want Integrity Check and Optimize File checked…

Our Sage 100 version 4.40 server had a few files fail the integrity test with either read or write errors. I selected OK to rebuild them but now all the records are gone. The log file shows all the records were recovered. Is this normal? I can import…

Once every 1-2 weeks or so I have to get in after hours to rebuild sort files, in our old business system a similar process was scheduled to run each night. Does anyone out there have a script or other method that would allow for scheduling a rebuild…

So I had a some power issues last week on the server, fixed that but it seems GL.BTR is corrupt. (i think) Basically cant post invoices. The error is in GL.BTR Tried this: https://partners.sagenorthamerica.com/irj/go/km/docs/sageKM/Sage%20BusinessVision…