• 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 ?

  • Deposit Date from AR Batch is coming from which table?

    Hi all.

    I am looking for the Column that store the deposit date of AR Receipt Batch. But ARBTA does not have Deposit Date column. Then I go to ARPJH and update the column DATEDEPST (Deposit Date), but the new value does not reflect on the AR Receipt Batch…

  • 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…

  • Banking Details Table


    Could someone please tell me where to find the banking details for a customer - the APVNR table gives the name, REMIT and the address but not banking. I checked the ELVEND and the EFLTLOG files to find the banking details but could not. I have…

  • Encounter error during Database load

    Hi all,

    During a database load, I have encounter this error. No clear message so I don't know what is the cause and how to solve it. Below is the screenshot.

    Can anyone help me please? Thank you.

  • Setting up Database for students at our university (trying to help our professor)


    We need help getting our database setup.  I did some reading on it and even though I understand technical things pretty well I did not quite get it.  As I mentioned in the title this is for a class we are taking in Computerized Accounting and we all…

  • Migrating to new servers

    Client uses Sage 300 2014 & SQL 2012, on separate servers.  They have provided 2 new 2019 servers for us to begin the upgrade -- but first, I want to make sure that everything works as it does now, before installing version 2022.  The DBA restored the…

  • BKENTD LINE field keep updating every update

    Hi all,

    I am doing customization on Bank Entry Screen using ISV module called Extender. But that is not the problem. 

    I notice that, on the Bank entry grid, every time I add new line, the LINE value will auto decrement -1,-2,-3. if I remove -2, and add…

  • Connection errors multiple times a day


    I have a client who keeps getting connection errors multiple times a day on multiple workstations.

    They only get these on workstations (not on the terminal server). The terminal server, app server and SQL server are all VMs on a host. They are…

  • old company data lost during creating a new company

    I am facing a problem in sage 300, I already have two companies in sage 300, but when I open a new company one old one company disconnected from data base, now my old company

    doesn't show any thing, but  in sql server all data is avail able.…

  • Get List of Companies database using MSSQL Query


    I want to create a Business Intelligence Report by using Report Manager & Connector.

    In this report, I want to get rows from table APPYM of all Companies database. 

    But first, I need to know which database is actually a company database for Sage…

  • Migration From Sage Accpac ERP 5.3 with Pervasive 8 to Sage 300 ERP 2018 with SQL Server 2017

    I have a Sage Accpac ERP 5.3 using Pervasive 8 but we want to migrate to Sage 300 ERP 2018 using SQL Server 2017 someone knows the best way and best pratices to do it please

  • Sage 300 Shortcuts

    Does anyone know the easiest way to copy shortcuts created in company A to be identical in Company B in Sage 300? Assume the shortcuts in company A are set as all users. 

  • Get user using windows authentication and domain

    i want login using macro. but using windows authentication and specific domain

    can anyone can help me?

  • 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


    Dim vItemDesc As String = ""…

  • Sage 300 - sql query for recalculating AP Balances - reconciling to GL

    Hi, I am trying to determine why my GL and AP control accounts dont balance.

    Yes, I know I can isolate GL only transactions from my control account, but I would like to build a more robust answer.

    To this end, I would like to build a query in sql views…

  • Current fiscal period for a company in database?

    Can someone please tell me what table/column will give me the current fiscal period for a company?

  • User Creation Date and License Type Fields in Sage 300 2014 Database


    I was hoping someone might be able to assist me.  I am trying to create a report using the Sage 300 2014 database.  I need to see the date that a user was created in the system and also need to know what type of license the user is assigned to.  For…

  • SAGE erp 300 2014 Inter city branches connectivity possible?


    we bought SAGE ERP 300 2014 in may 2015 and from then we are unable to use and implement the product in our Courtney.after year long fight with our sage business partner we have successfully running the product on our head office and i'm not that much…

  • 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?


  • loading data error


    We are using Sage 2014 and We have the following error message when we load data  ( error=856, native code=476485).

    any clues?


  • Data Integrity Check


    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?

  • installation 2016 Server 2008

    We were really hoping to stick with a 2008 box for the Accpac install. Did we miss our window of using 2008 by a version or two or are we long done with those versions?

    We're also looking at the possibility of using server 2016. Is there any chance for…

  • Restoring MS SQL backup to another database

    MS SQL server 2012, Sage 300 2014 PU 3

    I am trying to restore a test database using the most recent backup of its associated production database - in SQL Server Management Studio. I am restoring to another name and that task completes without errors.

    I have…

  • Sage 300 2016 with SQL Server 2005 or 2008


    Sage 300 2016 supports SQL Server 2005 or 2008? Anyone running this last version in that environment?

    Thank you