• 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…
  • 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"…
  • Cash Receipts/AR_OpenInvoice Issue

    We are on Sage 100 Advanced ERP 2014 (v.5.10.1.0) and are running in to a semi-common issue in Cash Receipts Entry. I am not sure exactly how this happens but probably once a month we will attempt to receive payment for an invoice, but it will appear…
  • 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…