• HOW TO GENERATE A PREVIOUS BANK RECONCILIATION REPORT?

    Good day community, I am trying to retrieve a bank reconciliation report as of November 31, 2023. I am in January 2024 and I am unable to go back to that specific date (November 31, 2023) Is there an alternative way to retrieve this report? My error…
  • ICSHipment in Postman

    Hi Im getting the below error when i try to post back to the API using postman
  • 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…
  • 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…
  • 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…
  • 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…
  • 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 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…
  • System.AccessViolationException with ACCPAC.

    Hello Experts, Facing the below error while accessing the ACCPAC API. System.AccessViolationException at AccpacCOMSVR.AccpacSvrViewClass.Process() at ACCPAC.Advantage.Server.View.Process(FieldValue[], Int32[]) We have a .Net based windows service…