Sage 300

Wrote simple app to simulate login into Sage 300 in C# i can query the company names... but when i try to actually use a password and login user it gives me Invalid Signon Information error message, anyone know what i'm doing wrong? session =…

Hi Everyone, I am working on one sage integration with python web application and I want to send data from python application and create customer in sage. I am using desktop version of sage. My question here is if the API https://cdn.na.sage.com/docs…

I have the following code to create a session. Session s = new Session(); s.Init("", "XY", "XY1000", "67A"); s.Open(User, Password, Company, DateTime.Today, 0); A client had been using ADMIN/ADMIN for the username and password (don't ask why they…

Hi, I am trying to build a solution that should integrate with Sage 300 cloud to sync customers, projects, work orders, etc... I have looked around but could not find any documentation about Sage 300 cloud API. Could you please point me to Sage 300…

Client in Canada has an entity that resides in the UK. They received a letter saying that they are 'required' to use MTD (Making Tax Digital) software to file their VAT returns. It seems that Sage 300 Cloud is not on their supported software list. Has…

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.

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

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…

Hello, We have a Sage 300 On Premise (non-cloud) version. We are looking to integrate it with our e-commerce website (PHP). We want to do two-way integration. 1) : From Sage 300 to website Customer invoice, order history, tracking information from…

I'm sending adjustments to Sage 300 ERP Server for 'posted' invoices and I know that the transaction are successful because the webapi call returns a reponse code is 201 and the response message contains the information I sent but when I open the adjustment…

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…

We are looking for someone to connect our Web API with Sage 300. These are the functionalities we need -Push Invoice -Verify if customer exists -If customer doesn't exist, create new customer in Sage We are currently building the Web API, therefor it…

Sage 300 dotNet API project. Lots of the available docs say to use create a macro in the UI for what you want to do and then translate to C#. Works great for most of it but I am having an issue with the PROCESSCMD lines, which are often necessary to get…

Currently Running Sage 300 Web API v1.0 | 6.4.0.20 I'm currently working on a integration project where I will be will utilizing the Sage 300 Web API. This integration will be focusing on Order Entry where we can insert a new order (POST) and eventually…

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

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?

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…

I need to start programming in sage 300. Typically programs that import etc. What software do I need and where can I get a good tutorial on this? I have no starting point.

Hi - I have a client that would like to export A/R data from Sage 300 (specifically the Aged Trial Balance report) and upload it to my server (we are a SaaS provider). They have nearly 100 "companies" in Sage that they would like to do this for, and doing…

Hi, Does anyone have any recommendations for Online Portal and/or Ecommerce Integration with Sage 300? Requirements: 1. It must integrate with Sage 300. 2. Integrate with Ariba and Ariett 3. Be able to take Credit Card Payments 4. Be able…

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…

I am trying to insert an optional field for a new sales order. When I run the macro recording I get some code and have ported that to C#. The issue is, it did not seem to work. ordersView.Process(); ordersView.Fields.FieldByName("PROCESSCMD").SetValue…

Dear all i wrote a macro in order entry module the macro doing order entry and ship all when post the OE transaction in Macro its make OE, invoice and shipment automatically but the problem sometimes its make order entry only i must restart the server…