{"id":31286,"date":"2022-05-20T09:20:18","date_gmt":"2022-05-20T09:20:18","guid":{"rendered":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/?p=31286"},"modified":"2023-10-03T07:29:34","modified_gmt":"2023-10-03T07:29:34","slug":"web-api-to-get-sales-order-details-by-customer-no-in-sage-300","status":"publish","type":"post","link":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2022\/05\/20\/web-api-to-get-sales-order-details-by-customer-no-in-sage-300\/","title":{"rendered":"Web API to Get Sales Order Details by Customer No in Sage 300"},"content":{"rendered":"\n

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<\/a>  as we can import \/ export bulk data entries at one time. Integration are usually of two types \u2013 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: <\/em><\/strong>OCX could not be loaded<\/a>

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.
<\/p>\n\n\n\n

\"XML<\/a><\/center>\n
XML Structure – Customer Number<\/center><\/font>\n\n\n\n


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.<\/p>\n\n\n\n

\"XML<\/a><\/center>\n
XML Structure \u2013 Sales Order Details<\/center><\/font>\n\n\n\n


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.

<\/p>\n\n\n\n

About Us<\/strong><\/span><\/p>\n\n\n\n

Greytrix<\/a> – a globally recognized and one of the oldest Sage Development Partners 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.<\/p>\n\n\n\n

Greytrix<\/a>\u00a0offers unique GUMU™<\/a> integrated solutions of\u00a0\u00a0Sage 300 <\/a>with Sage CRM,\u00a0Salesforce(listed on Salesforce Appexchange), Dynamics 365 CRM, and\u00a0Magento eCommerce,\u00a0along with Sage 300 Migration from\u00a0Sage 50 US, Sage 50 CA, Sage PRO, QuickBooks, Sage Business Vision and Sage Business <\/a>Works<\/a>. We also offer best-in-class\u00a0Sage 300 customization and development services\u00a0and integration services for applications such as\u00a0POS | WMS | Payroll | Shipping System | Business Intelligence | eCommerce for Sage 300 ERP<\/a>\u00a0and 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. <\/p>\n\n\n\n

Greytrix offers 20+ add-ons for Sage 300 to enhance productivity such as\u00a0GreyMatrix,\u00a0Document Attachment,\u00a0Document Numbering,\u00a0Auto-Bank Reconciliation,\u00a0Purchase Approval System,\u00a0Three-way PO matching,\u00a0Bill of Lading,\u00a0and\u00a0VAT for the Middle East. The GUMU™ integration for Dynamics 365 CRM \u2013 Sage ERP is listed on Microsoft Appsource with an easy implementation package. <\/p>\n\n\n\n

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. <\/p>

For more details on Sage 300 and Sage 300c Services, please contact us at accpac@greytrix.com<\/a>, We will like to hear from you.<\/p>\n","protected":false},"excerpt":{"rendered":"

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\u2026 Read More »<\/a><\/span><\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[3916,1775,2357,3915,3917],"class_list":["post-31286","post","type-post","status-publish","format-standard","hentry","category-sage-accpac","tag-get-sales-order-status","tag-oe-orders","tag-sage-300-erp","tag-sales-order-details-web-api","tag-sales-order-export-api"],"yoast_head":"\nWeb API to Get Sales Order Details by Customer No in Sage 300 - Sage 300 ERP \u2013 Tips, Tricks and Components<\/title>\n<meta name=\"description\" content=\"Web Services API plays very important & vital role in Sage 300 ERP as we can import \/ export bulk data entries at one time.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2022\/05\/20\/web-api-to-get-sales-order-details-by-customer-no-in-sage-300\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Web API to Get Sales Order Details by Customer No in Sage 300 - Sage 300 ERP \u2013 Tips, Tricks and Components\" \/>\n<meta property=\"og:description\" content=\"Web Services API plays very important & vital role in Sage 300 ERP as we can import \/ export bulk data entries at one time.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2022\/05\/20\/web-api-to-get-sales-order-details-by-customer-no-in-sage-300\/\" \/>\n<meta property=\"og:site_name\" content=\"Sage 300 ERP \u2013 Tips, Tricks and Components\" \/>\n<meta property=\"article:published_time\" content=\"2022-05-20T09:20:18+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2023-10-03T07:29:34+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2022\/05\/image-3.png\" \/>\n<meta name=\"author\" content=\"Greytrix\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Greytrix\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2022\/05\/20\/web-api-to-get-sales-order-details-by-customer-no-in-sage-300\/\",\"url\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2022\/05\/20\/web-api-to-get-sales-order-details-by-customer-no-in-sage-300\/\",\"name\":\"Web API to Get Sales Order Details by Customer No in Sage 300 - Sage 300 ERP \u2013 Tips, Tricks and Components\",\"isPartOf\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2022\/05\/20\/web-api-to-get-sales-order-details-by-customer-no-in-sage-300\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2022\/05\/20\/web-api-to-get-sales-order-details-by-customer-no-in-sage-300\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2022\/05\/image-3.png\",\"datePublished\":\"2022-05-20T09:20:18+00:00\",\"dateModified\":\"2023-10-03T07:29:34+00:00\",\"author\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/#\/schema\/person\/93977cd8aa8fbd1f151d3f664e29c9f2\"},\"description\":\"Web Services API plays very important & vital role in Sage 300 ERP as we can import \/ export bulk data entries at one time.\",\"breadcrumb\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2022\/05\/20\/web-api-to-get-sales-order-details-by-customer-no-in-sage-300\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2022\/05\/20\/web-api-to-get-sales-order-details-by-customer-no-in-sage-300\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2022\/05\/20\/web-api-to-get-sales-order-details-by-customer-no-in-sage-300\/#primaryimage\",\"url\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2022\/05\/image-3.png\",\"contentUrl\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2022\/05\/image-3.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2022\/05\/20\/web-api-to-get-sales-order-details-by-customer-no-in-sage-300\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Web API to Get Sales Order Details by Customer No in Sage 300\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/#website\",\"url\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/\",\"name\":\"Sage 300 ERP \u2013 Tips, Tricks and Components\",\"description\":\"Explore the world of Sage 300 with our insightful blogs, expert tips, and the latest updates. We\u2019ll empower you to leverage Sage 300 to its fullest potential. As your one-stop partner, Greytrix delivers exceptional solutions and integrations for Sage 300. Our blogs extend our support to businesses, covering the latest insights and trends. Dive in and transform your Sage 300 experience with us! \",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/#\/schema\/person\/93977cd8aa8fbd1f151d3f664e29c9f2\",\"name\":\"Greytrix\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/3cdb553d6ca07df0e407d5e092f2410d163e0fd40b27734b345b04c8f0786969?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/3cdb553d6ca07df0e407d5e092f2410d163e0fd40b27734b345b04c8f0786969?s=96&d=mm&r=g\",\"caption\":\"Greytrix\"},\"url\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/author\/greytrix\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Web API to Get Sales Order Details by Customer No in Sage 300 - Sage 300 ERP \u2013 Tips, Tricks and Components","description":"Web Services API plays very important & vital role in Sage 300 ERP as we can import \/ export bulk data entries at one time.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2022\/05\/20\/web-api-to-get-sales-order-details-by-customer-no-in-sage-300\/","og_locale":"en_US","og_type":"article","og_title":"Web API to Get Sales Order Details by Customer No in Sage 300 - Sage 300 ERP \u2013 Tips, Tricks and Components","og_description":"Web Services API plays very important & vital role in Sage 300 ERP as we can import \/ export bulk data entries at one time.","og_url":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2022\/05\/20\/web-api-to-get-sales-order-details-by-customer-no-in-sage-300\/","og_site_name":"Sage 300 ERP \u2013 Tips, Tricks and Components","article_published_time":"2022-05-20T09:20:18+00:00","article_modified_time":"2023-10-03T07:29:34+00:00","og_image":[{"url":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2022\/05\/image-3.png","type":"","width":"","height":""}],"author":"Greytrix","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Greytrix","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2022\/05\/20\/web-api-to-get-sales-order-details-by-customer-no-in-sage-300\/","url":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2022\/05\/20\/web-api-to-get-sales-order-details-by-customer-no-in-sage-300\/","name":"Web API to Get Sales Order Details by Customer No in Sage 300 - Sage 300 ERP \u2013 Tips, Tricks and Components","isPartOf":{"@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2022\/05\/20\/web-api-to-get-sales-order-details-by-customer-no-in-sage-300\/#primaryimage"},"image":{"@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2022\/05\/20\/web-api-to-get-sales-order-details-by-customer-no-in-sage-300\/#primaryimage"},"thumbnailUrl":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2022\/05\/image-3.png","datePublished":"2022-05-20T09:20:18+00:00","dateModified":"2023-10-03T07:29:34+00:00","author":{"@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/#\/schema\/person\/93977cd8aa8fbd1f151d3f664e29c9f2"},"description":"Web Services API plays very important & vital role in Sage 300 ERP as we can import \/ export bulk data entries at one time.","breadcrumb":{"@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2022\/05\/20\/web-api-to-get-sales-order-details-by-customer-no-in-sage-300\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2022\/05\/20\/web-api-to-get-sales-order-details-by-customer-no-in-sage-300\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2022\/05\/20\/web-api-to-get-sales-order-details-by-customer-no-in-sage-300\/#primaryimage","url":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2022\/05\/image-3.png","contentUrl":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2022\/05\/image-3.png"},{"@type":"BreadcrumbList","@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2022\/05\/20\/web-api-to-get-sales-order-details-by-customer-no-in-sage-300\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/"},{"@type":"ListItem","position":2,"name":"Web API to Get Sales Order Details by Customer No in Sage 300"}]},{"@type":"WebSite","@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/#website","url":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/","name":"Sage 300 ERP \u2013 Tips, Tricks and Components","description":"Explore the world of Sage 300 with our insightful blogs, expert tips, and the latest updates. We\u2019ll empower you to leverage Sage 300 to its fullest potential. As your one-stop partner, Greytrix delivers exceptional solutions and integrations for Sage 300. Our blogs extend our support to businesses, covering the latest insights and trends. Dive in and transform your Sage 300 experience with us! ","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/#\/schema\/person\/93977cd8aa8fbd1f151d3f664e29c9f2","name":"Greytrix","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/3cdb553d6ca07df0e407d5e092f2410d163e0fd40b27734b345b04c8f0786969?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/3cdb553d6ca07df0e407d5e092f2410d163e0fd40b27734b345b04c8f0786969?s=96&d=mm&r=g","caption":"Greytrix"},"url":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/author\/greytrix\/"}]}},"_links":{"self":[{"href":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-json\/wp\/v2\/posts\/31286","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-json\/wp\/v2\/comments?post=31286"}],"version-history":[{"count":3,"href":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-json\/wp\/v2\/posts\/31286\/revisions"}],"predecessor-version":[{"id":33301,"href":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-json\/wp\/v2\/posts\/31286\/revisions\/33301"}],"wp:attachment":[{"href":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-json\/wp\/v2\/media?parent=31286"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-json\/wp\/v2\/categories?post=31286"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-json\/wp\/v2\/tags?post=31286"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}