x Want to participate? Join the group to interact

  • Obtaining invoices PDFs using the API

    Hi Team, Could you advise how to obtain the invoice PDF via API?

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

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

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

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

  • Receiving Customer and Invoice notes via API

    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!

  • Customer and Invoice statuses

    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?

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

  • Sage CRM integrated to Sage 300 ERP: Person Type "A/R Contact" fields- where are these held?

    Looking for someone who knows their SQL tables here. What is the SQL table or view where I can query the Sage 300 ERP "Type" field as it relates to the CRM person record? Through the integration, the new fields "Sage 300 ERP A/R Contact" or "Sage 300…

  • how to create basic purchase orders from asp server?

    i have a asp server running various applications that pulls data through ADO database connection to generate reports , etc... but now i want to be able to create a purchase order but submitting info like vendor details, order item details/price, purchase…

  • API endpoints

    Hi, I am trying to fetch product prices and product inventory, but couldn't find any which does the job. So, can you suggest me the suitable endpoints to fetch Item price and Item inventory?

  • Working on Sage 300 Legacy Module Projects in VB6

    I have legacy projects for Sage 300 modules written in Visual Basic 6. I am trying to get Visual Studio 6 / VB6 installed on Windows 8 successfully, but am having trouble. Would it be possible to build/maintain these older projects in a more current…

*Community Hub is the new name for Sage City