Browse By Tags

  • PL_JournalPDFLog.M4T *** File discrepancy

    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…
  • Duplicate Item Numbers

    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…
  • Simply Accounting 8.5B database repair before upgrade

    I need some contacts for help to repair our Simply Accounting 8.5B database before we proceed to upgrade to the current version of Sage. I spoke to Sage Support and they indicated they have a "Repair for Conversion" service to repair the company file…
  • How do I find out where a data inconsistency is between debits and credits?

    I ran a data integrity report and everything is balanced except my total debits and credits. I have run an "ALL JOURNALS" report going back to our first year of operation in 2011 and every year shows a balance between total debits and credits. Where else…
  • Cannot Start a New Year

    I am running Sage 50 Premium Accounting with Payroll version 2021.1 and trying to roll over to a new year. When I go into Maintenance -> Start new year. The error that comes up is: Sage 50 - Duplicate Entry. You have entered a value that has been assigned…
  • Order was removed from SO Entry, but is "Active" in sales order History?

    Hello, We have an issue where an order is currently marked as an "Active Order" under Sales Order and Quote History, but this file is not accessible inside of Sales Order Entry. We get the message: "The Sales Order number already exists in the History…
  • Abnormally High/Rapidly increasing Fragmentation Levels?

    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…
  • Need some help with possible data inconsistency

    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…
  • Information on tables not listed in "File layouts and program information" ?

    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…
  • Can't start new year

    I spent the day reading forums and trying to find a solution and I don't know what to do even though I think I isolated the source of the problem. The problem : I can't start a new year. When I do so I get this error message : An error occurred…
  • HELP! Timeslips Errors

    FormerMember
    FormerMember
    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…
  • Urgently need assistance with a Business works 2011 data corruption

    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…
  • GLJED CompanyID field with incorrect company ID

    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…
  • Sage 100 BoI corrupt records with extended ascii

    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…
  • Providex ODBC Invalid Date - Corrupt Date?

    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"…
  • Rebuilding Key Files

    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…
  • Key File Rebuild and Optimize removes all records.

    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…
  • Rebuilding Sort Files Automatically

    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…