• Sage 300 - Database is locked

    I installed Sage 300 ERP software on a client machine. The installation is complete and successful. But when I run the sage software, this error message "Database is locked". The client is a windows 10 64 bit. I need your help ?

  • Multiple Outgoing Email Accounts


    We are getting more inquiries about setting up multiple outgoing email accounts per document type.


    1. Email order confirmations from [email protected] 
    2. Email invoices and statements from [email protected]

    Just wondering if anyone else is…

  • Tables and Fields for Manufacturing

    I cannot find the Tables names and field description for the Manufacturing module in Sage300.  Anyone knows where to get it

    Something similar to this


  • Adding a large amount of new inventory

    We are adding a large number of new products to our Inventory Master list which requires new part numbers, adding each part to the Pricing list, entering the quantities for each part and its location.  What is the most efficient method to add this information…

  • Performance on Windows Server 2019 vs Windows Server 2016

    Ever since 2019 version of Sage 300 ERP I have to run application servers on Windows 2016 because Sage is running much slower on Windows 2019, plus we experiencing frequent application hang in 2019. Did anybody else noticed same thing? For example it…

  • AATRIX errors: AatrisForms.exe - Entry Point Not Found after tax update and product updates

    I am getting the following error when trying to run any government report:

    The procedure entry point [email protected]@@[email protected]@@[email protected]@[email protected]  could not be located in the dynamic link library d:\Sage Accpac\Taxfiling\aatrixforms…

  • After upgrade from 2021 to 2023 I got Error HRESULT E_FAIL has been returned from a call to a COM component.

    After upgrading sage from 2021 to 2023 I got error Error HRESULT E_FAIL has been returned from a call to a COM component on accessing web screen.

    What would be the reason of this and solution ?

  • cannot access database (error=40960) sage 300 2020

    Hi, i am experiencing error 40960 when i tried to login into sage 300 database on 3 separate workstations while other two workstations connected successfully.

    I have checked the DSN, redirected it and ensure everything is right BUT the issue still persist…

  • Does sage Sage 300API allows concurrent post requests?

    Am trying to send post request to sage API concurrently where by many requests are sent at once.

    I got an error  'Record Conflict {en-us I/C Options. Record has been modified by another program'

    and debug .Net debug pop up

    Everything work fine…

  • Querying SQL server Invoices vs Sales History discrepancy

    I am trying to validate some data for our team and am stuck trying understand the data layout. My boss is using stonefield reports to generate a monthly sales report and he has 2 versions generating different #s. There seems to be confusion on what date…

  • German Accounting - DATEV

    Hello All~

    I was wondering if anyone is exporting out of DATEV and importing into SAGE 300. We use SAGE 300 is our ERP system and are merging with a German company who uses DATEV and will remain using DATEV for a myriad of reasons. I would like to export…

  • Sage 300 Web screens - You do not have a license to use this product. Ask your system administrator for help.


    I have a client who is running Sage 2018 Pu 2 windows server 2019

    I have installed the web screens, and run the portal.

    As soon as I access the web screens I get this.  I can confirm the web licence is activated.

    I am wondering if the fact that sharedata…

  • ERROR CODE: -2147417848

    Hi All, 

    I did an AP vendor number change. 

    I now receive this error 2147417848

    Automation error

    The object invoked has disconnected from its clients.

    How do I fix this as we no longer can access this vendor?


    I did a AP vendor number change

  • Database error (operation=REV-POST, error=229)

    We are using AccPacc to work with Sage 300.

    When we call View.Insert the error message appeared:


    Timecard Detail.

    Database error (operation=REV-POST, error=229)


  • Sage 300- Failure to activate Sage 300 data sources- Macbook

    Hi everyone,

    When I click on Options icon in G/L Setup, this error occurs.  “Closing the UI due to failure to activate Sage 300 data sources”. How could I resolve it ?

    Thank you in advance. 

  • Auto Log out

    Is there a 3rd party tool or a functionality within sage that auto logs out user after 15 to 20mins of non activity. 

    We have sage setup where users do remote desktop and use it and we need Lan Pak free as the PO requisitioners sometimes dont log out…

  • system error cannot verify user information

    When i log into sage an error message appears, can anyone help?

  • Error HRESULT E_FAIL has been returned from a call to a COM component.

    Good day,

    I am trying to export data from my local sql DB in sage.

    I am new to sage integration, so i have narrow knowledge on this subject matter.

    When i inserting InsertInvoiceDetailSoftCols() i get an exception "Error HRESULT E_FAIL has been returned…

  • Sage 300 Data Activation

    A data dump was made and restored on Sage 300 ERP. At the point of opening sage the below error message were gotten with the list of modules which are already installed.

    sage 300 has detected module update inconsistencies that requires activation. The…

  • Bank Import File

    This is the file I am using to Import bank statements to reconcile our postings on Sage. The entry does not reconcile, I have tried everything please help and let me know what I am missing on this Excel sheet to complete the reconcilition.

    This file imports…

  • How Company Color Code in Hex

    Hi I'm trying to get company color but I haven't the same color with Sage, Someone can help me please

    Dim Company As String
    Company = AccpacSession.CompanyID
    Dim System As String
    System = AccpacSession.Organizations(AccpacSession.CompanyID).Syst…

  • Printing error

    Using Sage 300 2020 with a shipping Macro that worked last week and now when printing packing slips we get the error....

    Automation error The object involved has disconnected from its client. 

    This only seems to happen for specific user. When logged in…

  • Cannot Connect to Sage Signon Manager


    I am trying install  Sage 300 on a  Windows Server 2016 Standard.  But getting this error  "Cannot Connect to Sage Signon Manager". I have to resolve including re-installing, but no luck.

    Any ideas to resolve.

  • Dbase option removed from Import/Export Sage 2020

    I have been using Sage 2017 for Payroll for some time and have used Dbase format to import/Export since days of Accpac Dos. Upgrading to 2020 SM finds that the option no longer exists. I am having issues exporting using CSV (Through Visual Foxpro) and…

  • Migration

    We are implementing Sage 300 ERP on premises.  Due to current situation, implementation taking longer than planned.  The simple question is, how can we migrate current FY data back to January from our legacy Peachtree Quantum system to sage 300?