Web API to Get Customer Details by Customer No in Sage 300

By | March 14, 2022

Web API basically means software that enables two or more applications to exchange data (messages) with each other. API integrations helps organizations with multiple software systems to exchange data with each other to keep data in sync enhance productivity and drive revenue. Nowadays API is part and parcel of almost everything in the digital world. Irrespective of the business and the proportion of the enterprise, APIs provide a seamless working and performance of applications and web systems.

There have been many such blogs based on APIs developed for the Sage 300 ERP integration with any other third party software. In this blog, introducing you the another such web API developed for sage 300 that gets you the customer details of the customers that exists in the sage 300 based on the customer No.

New Stuff: AP Payment Export utility

This API can be very useful if the customer details needs to be imported to the any other third party software without any manual intervention.

Below is the simple XML structure in which you need to pass Customer No in the Company Code tags to know details of that customer i.e. 1400 as per the below screenshot.

XML Structure - Customer Number
XML Structure – Customer Number


Once you will send this information (Customer Number) to our API, this will give you return information in below XML structure.

XML Structure - Customer Details
XML Structure – Customer Details


Above are the customer details like Account Set, Customer Name, Address, Phone No, Dispatch Method, Language Code, Customer Type, Credit Balance, Price List and many more that are extracted in the XML Format .The return format of the API can be customized to JSON format and also the customer details needed in the return format can be customized as per the requirement.

With the help of this API, user can extract the customer details from sage 300 and can import the details in other third party software as required.

About Us

Greytrix – a globally recognized and one of the oldest Sage Development Partner is a one-stop solution provider for Sage ERP and Sage CRM organizational needs. Being acknowledged and rewarded for multi-man years of experience, we bring complete end-to-end assistance for your technical consultations, product customizations, data migration, system integrations, third party add-on development and implementation competence.

Greytrix offers unique GUMU™ integrated solutions of  Sage 300 with Sage CRM, Salesforce(listed on Salesforce Appexchange), Dynamics 365 CRM and Magento eCommerce along with Sage 300 Migration from Sage 50 US, Sage 50 CA, Sage PRO, QuickBooks, Sage Business Vision and Sage Business Works. We also offer best-in-class Sage 300 customization and development services and integration services for applications such as POS | WMS | Payroll | Shipping System | Business Intelligence | eCommerce for Sage 300 ERP and for Sage 300c development services we offer, upgrades of older codes and screens to new web screens, latest integrations using Data and web services  to Sage business partners, end users and Sage PSG worldwide.

Greytrix offers 20+ addons for Sage 300 to enhance productivity such as GreyMatrixDocument AttachmentDocument NumberingAuto-Bank ReconciliationPurchase Approval SystemThree way PO matchingBill of Lading and VAT for Middle East. The GUMU™ integration for Dynamics 365 CRM – Sage ERP is listed on Microsoft Appsource with easy implementation package.

The GUMU™ Cloud framework by Greytrix forms the backbone of cloud integrations that are managed in real-time for processing and execution of application programs at the click of a button.

For more details on Sage 300 and Sage 300c Services, please contact us at accpac@greytrix.com, We will like to hear from you.