Browse By Tags

  • opening 2016 data in 2020

    I have a client that purchased a new laptop and installed Sage50 Quantum 2020 on it. When they try to open their data from Sage 50 2016, they get an error that an older version of the Actian Zen database is already running and requires a newer version…
  • 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…
  • Job related PO Receipts getting the error "Damaged data. Receipt. Table PORCPH1 not found."

    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…
  • 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…
  • After 2021 Update, cannot open company

    We updated Sage 50 to the 2021.0.0 version, and since cannot open the company file (on cloud). Message is: "Could not sync the Remote Data Access company. Please try again. If the issues continue, download the company again." I have tried all of these…
  • Importing Assembly Data

    Has anyone successfully imported assemblies? I was attempting to rebuild our company, but when I try to import the assembly data exported, the first row in each assembly fails due to an error in the quantity built column. When reviewing similar questions…
  • 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…
  • Automated backup is failing on Sage 2019 for just one company, and is creating large temp files in the process.

    FormerMember
    FormerMember
    Our company is using Sage 50 Quantum Accounting 2019, and, for whatever reason, our largest company is consistently failing to produce a ptb file through automated backup. All of our other companies can successfully backup, but automated backup for our…
  • 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…
  • Sample ODBC/SQL queries for getting Sales Order information, Customer Information, and inventory information?

    Can anyone offer any sample SQL scripts for getting information, such as Customer Information (given a customer ID), sales order information (given a sales order number or customer ID), and/or inventory information (given an Item ID) out of the database…
  • loading data error

    Hi, We are using Sage 2014 and We have the following error message when we load data ( error=856, native code=476485). any clues? thanks
  • Data Integrity Check

    Hi, We ran the Data Integrity Check and we have the following error message:"E: Database XXDAT uses an application CS that is not installed. 1 Error found in Administrative Services. Any ideas?
  • Day end error: Transaction History. Database error. (Operation=INSERT) (Error=824)..

    We using Sage 300ERP V.6.0 PU2. The error message when day end is show "Transaction History. Database error (Operatin=INSERT) (Error=824). Please advise, what happen and how we can solve this problem.
  • Timeslips could not find the expected record when using transport.xfr

    Timeslips 2012 When using transport.xfr I get the following error message. I tried a DATA VERIFICATION on both machines and have NO errors. I can exchange clients and professionals but NOT tasks or expenses - tried each separately. Any help would…
  • Timeslips 2008 Directory/Paradox Issue

    I'm an admin for a law office and we use Timeslips 2008 for our billing. Only yesterday, when I went to edit a slip, I received the following error: "Directory in use by earlier version of Paradox.(13314) Area: Database Code: 4 Address: Exception…