Sage 300

We have a couple of optional fields set up in I/C on about 50K items that have not been used in years. Can't delete then because "they are in use" I want to clean this up and then set up one new valid optional field. Are there any ramifications…

i want to know the user passwords. in which table in the database can i get the information ..and we are using sage 300 ERP

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...........

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.

Hi, I would like to ask question regarding customized table in company database. Lets say we have DB called SAMLTD. For customer requirement, I need to add another table ' CUSTOM ' in SAMLTD to store information. Then I have to sync this information…

I am receiving fallowing error in all modules after test conversion to 2019. Running Windows Server 2019 and SQL Server 2017. I setup 32bit ODBC connection as suggested in upgrade guide. Data conversion completed without any errors but I am not able to…

Hello, I am trying to export the 2016/2017/2018 year end income statement accounts and amounts to excel. I cannot find which column definition displays this information. Every column definition I have tried does not tie out with the actual income statement…

Just wondering if anyone has seen the following error: Error occurred when opening view AS0035 View 'AS0035' is not a valid View ID. Error occurred when activating Sage Accpac Data Source. while trying to do a Data Activation after setting up a new…

Sage 2019 on Windows 10 32 or 64 Bit - having issues running accpac (not as administartor) - not even getting a Sage accpac login screen the splashscreen comes up and then disappears. Does not work in Win7 Comaptibility mode unless you are troubleshooting…

I am trying to run some simple queries and use it for audit. In this case I am running an AP register, but for some reason I am getting a syntax error in MS Query that it doesn't like the columns Check or Limit......any work arounds? Thanks,

Hello Everyone, I am currently learning Sage 300 2019 and have download the latest student limited edition of the software along with the SQL Server Management Studio 2017. I did manage to install all the software and setup the database as seen on the…

We have many employees with pre-tax 3rd-party short-term disability deductions. When those employees receive payments for short-term disability, some employer-related taxes must be calculated. I have a custom Excel workbook to carry out these calculations…

ERROR [08001] [Simba][SimbaEngine ODBC Driver][DRM File Library]Invalid account name.ERROR [IM006] [Microsoft][ODBC Driver Manager] Driver's SQLSetConnectAttr failedERROR [01000] [Microsoft][ODBC Driver Manager] The driver doesn't support the version…

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

Hi, Upgraded a client fro Sage 2017 to Sage 2019. Some machines return the error=40960 while others work fine. recreated the DNS on error machines but the issue continues. What could be the issue?

I do the work for two separate customers (slightly different ownership). One company -- Company A -- frequently invoices the second company for various items -- and the A/R invoices have many, many lines. The second company -- Company B -- wishes to post…

Hi Support, we have a client facing network issues so Sage became very slow. Initial workstation setup had both program files and data on the server. i tried to install Programs on local machine and data on the server however it does not install…

Hello, We upgraded our office product from 32 to 64 bit. Office 2010. Now in Sage when we Import/Export in any module, the option for Excel 2007 disappeared. Only Excel 2000 is available. Any ideas? Do I need to uninstall-reinstall Sage? Sage…

Hi Forum, I have created a macro that automatically dumps my company databases but my challenge is HOW to attach this to a scheduler like "Task Scheduler" and make it run successfully. When I tried creating the task and thought I had done everything…

I have imported items and quantities into a Transfer from an excel spreadsheet. The Transfer then SAVES correctly within SAGE300 however, it errors out at the end of the posting process. Error reads "Transit Transfer/Receipt Detail record already exists…

When upgrading to 6.5 received error when trying to activate Ops Inquiry 6.5: Microsoft SQL Server Native Client 11.0 . SQL Server incorrect syntax near “2018”. Anybody with similar problem?

After upgrading client to 2018 users keep complaining of slow system. the following have already been tried with limited effect 1. only one path statement using DNS name 2. Increased cpu to 8 core xion 3.1 processors (both app and DB server) …

We have «Sage 300 ERP AccPac v2014». We export IBM Notes data in XML to TransAcc module. I must modify le doctype for actual data, they are considered as «Prepayment», and I must change doctype for «Receipt». Here the sample of data: [code]<?xml version…

An existing client Is running Sage 300 ERP 21014 and would like to migrate their SQL from 2008R2 to 2016. Is Sage 300 ERP 2014 compatible with SQL Server 2016? Thanks,

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…