x Want to participate? Join the group to interact

  • New to Sage. How to import files from OneDrive

    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…

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

  • Trying to set up the Sage HRMS/300 Link to run on a schedule automatically

    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…

  • Integration with Salesforce

    Does anyone have any experience or insight on integrating our on-premise Sage 300 ERP with Salesforce? I found a pricey app from Commercient, and a consulting company also suggested using DBAmp. Any thoughts on these options? Any other suggestions on…

*Community Hub is the new name for Sage City