Sage 300

We have always used the data dump/load function to reindex most of clients, as they are fairly small databases and only have under 20 users. However, we now have a couple of clients that their databases are reaching past 100GB and database dump/loads…

Hi, Anyone using Sage 300 2018 with SQL Server 2017? It is not in the Compatibility Guide so.....a customer has this environment and we did a testing upgrade without any issue but any suggestion? Thank you

Hi, A customer running Sage 300 2018 in an 2012 platform is asking me if it is certified to run with SQL Server 2012 SP4....any idea? Thanks

I'm doing some testing of web screens (Sage 300C version 2018) and I get this error when I view the batch listing screen and click on the arrow to scroll to 2nd page of rows. Googling points me to forums that say that "OFFSET" was added to SQL in version…

i have some code PORCP1header.Order = 0 PORCP1headerFields.FieldByName("RCPHSEQ").PutWithoutVerification("0") ' Receipt Sequence Key PORCP1header.Init() PORCP1header.Order = 1 temp = PORCP1detail1.Exists PORCP1detail1.RecordClear() PORCP1detail3…

Hi, in Sage 300 ERP, I'd like to store info such inventory item descriptions, and customers name with Japanese and Chinese characters This is consider the dual bytes language, if I'm not mistaken. I believe there is some configuration I need to do…

The problem occur when user try to print transaction listing report Anyone knows why is this problem occurs?

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 need to create a crystal report for GL analysis and we need to use an AUDTTIME field. I use special formula - pwFormatTime ({GLBCTL.AUDTTIME}) - from capw functions to convert that number filed to time but I get a time that doesnt match with actual…

Hi, I have a client that needs a new server but does not want to upgrade until version 2018 has been out so my question is: Will Sage 300 Version 2012 run on Server 2012 R2 and MS-SQL 2016 without any issues? Thank you!!!

I have a client where the POPORAL table is currently at 37,219,690 KB and the POPOALO is at 75,192,660 KB, what is the best way to clear these tables out?

Hi, Anyone running Sage 300 2017 in SQL Server 2008? Compatibility guide just shows that supports SQL Server 2012, 2014 or 2016 but want to know if is an option for a customer that acquired new servers beginning last year and want to use if possible…

Hello, I have the following questions when creating a databases in Sage 300: SYSTEM DATABASE: Data source / server: which option needs to be used? In the database field, is it required to repeat the information in the description field? What…

Does Database setup support "Windows Authentication"?

We have a new installed sage 300 2017 with MSSQL server. I'm confused on how many MSSQL user CAL licenses we should buy. We have 5 staffs using the sage 300 (i.e. 5 Sage 300 logon accounts). But it seems that only one username needed in MSSQL server for…

I’m exploring the Acc-Pac DB tables and I noticed in the PM… (or Project and Job Costing) table the CONTRACT value is always stored without a decimal. e.g. 10042, 51891, 31311 . Within the AR… (or Account Receivable) tables the CONTRACT value is stored…

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 want to reduce a customer’s database size before upgrading. Their OE posting Journal details table is 15 Gb. They have been running since 2009 and have over 3,000 day ends. They appear to have never printed posting journals. Printing them to preview…

I have installed sql sever 2012 but cannot find or download the appropriate 2012 management studio express version?? This for my inhouse demo machine

I know it is certified for Sql Server 2012 and 2014. Will it also work with Sql Server 2016? My more forward-looking clients are asking.

Is Pervasive SQL 12 compatible with Sage 300, 2014? If yes, Is Pervasive SQL 12 in Centos 7 compatible with Sage 300, 2014? Thanks for your feedback.

Reading the official compatabilty guide it says that “Microsoft SQL Server 2012 or 2014 on Windows Server 2012 R2 are supported for use as the database server for Sage 300 2016”. Many of our clients run SQL 2008 R2 and can do for at least another…

just upgraded to Internet Explorer 11 now I can't open my contacts in ACT. Error message says " Microsoft SQL Server is not running". Clicked on ACT help link on how to Restart SQL Server instance, but nothing happens. I'm not super technical…

Windows Updates indicate there is a MS SQL Server 2012 service pack 3 available to be installed and we are on MS SQL 2012 service pack 2 now. Does any one know of any harm of installing this service pack 3? Has anyone already applied this update?

Hi, We are using Sage 2014 and We have the following error message when we load data ( error=856, native code=476485). any clues? thanks