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.
I'm a developer working on application that requires syncing a database of my own with a number of tables in the SAGE 300 databases. I was previously using the SAGE COM APIs to do this syncing, but my application is written in C#, so I'm in the process…
we are using sage 300 with the technisoft service manager app on a Samsung a8 tablet. in the stored actions it says the above line and wont sync anything following that. I've tried everything from fully deleting the work order on the dispatch side (pc…
Hello community, I am unable to access Purchase Orders or anything under the P\O inquiry page even though I have installed Sage 300 on the same server and performed all the necessary steps for the integration.
Every time I click, for example, on All…
I am going through the database editor and moving some items into a different phase. I am using "Renumber Items" to change the phase code of multiple items at a time. One of the prompts is "Job Cost Phase" and the default option is "Don't Change". However…
Are ICPRIC and ICCPUR accessible via the Sage API?
If not, is there any other way to access Price Lists, other than by direct SQL Query or middleware such as Realisable IMAN?
I have a sync app running and it's exporting out from Sage: Orders, Shipments, Customers, Inventory, and Credit Notes. I want to only grab the records that have changed since the last time I ran the sync. For some of these it seems I can grab the DATELASTMN…
. The client is noticing quite a lot of this. This is from the IC location details screen Sage 300 2020 Perpetual license.
The screen shows 10 on hand 44 on sales order. However, 44 are not on sales order. There are only 24 total on sales order.
I…
I have a client that is planning on changing banks. The problem is that they have over 1000 credit cards saved. They are using PAYA, but the problem is that in Sage 300 the credit card is associated with a bank. I have been told that when they change…
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…
Is there a way to look at AR detail data and "walk it back" to the original OE detail line?
We have a reporting requirement that would need us to do this.
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…
Sage 300 2014 PU 5 was loaded on a new machine (Windows 7 Pro). Data is on the server. MS SQL 2008 R2 SP2.
Sage 300 opens but when you try and access the data you get the following messages:
Error occurred when activating Sage 300 ERP Data Source…
I have a live 300 (2014) system with 2 live databases. I've installed Sage CRM 7.3 as part of a new project. While I do the dev, I don't want to sync their live databases. What is the process for making 2 new databases that are copies of the live databases…
Customer is getting "unknown database error (operation =, error = 226) when trying to inactivate an item.
I have a copy of their data locally and I do not get the error.
Is this a likely a connectivity issue or something else going on?
Thanks.
Hi All,
Everyone must be aware that we have to link a database (e.g. SQL database) with SAGE 300 during database setup. However, is there anyone who knows why does SAGE limit the characters that we can enter in database ID field to six characters? …
I have installed 2016 sage 300 and the screens are working in windows but while login in through internet explorer the below error getting.
Server : 2012 R2
Sql :2014
I am getting a day end processing error on a set of data. It is a Sage 300 2014 install with PU3 installed. The RVSpy log is below any help on this would be greatly appreciated.
[45a8.7ff.3c14] AP0024: APIBT [23:17:17.39].Close(view=0x0AA21894) [45a8…
Hello there!
I need to add new Orders Entry through code. Everything is working fine, but now I need to add some Misc Item to new Orders Entry. I can successfully create new Orders, but my Misc Item Extended Cost(EXTINVMISC) is always set at zero. I…
Good day everyone. I just want to find out if its possible to run accpac from two seperate SQL servers? To have one SQL instance run from server 1 and another on server 2 but one accpac installation looking into the two two instances?
Is there any way to delete a category that has been setup incorrectly(set to misc cost type instead of equipment) after it has been added to a project. The project does have other costs posted so I can not set the project to estimate. The category itself…
Here is the scenario, there is a group of inactive items that haven't been used for at least 2 years in the system. Am I allow to delete the item records? What is the effect of deleting the item records? Example, item number 00001 has an old receipt and…
Hi there
We are making a report in which we have to consider Applied documents.
How can we trace whether a document is applied or not through database or front end on the doc?
Regards
I am setting up a new company in Sage 300 2016 using MSQL. I believe I have the MSQL database and Sage database/system setup correctly. I have verified the Sage database/system with no errors. When I open Sage, the new company is listed and it will login…