Browse By Tags

  • Sage50 Newbie - Quote - Record

    Hi everyone, New & I have an error, "The estimate must have a quantity ordered. Be sure the Contract column contains an amount.", when I click "RECORD" button after writing up my quote for services. The "QUANTITIES" column is highlighted blue and am…
  • Sage BusinessVision 2023 SBE Bug Report - Broken indexes (Actian v15)

    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…
  • missing main.db?

    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.
  • Runtime Error When Attempting to Access Employee's File

    Sage HRMS version 10.7059 (we do not use employee self serve) When trying to open the file of one specific employee, this error message pops up and I have to restart Sage. I can access other employees fine. What is causing the error and how do I get…
  • Error message on bank reconciliation: Record has been modified by another user.

    Hello, I'm hoping someone can help me with this issue. There is a deposit that, believe it or not, goes all the way back to 2016 on our bank reconciliation in Sage 300. I have attached a picture file showing the bank reconciliation and error message…
  • what does pervasive error code 54 mean and what do I need to do?

    what does pervasive error code 54 mean and what do I need to do?
  • Web API Bug in POReceipts with Additional Costs

    While the new ability to add a PO Receipt referencing an existing PO is a long awaited for feature of the Web API, the 2023 release has a bug that makes it impossible for us to use this feature. PO Receipts with additional costs incorrectly assigns…
  • 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…
  • Customer ID issue

    we have an issue with Sage around a "ghost" customer id. Sage is telling us that we have to totally create a new company and just move over beginning balances, but doing this obviously creates an issue with the history. We are hoping to be able to repair…
  • General Journal Posting - duplicating

    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…
  • 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…
  • Record: 0039359 missing from WORSDT.SOA

    We are using Sage 100 Standard ERP 2013 (Version 5.00.4.0) / SAGE 100 ERP Issue detail: when I click on Work Order -> Work Order Transaction Entry (Snapshot 1) -> it asks for the date and once I enter the date and click OK -> I get an Update Interrupted…
  • Error occurred when opening view

    When opening Common Services->Company Profile, the following error is occurring: Damaged data. Company Profile. Data dictionary is inconsistent. Error occurred when opening view CS0001. View 'CS0001' is not a valid View ID. Error occurred when activating…
  • Cannot alter table CSCOM error

    When opening a company, it shows the following error: Cannot alter table CSCOM error = 211. To try to resolve, I installed Sage 300 on a new machine and loaded a dump of the data. The error appears in the new installation also. I also tried replacing…
  • I can not advance to a new calendar year.

    Sage 50 2022.2, I have cleared all past years historical data, restored backup made in early Nov. (before installing 2022 upgrade) will advance to Jan. 1,2022 but backups made after 2022 upgrade will not. Advance Database Check gives an error and the…
  • issues after switching to Sage 50 Cloud

    Hello, Our company added Sage 50 Cloud to our subscription in May 2021 and we have been having a consistent issue and I can't seem to find much information on it. The issue is users will get a message saying: "The company must be closed in order to…
  • error #47 substring reference out of string in Sales Order

    we are attempting to delete a SO. we have successfully done so to other SO but this one item gives us an error #47 Substring reference out of string and we are unable to do anything.
  • Sage 50c US - Unable to View invoices

    Hi, I'm in the IT dept, and our accountants are reporting that they are no longer able to open invoices when they view the invoice of any kind the screen flashes for a second and then closes as if they didn't click it at all, no popup no warning. …
  • Importing Transactions into Project and Job Costing

    Hi, I am getting the below error message when i try and Import transactions into Costs under the PJC transactions. The Error mentions PM0420 which either has to do with Document Number or Line Number, but I am not able to resolve this error - Could…
  • error, "SqlDateTime overflow. Must be between 1/1/1753 12:00:00 AM and 12/31/9999 11:59:59 PM"

    In Database Admin, restoring a Client's backup, I am getting an error, "SqlDateTime overflow. Must be between 1/1/1753 12:00:00 AM and 12/31/9999 11:59:59 PM" What is this? I write reports, and get client databases to work in. This is the first time…
  • Open PO Qty vs On PO qty discrepancy

    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…
  • Integrity Audit Table problem

    Index version does not match Table version. Is this a significant erro and can it be solved simply by deleting the table?
  • Sales Orders are disappearing during the "get EMV" process

    This is happening after our sales associates are done creating the sales order and have already clicked the EMV button, and swiped the card, then when the go back to click the "Get EMV Pmt" button, the sales order is gone. The credit card processes fine…
  • Does MRP Generation look at Purchase order tables?

    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…
  • PO archive and upgrade?

    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…