x Want to participate? Join the group to interact

  • Invoice Amount Due

    Hello Team, Could you help me with the following question? I created an Invoice. On UI I see the following balances: The Document Total is $2.55. Amount Due is $2.51 But, when I receive this Invoice from post documents via API, Sage returns the Invoice…

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

  • Sage 300 currencies integration via API

    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…

  • Apply a Payment to the Invoice

    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…

  • Sage 300 and Sage CRM integration - cannot export OE quote or order to PDF or Excel

    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…

*Community Hub is the new name for Sage City