Browse By Tags

  • 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…
  • Where to find Journal Entry Balances

    Hello Sage Community, I am currently working on an integration project to post transactions into my Sage 300 ERP database via an API. While posting transactions directly from the Sage 300 ERP interface to the GL as a journal entry, everything works correctly…
  • Where to Find General Ledger Account Balances in Sage 300 ERP?

    Hi Sage City community, I am currently working with Sage 300 ERP 2023 and trying to access general ledger account balances programmatically. I need to retrieve this data for a custom integration that I am doing. Could anyone guide me on which specific…
  • Sage 300 - Database is locked

    Hi 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 ? THANKS
  • 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…
  • How to reduce Sage300's database

    I would like to know if there is a way or a tool that can be use to reduce Sage300 database. I have a company database of 90GB size with data since 2000.
  • 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.
  • 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?
  • 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?
  • 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…
  • 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…
  • Database over 200GB

    Hi, Does any one maintain or have a Sage 300 ERP running under MS Sql for size over 200GB? Any issue? And have you ever done dbdump , dbload ? How long normally it takes for dbdump and dbload? Thanks
  • Missed Connection: Troubleshooting more database errors

    In a previous blog, we took a look at database errors when you cannot connect to database in Sage 300 ERP. This week, we continue to look at troubleshooting more database errors particularly around issues involving Open Database Connectivity aka ODBC…
  • Connection terminated: Troubleshooting database errors

    One of the common issues that people may have encountered while using Sage 300 ERP are database errors. The majority of these issues is being unable to connect to the database. In this week’s blog post, we will highlight some of the common database…