Welcome to the Sage 300 Support Group on Community Hub! Available 24/7, the Forums are a great place to ask and answer product questions, as well as share tips and tricks with Sage peers, partners, and pros.
Upgrading from 2019 to 2022 and for that purpose deploying new virtual server. Server is running Windows 2019 and SQL is running on a separate machine. I am able to convert data but when trying to run SAGE receiving error in OE and IC. PO seems to be…
Hi all,
We are having an issue while adding a SAGE300 component into a Visual Studio form (.NET project).
The error we received is: Failed to import the ActiveX control. Please ensure it is properly registered.
We have registered the accpacic1500…
Hello,
Could someone please tell me where to find the banking details for a customer - the APVNR table gives the name, REMIT and the address but not banking. I checked the ELVEND and the EFLTLOG files to find the banking details but could not. I have…
Hi,
Could someone please share what fields are necessary to do a payment import into Sage 300. It keeps giving me the error that 'Invoice Number Cannot Be Blank' but the IDINVC field in the Applied_payments tab is not blank.
Could someone share…
We are using AccPacc to work with Sage 300.
When we call View.Insert the error message appeared:
------------------------------------------------------------------------
Timecard Detail.
Database error (operation=REV-POST, error=229)
------…
A data dump was made and restored on Sage 300 ERP. At the point of opening sage the below error message were gotten with the list of modules which are already installed.
sage 300 has detected module update inconsistencies that requires activation. The…
Dear, I am facing a problem in sage 300, I already have two companies in sage 300, but when I open a new company one old one company disconnected from data base, now my old company
doesn't show any thing, but in sql server all data is avail able. kindly…
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 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…
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…
Hi,
We ran the Data Integrity Check and we have the following error message:"E: Database XXDAT uses an application CS that is not installed.
1 Error found in Administrative Services.
Any ideas?
We were really hoping to stick with a 2008 box for the Accpac install. Did we miss our window of using 2008 by a version or two or are we long done with those versions?
We're also looking at the possibility of using server 2016. Is there any chance…
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…
