x Want to participate? Join the group to interact

  • Accpac Database 5.5 upgrade to 2014

    Hi All, Can anyone please tell me how can I read my archive database which is in 5.5 in our Accpac 2014? It says I need to upgrade the database to 5.6 so how can I do it? Best, Tom Menace

  • Is Sage 300 ERP 21014 compatible with SQL Server 2016?

    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,

  • Sage 2012 (v6.2) with SQL Client Native 11?

    Hi, We are installing a Sage client in a new machine as user change its PC but when trying to set up ODBCs we dont found Native 10 that is installed in old machines. Just Native 11. Any problem? Not at all? Thank you

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

  • DB Dump question, strange

    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!

  • SQL Replication

    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…

  • OE import error "Negative Inventory Levels"

    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…

  • The values of "Category" in timecard import sheets

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

  • Import data into Sage 300 using ACCPAC .Net APIs.

    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

  • GLJED CompanyID field with incorrect company ID

    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…

  • Qty in Bin Location not matching IC Qty - How do I get them to Match?

    We running SAGE 300 ERP and we have a problem with Qty in Bin Location not matching IC Qty. How do I get SAGE to automatically sync the Bin and IC Qty? Doing each transaction manually takes way to long. Thanks

  • 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?

  • number change

    When I go to Item number change and processing I have an error message: Cannot open database "ccs.net.ccscom" requested by the login.The login failed. Any idea

  • ODBC connection failed...

    Hello All, Hope you can help with my odd ODBC connection, I have 40 companies that I pull data using pass-thru queries. ODBC connection string is set up for each of the companies. The retrieval process is stacked inside an Access Button object, when…

  • Import Inventory Control Preferred Vendor flag is not working, how do you mass update preferred vendor in the vendor details?

    I am struggling with importing the preferred vendor field in IC Vendor Details, even when I export and force the field to Yes (Check box) on re-import it still does not update the required field. When I check the ICITMV table that field does not even…

  • Day end error: Transaction History. Database error. (Operation=INSERT) (Error=824)..

    We using Sage 300ERP V.6.0 PU2. The error message when day end is show "Transaction History. Database error (Operatin=INSERT) (Error=824). Please advise, what happen and how we can solve this problem.

  • Do A/R Invoices have or allow for Kit (Kitting) Items?

    Would like a conclusive answer if Accounts Receivable (A/R Transactions) allow for the use of Kit items with individual components. I know they are available in Order Entry Transactions. Thank you for any/all help!

  • Application Object Model (AOM) for AH61C Sage Accpac HRMS Payorll Link for Sage Accpac 6.1C

    Is there an AOM for the AH61C module? I have not been able to find anything in the KB or the online documentation after installing.

  • AUDTTIME field

    Greetings! Is the AUDTTIME field in say, APIBH, a datetime datatype field? I get a "Arithmetic overflow error converting expression to data type datetime" when trying to convert to local time.

  • Unable to Connect to Database error 98

    Have been using Sage ERP Accpac 200 v 6.0 with Pervasive workgroup v10.30.017 successfully for several months. Today, there was an automatic update and reboot on the "server" while the other workstation was creating bank entries during a bank reconciliation…

*Community Hub is the new name for Sage City