• Sage 300 2024 w/PU1 Sage 300 Cannot Connect to Signon Manager - Resolution

    Brand new install of Sage 300 2024 and PU1 on 2019 Server and 2019 SQL Server - not new workstations. Always have problems with the same 2 out of 6 workstations (all within 1-4yo) when it comes to Sage 300 workstation installs. I'm putting this out here…
  • Running Sage 300 (2019) off cloud paging. Error=100 during Database Loading

    Hello all, I've come across an issue that I can't seem to find a solution for. My PC at home is Windows 11, all drivers and OS is fully updated. Even have a 64bit adobe reader installed as per another post similar to this. I'm a student, using cloudpaging…
  • 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 when trying to open Order Entry

    Hello, I am using Sage 300 2020. The OE module is working fine on the server but when trying to open it on a local computer i receive the error. Could someone help me please. Description: Error occurred when opening view OE0520. Code: 2.786.1…
  • Sage 300 2014/2018 with Microsoft Excel 2010 32 bit

    Is there a work around or fix available for FR Reporter not working or playing up for sage 2014/2018 versions with Excel 32 bit office 2010. Get the error below when executing reports "PrintReport: Error on opening the xla macro. Have received…
  • Sage batch posting freezes

    Sage Accpac Version 6.0 SQL 2008R2 on MS Windows Server Server has 8 companies running. One of the Sage accpac companies has issues in posting batches from GL batch list window. Once you reboot server all postings will happen for 1st 5 minutes and…
  • Server Busy error

    When logging into any sage company get the error This action cannot be completed because the other program is busy. Choose Switch To to activate the busy program and correct the problem. What is the ideal permanent fix to this issue. Have checked…
  • Error HRESULT E_FAIL has been returned from a call to a COM component.

    i have some code PORCP1header.Order = 0 PORCP1headerFields.FieldByName("RCPHSEQ").PutWithoutVerification("0") ' Receipt Sequence Key PORCP1header.Init() PORCP1header.Order = 1 temp = PORCP1detail1.Exists PORCP1detail1.RecordClear() PORCP1detail3…
  • get Field value in macro into a variable Vb.net.

    I want to get value from PORCP1detail1Fields.FieldByName("ITEMDESC"). the condition that i have set if PORCP1header.Read how to get the previous data from that field and set into a variable in vb Example: Dim vItemDesc As String = "" vItemDesc…
  • System.InvalidOperationException: Plug-in host process not ready

    FormerMember
    FormerMember
    I'm getting this sporadic error on some clients. Doesn't happen all the time and after a little while they can login successfully. Any suggestions or insight?
  • Error installing Sage 300 2018 - Not server role to install net framework

    Hi, We are installing Sage 300 2018 in a new server - we will upgrade - with Windows Server 2016 and SQL Server 2017. In some point of installation process it begins to install net framework but we get an error that we need to add a Server role to…
  • Deadlock victim. [Database vendor code: 1205]

    The problem occur when user try to print transaction listing report Anyone knows why is this problem occurs?
  • 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…
  • Invalid database specification

    Hi, We have a client who have a few Windows 10 workstations. After running the Sage 300 workstation setup, the error "Invalid database specification" appears. The client is using Sage 300 v2014 PU3 The SQL Server uses SQL Server 2008 R2 I’ve…
  • SQL Database corruption

    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
  • 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?
  • Code Changers don't work after Payroll 7.2 upgrade

    Sage 300 2014 PU4 (also 2012 with PU4) with Payroll 7.2 none of the code change products work, system says 'newer version of Canadian Payroll was detected. XXXXX Code Change must be upgraded!' Is there an upgrade available?????
  • 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.
  • Update Inventory Worksheet via SDK

    Hi Guys, I am having an issue while updating Inventory Counts in SAGE300. I have created the Macro but it actually does not update the Quantity Counted in I/C Physical Inventory Quantities. Has someone successfully updated /C Physical Inventory…
  • at wit's end........Remote Desktop........“You do not have a license to use this product”.... for POWER USER

    Sage 300 v2012. PU4. Win Server 2008. We connect to Client via SAME SonicWall VPN, then connect to Win 2008 Server via SAME Remote Desktop Connecting from Windows 8 computer, no problem. Connecting from Windows 7 computer, Error pops up when launch…