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.
Hello all,
I've come across an issue that I can't seem to find a solution for. My PC at home is Windows 11, all drivers and OS is fully updated. Even have a 64bit adobe reader installed as per another post similar to this.
I'm a student, using cloudpaging…
Hello Sage Community, I am currently working on an integration project to post transactions into my Sage 300 ERP database via an API. While posting transactions directly from the Sage 300 ERP interface to the GL as a journal entry, everything works correctly…
Hi Sage City community,
I am currently working with Sage 300 ERP 2023 and trying to access general ledger account balances programmatically. I need to retrieve this data for a custom integration that I am doing.
Could anyone guide me on which specific…
I’m trying to determine what table & field name lies behind the field in the yellow box below? Looks like I’ve got to drive some conditional logic with it for a report, but I can’t find it in the database.
You get to it by clicking the Item/Tax button…
Hi I installed Sage 300 ERP software on a client machine. The installation is complete and successful. But when I run the sage software, this error message "Database is locked". The client is a windows 10 64 bit. I need your help ? THANKS
Hi all.
I am looking for the Column that store the deposit date of AR Receipt Batch. But ARBTA does not have Deposit Date column. Then I go to ARPJH and update the column DATEDEPST (Deposit Date), but the new value does not reflect on the AR Receipt…
Hi, i am experiencing error 40960 when i tried to login into sage 300 database on 3 separate workstations while other two workstations connected successfully.
I have checked the DSN, redirected it and ensure everything is right BUT the issue still persist…
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 all,
During a database load, I have encounter this error. No clear message so I don't know what is the cause and how to solve it. Below is the screenshot.
Can anyone help me please? Thank you.
Hi.
We need help getting our database setup. I did some reading on it and even though I understand technical things pretty well I did not quite get it. As I mentioned in the title this is for a class we are taking in Computerized Accounting and we all…
Client uses Sage 300 2014 & SQL 2012, on separate servers. They have provided 2 new 2019 servers for us to begin the upgrade -- but first, I want to make sure that everything works as it does now, before installing version 2022. The DBA restored the SQL…
Hi all,
I am doing customization on Bank Entry Screen using ISV module called Extender. But that is not the problem.
I notice that, on the Bank entry grid, every time I add new line, the LINE value will auto decrement -1,-2,-3. if I remove -2, and…
Hi all,
I want to make the email field in AR Customer unique, means only 1 email for 1 customer only.
How can I do that? I assume I just set the email to be unique in database level, is there any implication to expect? Thank you
Good morning,
I am using the below SQL statement to get a sales per item number from my Sales History tables ( OESHHD and OESHDT ) as well as item cost in my Sales Posting Journal tables ( OEAUDH and OEAUDD ). However, when I compare my sql output my…
Hello,
I have a client who keeps getting connection errors multiple times a day on multiple workstations.
They only get these on workstations (not on the terminal server). The terminal server, app server and SQL server are all VMs on a host. They…
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 want to create a Business Intelligence Report by using Report Manager & Connector.
In this report, I want to get rows from table APPYM of all Companies database.
But first, I need to know which database is actually a company database for Sage…
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.
I have a Sage Accpac ERP 5.3 using Pervasive 8 but we want to migrate to Sage 300 ERP 2018 using SQL Server 2017 someone knows the best way and best pratices to do it please
Our Sage users constantly keep getting there errors throughout the day spontaneously
* Database error (operation=GET . error=****) [Microsoft] [SQL Server Native Client 11.0] Communication Link Fail. Please refer this error to your database administrator…
Random error received by numerous workstation users at all different times of the day. Some when they first go to open sage, some while they are in the middle of working in Sage. This has been happening following the most recent Sage 300 2016 Product…
Don't let database errors slow down your productivity. Here is how to deal with some of the database issues that Sage 300 Customer Support often gets contacted about.
Error: "Cannot access database Error=49153" with a newly installed server
The "Cannot…
Does anyone know the easiest way to copy shortcuts created in company A to be identical in Company B in Sage 300? Assume the shortcuts in company A are set as all users.
I want to get value from PORCP1detail1Fields.FieldByName("ITEMDESC").
the condition that i have set if PORCP1header.Read
how to get the previous data from that field and set into a variable in vb
Example:
Dim vItemDesc As String = ""
vItemDesc…