x Want to participate? Join the group to interact

  • Exporting GL transactions gives error "External table is not in expected format"

    We have Sage 300 2020 running on a Windows RDS server with multiple users accessing the application via RemoteApp programs. Everything has been running fine for a couple of years but randomly last month our users cannot export files any more. A user…

  • Sage 300 crashes on company when sql database was restored from production to test

    We restored a backup of one of our companies to test and now when we enter sage login info it just crashes with no error. Other companies work so it has to be the database but it is the same as in production. I change the database setup to go straight…

  • Missing Orders in Quantity on S/O drill down in Location Details

    Hi, We are experiencing an odd situation. When in location details and drilling down on the quantity on S/O we are missing orders. It shows the correct quantity but you are unable to see the list of orders. -Customers allow backorders, are not on…

  • cannot create new System database on Sage 300 v 2023

    Hi all, On my Sage 300 v2023 > Database Setup, I have 2 existing System databases for testing, which is PCISYS and SAMSYS below. I wanted to create another 1 but get this error instead. I have run RVSpy & DBSpy but no error visible. Anyone know…

  • Failed to import the ActiveX control. Please ensure it is properly registered.

    Hi all, We are having an issue while adding a SAGE300 component into a Visual Studio form (.NET project). The error we received is: Failed to import the ActiveX control. Please ensure it is properly registered. We have registered the accpacic1500…

  • Finding the best date to use for when an record was last modified

    I have a sync app running and it's exporting out from Sage: Orders, Shipments, Customers, Inventory, and Credit Notes. I want to only grab the records that have changed since the last time I ran the sync. For some of these it seems I can grab the DATELASTMN…

  • Activating Payroll Modules - Historical Data for 3 companies in Sage 300 going back 12 years to current

    As a system administrator, but not familiar with the app Sage 300 app. I wish to activate the Payroll Module for three “Historical Data” companies in Sage 300. Need this in order to access payroll information from 2009-Current Just wish to know how…

  • APPS or module for sage 300 to import price list from my vendor in bulk

    Hi I'm looking for an apps or module to go with sage 300 that could make my life easier when I need to update bulk pricing from my vendor thanks

  • I'm getting !! at the GL Balance

    My debits and credits equal but the GL total is out of balance and showing !!. Will File Doctor solve this?

  • Unable to load dumped files from an older version

    I installed Sage 300-2019. I could not load my dumped files from sage 300- 2017. I received the following error: The company you are trying to open uses a later version of Sage 300 than its related system database uses. You must restore your system data…

  • Upgrade Sage 300 2016 to 2019 - Error after Activating Sales Analysis

    I have just upgraded my client who has 3 databases on the server and I am having a problem with 1 of them. After activating Sales Analysis and OpsInquiry, I receive an error: Load of System Manager roto events. Load of System Manager roto events…

  • SAGE 300 ERP DATA LOST DUMP FILE

    Dear, 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, kindly advise me ANY BODY HERE TO HELP OUT MY…

  • How to delete company?

    What is the correct method of permanently removing a company from Sage 300? I found the "Database Setup" utility, where it appears I could delete the two databases (data and system) associated with the company. Is that the "right" way? If yes, does…

  • development environment set up for Sage300

    Hello, we are trying to set up a development environment for Sage300. The version of Sage300 for production use is 2020. On our development server, we are using Sage300 2019. We dumped the company database from our Sage300 2020 and restored it to our…

  • Use SQL to identify the active fiscal period

    Looking for someone who knows their SQL tables here. How can I use SQL to identify the active fiscal period? I see the CSFSC table but what is the best way to determine which fiscal period start date to use? Looking at BGNDATE1, BGNDATE2, BGNDATE3,…

  • Does anyone have a template for importing PM miscellaneous charges?

    I'm looking for a template, so that I don't have to start from scratch, that will import PM miscellaneous charges. I have the format information and I've asked the help desk if there was a template available, like there is for clearing checks, but there…

  • Sage 300 journal entry import

    Hi I have not seen any real postings on journal entry importing (sounds basic) except the original knowledge base how to videos. I think something has recently changed, as I was able to have .xlsm files (yes, I had customized my templates and included…

  • GL entries posting

    Hi, We are on Sage 2014 Service Pack 1 and we would like to know if there is a way to find out who made a post in GL entries and possibly the date and the time. Any clue?

  • A/R Import Template Sage 300

    I am looking for a template to import Accounts Receivable credit notes. It would be helpful if I also know what can be populated automatically by Sage 300 and which fields are essential to the import file. Thanks

*Community Hub is the new name for Sage City