Sage 300

Does anyone knows of a web-based Payables Workflow that is able to process and approve job-related PJC invoices with retainage? Both Pacific Technologies and Norming's solutions do not handle PJC retainage. Thanks.

Hi everyone, I am at the moment investigating the availability of cloud APIs for Sage300, and could find some documentation of an available web API, but which is not listed here https://developer.sage.com/ , and now wondering why? Is there an available…

I have created a C# web service suing the Sage 300 objects, and all is working well except when I try to add another line to an existing order I get: "Order Detail. Attempt to modify a different record than was retrieved." This occurs on the code…

Hello , I'm new with sage 300 and i need to connect my Talend data integration with sage to extract data. To this i installed sage 300 on my machine i created a simple company to do the test , then installed CData JDBS Driver for sage 300 ... …

Hi, I'm currently creating OE Orders using the Web API and have hit an issue where a Customer will exceed the Credit Limit if the Order is created, and so get back the following from the API call: "Credit limit exceeded for customer x. The order will…

Hello, Is there any method/setting, that can ‘Restrict’ certain Customers (with specific Group code) that are created within Sage 300 from getting into CRM as company record? I know that if we tick the suspend A/R integration to CRM checkbox from…

Hi there, I have a client on Sage 300 5.6 and have upgraded them to 2020. There was some legacy code written to connect an external program through the AccpacCOMAPI but it is now broken. Specifically, when I try to run this, it fails when trying to…

I am using the Accpac.Advantage dlls to communicate from a third party .net app into Sage 300. The processes we are doing are simply to open a connection and then return various pieces of information from view calls (I use the CS query view through an…

Hi all, I'm getting this error after I tried to Post Order Entry via sage 300 web api swagger in json format. the error message is : { "erro r": { "co de" : "InternalServerErro r", "mess age": { " lan g": "en -US", " val ue": "Internal Server E rror…

Dear All, I am unable to do multi select option in all the list box fields in sage crm, this is happened only after installting the sage 300 2019 integration setup. Sage CRM ver 2018 R3. Please refer to the bleow url which is from sage CRM Community…

How can we restrict or reserve one LANPAK from one IP address. We have a web store where we selling items . a customer purchases item on web store and it goes and creates an order and an invoice in sage.. The service is configured to use a sage LANPAK…

Hello, I have been working with the Sage staff and currently still do not have a resolution to this issue. Effectively I am making a request through the API to enter an order for a purchased item from the website. Initially I was getting errors I…

Hi, I am trying to fetch product prices and product inventory, but couldn't find any which does the job. So, can you suggest me the suitable endpoints to fetch Item price and Item inventory?

I am having Sage 500 ERP and ACDEV POS integrated with this and working fine. Now I have newer version Sage 300, 2016. Now how can integrate my ACDEV POS with Sage 300

Hi, We'd encountered quite a number of issues related to Integration after implemented at our client's server. Our technical team tested and found out that if the domain user being assigned to domain admin rights, he/she will have no issue accessing…

One of our client want to have WMS with our Sage 300 ERP. and the WMS provider requires APIs for integration between Sage 300 and WMS. Any idea?

cCRM V7.3 / S300 V2014 / SQL 2008 R2 / Win 2008 R2 A couple of times a month the integration between CRM & Sage 300 stops working. We get the message (session could not be opened) with number (2147221230) I have checked the services and IIS and…

Three related questions regarding Sage 300 2012 and Sage CRM 7.1: 1. When we implemented Sage CRM, we imported all of our Sage 300 customers into CRM. For about six months, some of the Sage 300 users didn't have the Integration piece up and running…

We have created an app that pulls order information from Order Entry and populates a spreadsheet. We have optional fields that have been added to order entry that indicates one of our Buyers. The Manager opens the spreadsheet and assigns a buyer to each…

Hi, MS released an update this past weekend and it seems to have affected connections to excel. I was wondering if anybody else has experienced this. Before the MS updates our macros were programmed to connect to Excel with Microsoft.ACE.OLEDB.12.0…

Hi All I didn't work with Sage products yet one of our clients want to make automatically integration between our PHP web system with Sage 300 2016 version they are doing integration manually, they are inserting data twice i'm searching for…

Does anyone have any experience or insight on integrating our on-premise Sage 300 ERP with Salesforce? I found a pricey app from Commercient, and a consulting company also suggested using DBAmp. Any thoughts on these options? Any other suggestions on…

Hi Guys, I have an issue when attempting to retrieve or insert data into SAGE databases using the SDK 61A. I am able to establish connection with the SAGE database and open the Views. However, I am getting a HRESULT E_FAIL error when I try to retrieve…

I need some advice with a lead. It is unusual because they are primarily interested in developing an interface to Sage 300 from their custom in house software, which is developed in a LINUX environment using PHP and PYTHON programming. Specifically they…

This is a quick reminder for those using Sage 300 ERP 2012 product update 2, Please confirm you have installed the correct integration piece f or Sage CRM 7.2 integrated systems. Login to the Knowledgebase and visit KB 22596: Download Sage CRM 7.2 Integration…