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

By | May 20, 2022

Web API supports the connecting or sharing of resources and data in a very flexible and standardized manner. Services which are described are organized to support the automated discovery and reuse. Web Services API plays very important & vital role in Sage 300 ERP  as we can import / export bulk data entries at one time. Integration are usually of two types – Runtime and import / export.

In our previous few blogs, we have some content that describes the web API. Accordingly, we can build it to suit your needs and use it with any third-party software. In this blog, we will discuss about such web API developed for Sage 300 that gets you the Sales Order Status and details of the Orders that exists in the sage 300 ERP based on the customer number.

New Stuff: OCX could not be loaded

This API can be very useful if the existing sales order details needs to be extracted from Sage 300 ERP of the particular customer without any manual intervention.

Below is the simple XML structure in which you need to pass the Customer Number along with its related PO Number to get sales order details for that customer. The details needed to be sent to the API can be customized as per the requirement and the extracted data will be filtered accordingly.

XML Structure – Customer Number
XML Structure – Customer Number


Once the user sends this information (Customer Number, PO Number) to our API, it will give you return information in below XML structure which includes the Item wise details of the sales orders for the particular customer with that PO number.

If there are multiple Sales order of the passed customer number and PO number then the return XML structure will include all the multiple order details item wise.

XML Structure – Sales Order Details
XML Structure – Sales Order Details


Referring above example we can see the sales order details like Order Number, Order Status, Currency Code, Dispatch Location, Item No, Net Price, Pricing Unit, Discount, Order Quantity, Outstanding Quantity, Invoice Quantity and many more that are extracted in the XML Format. If needed, the return format of the API can be customized to JSON format and also the sales order details acquired in the XML format can be customized as per the requirement.

With the help of this API, user can get the customer wise status of the sales orders from sage 300 ERP and also if required the extracted sales order details can be used to import in other third-party software.

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.