Sage 300

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

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…

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

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

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

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

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 login using macro. but using windows authentication and specific domain

can anyone can help me?

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 = ""…

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

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

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

Hi

we bought SAGE ERP 300 2014 in may 2015 and from then we are unable to use and implement the product in our Courtney.after year long fight with our sage business partner we have successfully running the product on our head office and i'm not that much…

While trying to restore a SQL server backup for one of our Sage databases, the process returned a restore error. Upon research i found out that the DB may have been corrupted. What can be done to recover from this?

Priti

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

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

MS SQL server 2012, Sage 300 2014 PU 3

I am trying to restore a test database using the most recent backup of its associated production database - in SQL Server Management Studio. I am restoring to another name and that task completes without errors.

I have…

Hi,

Sage 300 2016 supports SQL Server 2005 or 2008? Anyone running this last version in that environment?

Thank you