• Importing Production Quantities in Sage 300.

    Does anyone have any experience importing Production Quantities installed into Sage? We are looking to simplify the process of getting data from our production tracking timekeeping tool back into the Job cost report in Sage.
  • User unable to promote company to Sage 300 Customer/Vendor

    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: …
  • Error while installing Workstation Setup

    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…
  • Error message via API - Property 'ReceiptsAdjustments' on type 'Sage.CA.SBS.ERP.Sage300.AR.WebApi.Models.ReceiptAndAdjustmentBatch' is not a navigation property. Only navigation properties can be expanded.

    Team, I need your help. I would like to use the following request to receive payment: {{BASE_URL}}/Sage300WebApi/v1.0/-/SAMLTD/AR/ARReceiptAndAdjustmentBatches?$expand=ReceiptsAdjustments($filter=DocumentNumber eq 'PY00000000000000000133') But Sage 300…
  • Error message via API - Property 'ReceiptsAdjustments' on type 'Sage.CA.SBS.ERP.Sage300.AR.WebApi.Models.ReceiptAndAdjustmentBatch' is not a navigation property. Only navigation properties can be expanded.

    Team, I need your help. I would like to use the following request to receive payment: {{BASE_URL}}/Sage300WebApi/v1.0/-/SAMLTD/AR/ARReceiptAndAdjustmentBatches?$expand=ReceiptsAdjustments($filter=DocumentNumber eq 'PY00000000000000000133') But Sage 300…
  • How to pay an invoice by credit memo via API?

    Hi Community, Could you share the API request of how to pay the invoice by credit memo?
  • Receiving Multiple Contacts via API

    Hi Team, Could you provide the endpoint to receive multiple contacts via API from Sage 300? I used this documentation https://cdn.na.sage.com/docs/en/customer/300erp/2017/open/Sage300_WebAPI_EndpointReference.pdf and didn't find the endpoint.
  • Sage 300 Webapi error -DBLinkError

    Hello I m trying to call a sage300 webapi - for ARCustomers in swagger, without this i wont be able to deploy my custom app log and screenshot attached the following test has been conducted The user credentials and company ID you are using…
  • Unable to post IC Transfers Transit Receipt via webAPi

    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…
  • Sync data by Entities/Subsidiaries from Sage 300

    Hi Team, Please, help me with the following question. Is it possible to create a few Entities or Subsidiaries at the Company level in Sage 300? For example, I have a company SAMLTD. In the company SAMLTD, I want to add a few Subsidiaries. AR1…
  • Sagekit a Ruby client library for Sage300 API

    Six months ago I have decided to build a Ruby client library to interact with the Sage300 API. I never imagine this gem will reached 5000 downloads. I'm reaching out to finally share this gem with the community. It is released under the MIT license and…
  • Sage 300 and AutoSimply Barcode application very slow

    Hello fellow Sage 300 users and IT Admins, We are using Sage 300 2022 and we use AutoSimply Barcode application along with our Sage 300. We currently are on the latest PU for Sage 300 2022 and we even have the latest customized AutoSimply Barcode 2022…
  • Can't Set Column Order in Quotes and Orders in CRM's Sage 300 Integration

    Hi All, We have Sage CRM setup with Integration with Sage 300. On the quotes and orders pages in Opportunities, our users are used to being able to select which columns are displayed on the item grid (Item number, description, qty, etc). Which has all…
  • The Invoice doesn't depict a link to the payment.

    Hello Team, I applied a payment to the Invoice. But inside the Invoice, I cannot see the link to the applied payment. How I can detect inside the Invoice that the Invoice is related to payment?
  • Difference between payments type in Sage 300

    In Sage 300 when the user creates a Receipt payment, the user can select a few types of payment. For example: Receipt Prepayment What is the difference between these types? I found one difference. If the type is Receipt , the user applies a payment for…
  • Error during the search Customers by period via API

    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…
  • Sage 300 Currency ISO-CODE

    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…
  • How to receive Sage 300 account currency via API

    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…
  • How to receive the adjustment unique identifier

    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?
  • Invoices Type -> Retainage Invoice, Retainage Credit Note, Retainage Debit Note.

    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…
  • How to receive the Invoice unique identifier

    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…
  • Sage 300 API doesn't return deleted Customers

    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…
  • Customer Balance

    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?
  • Error during the push payment to Sage 300. The payment type is 'Receipt'.

    Hello Team, I try to push a payment with the 'Receipt' status. But I receive an error message: "value": "The request parameters are invalid. Fail to save value to (Applied Receipts/Adjustments) for fields (Customer Number, Document Number, Payment Number…
  • Customer and Invoices contacts

    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?