Sage 300

Upgrading to PU 6 to put the 2020 sm license key in we attempted to put in the new license, all sage-authentication accounts with admin rights lost their module access. Normal windows authenticated users seemed okay, and the default Admin account seemed…

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

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…

Is there a document available which clearly states bare minimum requirements of a user account on a domain environment or even on the machine (Power users, Standard user, Administrator, etc) in order to have sage and its 3rd party products working without…

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…

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…

Hi, I have install client SAGE 300 ERP 2014 with the following spec. OS : Windows 10 Pro, 64bit, SAGE 300 ERP Advanced Edition (Services Pack 3) When installation process, i get this error message : i just click OK to skip this error. A fter…

Hi I'm using windows server 2016 trying to install Web Screen for sage 300 2018 but it gives error almost at the end to the installation InstallScript Setup Launcher Unicode has stopped working. I have tried to cleanup the pc by emptying Temp , re…

I have a challenge...can someone familiar with the Sage 300 database tables give me some advice? I would like to query the database to find out if a certain document date correponds with a fiscal period that is currently locked for Accounts Payable…

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?

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…

When installing Sage 300 version 2018 in my Windows 10, I encounter the error details: C:\Sage300\PM65A\PJCDatawizard.dll unspecifed error to continue, click OK; otherwise, click cancel. Then I go to run the REGACC.exe in the Sage300 folder…

Hi, We are installing Sage 300 2018 in a new server - we will upgrade - with Windows Server 2016 and SQL Server 2017. In some point of installation process it begins to install net framework but we get an error that we need to add a Server role to…

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…

Sage 300 2017, MSSQL Client daily dump data, as a backup. last week, they dumped data, for strange reason, dumped data only has data up to end of 2016. No 2017 info. any ideas? thanks!

One of my clients is looking at using SQL replication for a satellite office. What they want to do is have the satellite office work against the replicated db and then sync it to the live database. I have heard of using replication as a means to offload…

Hi All, I have performed an OE import successfully in most of the cases. However, I have encountered the captioned error for some items at zero stock level at the moment which could be imported as OE successfully for one OE, but not the others at different…

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

Hello, I need to know the values I should use for "CATEGORY" in time card import sheets,,,,can someone help pleeeease? BR

Hi All, I am new for ACCPAC .Net APIs, I want to import customer data into Sage 300 using APIs, can anyone help or give me some hint for this? Or share some sample code and data dictionary, please? Thanks for your help

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

We have noticed that the CompanyID field in the GLJED table does not tie up with the actual company AUDTORG field. The bulk of the record have the correct company ID, however many have either blanks or random company ID's I have checked this at several…

Hi , im installing sage 300 2016 in workstation pc i have this error " Feature transfer Error Feature System Manager Component: Programs File Error : Access is Denied " Can i ask how to successfully install it ? It has a previous installation of sage…

Hi, We have a client who have a few Windows 10 workstations. After running the Sage 300 workstation setup, the error "Invalid database specification" appears. The client is using Sage 300 v2014 PU3 The SQL Server uses SQL Server 2008 R2 I’ve…