Sage 300

Hi, We need to do a mass change in item descriptions. What is the table that contains the items in price lists? Ty.

The error above appeared on one workstation only at a client when posting a Purchase Order. This workstation was fine for several months after the upgrade They were recently upgraded to Sage 300 v2021 PU2. They are also integrated with CRM 2021 if that…

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…

Hi When I imported one transaction to see how reconciliation works, i got the below error. It says 1 updated but It does not reconcile that transaction, please could someone throw some light ?

Hi, I want to import bank statements into Sage 300 - I am not sure what the below fields do and what their exact column name would be for my import file. Could someone please help ? Cleared Y/N - Integer (Column Name ?) Used Y/N - Boolean (Column…

Greetings from Vancouver Island. We have SAGE 300 running. I have successfully connected to the underlying MS-SQL DB via Excel (ODBC), Azure Data Studio, and Microsoft Power BI. So, access is not a problem. I've received a zip file from my support company…

I have a simple 2 workstation setup. Both workstations are windows 10 Pro. W-1 has SQL server on it and is on the "PNET" workgroup. W-2 just has the client also on the PNET workgroup. Network set to private. When I turn the firewall off for private…

We are working with a company using Sage 300 on a Pervasive SQL database. They are interested in exporting data such as GL, AR, and AP transactions and other table information, such as accounts, customers, and vendors. I'd like to know if there are…

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…

Hi, I am getting the below error message when i try and Import transactions into Costs under the PJC transactions. The Error mentions PM0420 which either has to do with Document Number or Line Number, but I am not able to resolve this error - Could…

We are implementing Sage 300 ERP on premises. Due to current situation, implementation taking longer than planned. The simple question is, how can we migrate current FY data back to January from our legacy Peachtree Quantum system to sage 300? Comments…

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, kindly advise me ANY BODY HERE TO HELP OUT MY…

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've got a simple SQL query the shows details of invoice payments from APOBL but I'm struggling to join details of the customer or the actual order/invoice they have paid up. Is anyone able to help me please? Cheers Andy

I Have already tried : https://support.na.sage.com/selfservice/viewdocument.do?noCount=true&externalId=83373&sliceId=1&isLoadPublishedVer=&docType=kc&docTypeID=DT_Article&stateId=2105&cmd=displayKC&dialogID=77215&ViewedDocsListHelper=com.kanisa.apps…

We have a couple of optional fields set up in I/C on about 50K items that have not been used in years. Can't delete then because "they are in use" I want to clean this up and then set up one new valid optional field. Are there any ramifications…

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 am receiving fallowing error in all modules after test conversion to 2019. Running Windows Server 2019 and SQL Server 2017. I setup 32bit ODBC connection as suggested in upgrade guide. Data conversion completed without any errors but I am not able to…

Hi, all. I'm trying to create a couple of simple PHP pages to display some info from CRE 300, using the 32-bit Timberline ODBC driver (not MS SQL). The ODBC connection works for MS Access and Excel, and I can establish a connection using PHP, but I…

Hi, Upgraded a client fro Sage 2017 to Sage 2019. Some machines return the error=40960 while others work fine. recreated the DNS on error machines but the issue continues. What could be the issue?

I would like to use a spreadsheet to select the invoices in which I am paying. At this time we use Event one writeable and it would be more convienient to go in and change or click those invoices in which I am paying, then send to Sage to set up for…

I have installed the sage 300 2018 workstation in window 10 64-bit and get the error message said that cannot access the database. And then checking the ODBC 32-bit find that the SQL server has error " SQL server network interfaces: Error Locating Server…

Hi, We are upgrading to Sage 300 2018 and need SQL Server Native Client 11.0 but not sure where I can found. Apparently one comes with SQL Server 2012 but not sure if thats OK no matter we have SQL Server 2016 or 2017? Any idea? Thank you

Error message when running report in Sage Intelligence. This was working last week. Description : [Microsoft][ODBC SQL Server Driver][SQL Server]Conversion failed when converting date and/or time from character string. Number : -2147217913 Source…