Sage 300

Hello Team, Could you help me with the following question. I cannot filter Customers by date and time. Example: http://{BASE_URL}/Sage300WebApi/v1.0/-/SAMLTD/AR/ARCustomers?$top=1000&$filter=DateLastMaintained gt 2000-01-01T01:08:35 or DateOfLastActivity…

Hello Team, Is it possible to receive the Currency ISO-CODE via API? I tried to use the following endpoints: CSCurrencyCodes CSCurrencyRates But Sage 300 doesn't return the Currency ISO-CODE. Also, I cannot find the Currency ISO-CODE on UI. Could you…

Hello Team, I want to receive the Sage 300 account currency via API. The account currency is CAD. To receive the currency I use the following endpoint - CSCurrencyRates And I expected that Sage 300 should return me one row with the Account currency. But…

Team, We use the following endpoint to receive adjustments -> http://{BASE_URL}/Sage300WebApi/v1.0/-/SAMLTD/AR/ARReceiptAndAdjustmentBatches What field I can use from the API response as the adjustment unique identifier?

Hello Team, Once I create an Invoice, I can select the following Invoice types: - Retainage Invoice - Retainage Credit Note - Retainage Debit Note In which cases the user should select the following type to create an Invoice? Do these Invoice types influence…

Hello Team, We use the following endpoint to receive Invoices - http://{BASE_URL}/Sage300WebApi/v1.0/-/SAMLTD/AR/ARInvoiceBatches But, Sage 300 API doesn't return the Invoice unique identifier. Invoice Batch is not unique due to combining a few invoices…

Hello Team, We use the following endpoint to receive Customers from Sage 300: http://{BASE_URL}/Sage300WebApi/v1.0/-/SAMLTD/AR/ARCustomers But, if the Customer is deleted in Sage 300, this endpoint doesn't return Customers. How we can receive deleted…

In Sage 300 the Customer has three balances: But via API Sage 300 returns only the Outstanding A/R Balance. How to receive A/R Pending Balance and Total Outstanding Balance via API?

Hello Team, I found that I can add contacts only at the Customer level in Sage 300. But I cannot find how to add contacts at the Invoice level. Could you clarify, is it possible or not?

Hello Team, Does Sage 300 allow receiving Customer and Invoice notes via API? If yes, could you provide the endpoint on how to receive notes? Thank you!

Hello Team, In Sage 300 the Customer has a few balances As I understand, the main Customer Balance is the Total Outstanding Balance . Is it correct? Or we should use as the main Customer Balance this field -> Outstanding A/R Balance ?

Hello Team, Sage 300 API returns the following fields for TAX: "TaxGroup" : "AGST" , "TaxRegistrationNumber1" : "" , "TaxRegistrationNumber2" : "" , "TaxRegistrationNumber3" : "" , "TaxRegistrationNumber4" : "" , "TaxRegistrationNumber5…

Team, Is it possible via API to receive Invoices and Customers statuses? If yes, could you provide the name of the endpoint? Where on UI in Sage 300 I will be able to find the list of Invoices and Customers statuses?

Hello Team, I have some questions about how to integrate currencies from Sage 300. We use the following endpoint: http://{Base_URL}/Sage300WebApi/v1.0/-/SAMLTD/CS/CSCurrencyRates 1. API returns the RateTypes. How they influence of the choice which record…

Hello Team, I want to apply a payment to the Invoice. To do it I use the following endpoint: POST ARPostReceiptsAndAdjustments Example of the request: { "BatchRecordType" : "CA" , "BatchNumber" : 77 , "BatchDate" : "2021-06-27" , "Description…

Hello Team, Does Invoice have the Invoice close date? If yes, what is the name of this field on UI? And what is the name of this field in the response for method ARInvoiceBatches?

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…

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 All, I would like to know if is there any ISV that provide features to set bundled sales. For example buy 12 get 1 free. I have check Standard Sage 300 IC, it does not support this. Or is there workaround to achieve this? Thank you.

Is there any way to post a Sales Order shipment via the Web api in order for it to create an Invoice? I have Sales Orders created on Sage, and I want to create a shipment related to that Sales Order and have Sage create an Invoice associated to that…

Are there any Sage 300 inventory module "how to" videos?

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…

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…

Hi, I am thinking this falls in the Sage 300 category since user is trying to export and OE order or OE quote to PDF from Crystal reports but they are doing in in Sage CRM. The Crystal Report shows up fine but when they try to export to PDF nothing…