Sage 300

Hi, has anyone here using Sage300 WebAPI managed to create a POReceipt that attaches to a PO? I've seen reports of this not working that are some years old, perhaps this has never been fixed? Including PurchaseOrderNumber / PurchaseOrderSequenceKey…

Hi all, I am able to promote company as admin. However, my user unable to promote company to Sage 300 Customer/Vendor, stating that the Customer code already exists in Sage 300 Company, but the customer code does not exist yet. My user setting: …

Hi all, My customer is having error while installing the Workstation setup on Sage 300. Checking the log file, a lot of things cannot be found. how do I fix this? The following properties have been set: Property: [AdminUser] = true {boolean…

Hi - wondering if anyone has tried this. That aside, just came to know that Sage stopped development on the CRM app 3 years back. Wondering if there are any other options out there. On a separate note- has anyone used the mobile CRM extensively? …

We are writing an integration with Sage300, and for some reason, the `OEOrders` endpoint does not return closed orders (I assume by default, it excludes closed orders). There is no documentation for to include them either anywhere. Does anyone know how…

Hi, With Sage 2022 PU3, we send an AP invoice in Sage using the endpoint APInvoiceBatchList. According to the documentation the DUEDATE is optional( DueDate ( string , optional ),). If we don't put a due date, it gives the error "Due date is invalide…

Good Day, I'm using sage 300 (2023). I'm trying to use IC Transfers via webAPi I have two operations succeeded 1- Direct Transfer 2 - Transit Transfer Yet when I try " Transit Receipt " i receive the following error "You cannot import transit…

We are running Sage 300 2020. Our finance team has been working with Excel files on a network share and then importing to Sage 300 GL transactions. We are in the process of decommissioning an old file server and moving their files to SharePoint Document…

Sage web API Financial Reporter how can I retrieve the EBITDA using the web API

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 Experts , I'm currently working on a integration project where I will be use the Sage 300 Web API. This integration will be focusing on Order Entry / Invoice Entry where we can insert a new order (POST) and eventually we will need to be able to…

Where can I find a document or a user guide on how to integrate Sage 300 2020 PJC and Microsoft Projects 2016. Please advice

How do we report an issue with the Sage 300 Web API? The POReceipts post will not store the Purchase Order number that is posted on the new Receipt. Yet, the 'PurchaseOrderNumber' is included in the model - but the API doesn't appear to do anything…

Is there a way to create a Shipment from an existing order using Sage 300 Web API? The API allows us to create both an order, or a shipment using the QuantityShipped field on the OrderDetails object. By using the QuantityShipped value, Sage will create…

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…

Hi Expert I am middle of a prodect and i am getting stucked. I need to fetch inventory details location or warehouse wise in webapi. In the following way, I am using Request url xxxxxxxx/.../ICItems eq '*KL-ST1-R*' I want the inventory details…

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…

Hello, I need to do a customer search using the Sage 300 Web API, but it needs to be case insensitive as some customer names are proper and some are in all caps. According to the OData documentation I should be able to use the tolower function, but…

Can anyone confirm if a Sage 300 user has to be available to view Order Inquiries in Sage CRM? We are encountering an issue where the company does regularly reach their total number of users in Sage 300. It seems that when they do, if a CRM user goes…

I'm trying to run the HRMS and Sage Link Automatically by setting it up in the Schedule Profile Configuration and Schedule User Login Configuration under Sage Payroll Link- Sage HRMS Setup. I'm following the steps provided to me in the user guide (attached…

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