• Sage 300 + CDATA JDBC Driver for sage 300 + Talend Data integration

    Hello , I'm new with sage 300 and i need to connect my Talend data integration with sage to extract data. To this i installed sage 300 on my machine i created a simple company to do the test , then installed CData JDBS Driver for sage 300 ... …
  • Unable to Print to a Custom Payment Voucher Form

    I have a crystal report which is run via Sage 300 desktop shortcut [Macro] which has stopped pulling data through for some batches. The Crystal Report only shows a blank Custom form for some A/P Payment batch entries and will pull the data for some batch…
  • RESTORE OF DATABASE

    Hi Team, Doing an installation set up. Can I restore a sage 300 ERP backup from premium version environment into a standard version environment. comparing the variance in the version...........
  • Get List of Companies database using MSSQL Query

    Hi, 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…
  • SAGE 300 Modules activation problem

    Hi Team, We have installed SAGE 300 ERP 2019 and when we are trying to activate the modules , using the serial numbers and activation codes provided in the SAGE portal, System is throwing error as invalid serial number for all the modules of SAGE 300…
  • How to change AP control account

    Can someone please help me with changing the AP control account please ? Right now all the invoices are being posted to the Misc Accrued Payables account. I would like to create a separate account called 'Trade Payables - Consolidated' and transfer all…
  • Standard Costing

    Hi, My customer is on Sage 300c 2017. They were using User costing before, changed to avg costing and some lot costing. They now want to use Standard Costing. I have done multiple tests and talked to a data repair company, standard costing does not…
  • Sage 300 v2019 running on Windows Server 2019

    Sage 300 v2019 running on Windows Server 2019. Although the v2019 compatibility guide does not cover this OS and Sage support will not say yes or no if Sage will work. Does anyone have experience using this OS yet?
  • Sage 300 over a WAN

    Is it possible to run SAGE 300 over the corporate WAN (250mbps). If not, why? What is the bandwidth requirement?
  • Sage 2019 and Windows 8

    I was going over the system requirements for Sage 2019 and notice that they mention compatibility with Windows 7 and Windows 10....but no mention of Windows 8. Will Windows 8 still be supported?
  • System Requirements for Sage 300

    We are upgrading to Sage 300 in a small environment aka 3 people. Or reseller is saying we need 32G RAM. The only document I found that might relate to this shows 3 deployment scenarios of Standard, Advanced and Premium. It doesn't elaborate as to what…
  • Audio Not working

    FormerMember
    FormerMember
    I recently upgraded from revision 17.7 to 18.1 and after the upgrade I no longer have audio when using Sage applications. Has anyone else experienced this issue, or does anyone have any ideas of why the sound may have stopped working?
  • 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.
  • Missing with GL account folder and Administrative services functions

    Hi, I installed a fresh copy of SAGE 300 2018 and loaded sample data. It is fine with everything. But after loading customer earlier version data and upgraded, I am missing with Administrative services (except data activation) and GL account folder. I…
  • Upgrading server version 2014 to 2016

    Currently, SAGE is running on Windows server 2014 and IT is planning to upgrade the version 2016. This updates will not require any installation and uninstallation, It is straight forward version update. Does it have any impact with current running SAGE…
  • Upgrade to SAGE 300 2018 from MS Server 2008 R2 + SQL 2012

    I currently have a a SAGE 300 2016 Update 4 (on windows 2008 R2) + SQL 2012 I have a new server built on the side that i wish to run SAGE 300 2018 -on Windows 2016 Server Standard + SQL 2017. I don't see SQL 2017 supported anywhere... is that true…
  • Sage 300 consolidated receipts batches are posting to the period end instead of the document/posting date of the batch.

    All of sudden Sage 300 consolidated receipts batches are posting to the period end instead of the document/posting date of the batch. All of my March receipts are posting to March 31st regardless of the posting date selected in the batch. Has anyone…
  • 2018 Tax Update with Version 14.1

    Hi! We have version 14.1 because we heard 15 was not working well. Now we found out we need at least 15 or 16.1 to use the 2018 Tax update. Is this accurate? Does anyone else have 14.1 and hasn't updated to 16.1 and has uploaded the 2018 tax updates…
  • Why after changing the flag on a AP batch to ready to post, transaction posted from PO keeps updating same batch ?

    We have configured our system to do all costing during posting. and with multiple departments using the PO module we'd like to set a AP batch as ready to post to avoid modification. Now what we have notice that even after setting AP batch as ready…
  • Sage 300 2018 Operating System

    Hello. I've searched everywhere, but cannot find a clear answer to this question. Is Sage 300 2018 supported on Windows Server 2016 x64 Data Center Edition? It isn't specifically listed in the published Compatibility Guide; it only mentions Server 2016…
  • Removing local administrator in the workstation

    Hi, We are using Sage 300 v2017. When the users run the Sage 300 program, they need to “run as administrator”. However, our group IT wants to remove all local administrator account from the workstations & server. And centralize the control at…
  • 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…
  • Trend Antivirus/Firewall and Sage 300 2017

    It seems that Trend antivirus is giving me lot of headache at the moment. cannot see the server . On 2 sites over the weekend very similar issues. Site 1. server 2012 , MSSQL2016, TREND Antivirus, Windows 10 workstations no users can run Sage…
  • 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?
  • upgrade

    Hi there, After upgrading to sage 2016, we are losing the Users and have to enter them manually. Once they are entered the permissions reappear. Is it normal and is there a way to make sure the users upgrade as well? Thanks