{"id":109,"date":"2009-08-25T06:54:00","date_gmt":"2009-08-25T06:54:00","guid":{"rendered":"http:\/\/www.greytrix.com\/blogs\/sagemas\/?p=109"},"modified":"2024-06-14T04:56:10","modified_gmt":"2024-06-14T04:56:10","slug":"display-sales-order-number-on-invoice-printing","status":"publish","type":"post","link":"https:\/\/www.greytrix.com\/blogs\/sagemas\/2009\/08\/25\/display-sales-order-number-on-invoice-printing\/","title":{"rendered":"Display Sales Order Number on Invoice Printing"},"content":{"rendered":"<p>In MAS 500 system, Invoice printing form does not displays the original Sales Order Number. Also there is no such report in Account Receivable menu to show such information. Due to this, it is difficult for users to identify for which Sales order this Invoice is associated.<\/p>\n<p>We at Greytrix have added the Sales Order number on Invoice printing report. By this Sales Order number is printed at header level of the Invoice report. Please refer the below mentioned steps.<\/p>\n<p><a href=\"http:\/\/4.bp.blogspot.com\/_A6_b0zkYeSY\/SpOLGG6-qVI\/AAAAAAAAAis\/RvHSjHPmMBA\/s1600-h\/SO.bmp\"><img fetchpriority=\"high\" decoding=\"async\" id=\"BLOGGER_PHOTO_ID_5373791717436598610\" class=\"alignnone\" style=\"display: block; margin: 0px auto 10px; text-align: center; cursor: hand; width: 320px; height: 225px;\" title=\"Tax Invoice\" src=\"http:\/\/4.bp.blogspot.com\/_A6_b0zkYeSY\/SpOLGG6-qVI\/AAAAAAAAAis\/RvHSjHPmMBA\/s320\/SO.bmp\" alt=\"Tax Invoice\" width=\"320\" height=\"225\" border=\"0\" \/><\/a>If user has little bit knowledge of crystal report then he can achieve this functionality by modifying the crystal report. To modify the crystal report user need to follow the below mentioned steps.<\/p>\n<p>Add the following real table to crystal report (ARZTC001.rpt).<\/p>\n<ul>\n<li>tsoSalesOrder<\/li>\n<li>tsoSOLine<\/li>\n<li>tarInvoiceDetl<\/li>\n<\/ul>\n<p>Link the tables as follows:<\/p>\n<ul>\n<li>tsoSalesOrder.SOkey= tsoSOLine.SOkey<\/li>\n<li>tsoSOLine.SOLineKey= tarInvoiceDetl. SOLineKey<\/li>\n<li>tarPrintInvcHdrWrk.InvcKey= tarInvoiceDetl.InvcKey<\/li>\n<\/ul>\n<p>Add the \u2018TranNo\u2019 field from \u2018tsoSalesOrder\u2019 table on the crystal report at header.<\/p>\n<p>If you do not want to reinvent the wheel and want this already developed report at no cost, send a request via your reseller partner to us at\u00a0<a href=\"mailto:sage@greytrix.com\">sage@greytrix.com<\/a>.<\/p>\n<p><strong>About Us<\/strong><br \/>\n<a href=\"https:\/\/www.greytrix.com\/\">Greytrix<\/a>\u00a0is a one stop solution provider for Sage ERP and Sage CRM needs. We provide complete end-to-end assistance for your technical consultations, product customizations, data migration, system integrations, third party add-on development and implementation expertise.<\/p>\n<p>Greytrix\u00a0has some unique solutions of\u00a0<a href=\"https:\/\/www.greytrix.com\/product\/sage-crm\/gumu-sage-100-erp-integration\">Sage 100 integration with Sage CRM<\/a>,\u00a0and\u00a0<a href=\"https:\/\/www.greytrix.com\/product\/sage-100-erp\/gumu-100-salesforce-integration\">Salesforce.com<\/a>\u00a0along with\u00a0<a href=\"https:\/\/www.greytrix.com\/product\/sage-100-erp\/sage-50-us-sage-100-migration\">Sage 100 Migration from Sage 50 US<\/a>,\u00a0<a href=\"https:\/\/www.greytrix.com\/product\/intacct-apps-and-products\/gumu-sage-intacct-sage-100-migration\">Sage Intacct<\/a>,\u00a0<a href=\"https:\/\/www.greytrix.com\/product\/sage-100-erp\/quickbooks-sage-100-migration\">QuickBooks<\/a>, Sage Business Vision and Sage Business Works. We also offer best-in-class\u00a0<a href=\"https:\/\/www.greytrix.com\/product\/erp-development\/sage-100-erp\">Sage 100 customization and development services\u00a0<\/a>to Sage business partners, end users, and Sage PSG worldwide.<\/p>\n<p>For more details on Sage 100 Services, please contact us at\u00a0<a href=\"mailto:sage@greytrix.com\">sage@greytrix.com<\/a>. We will be glad to assist you.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>In MAS 500 system, Invoice printing form does not displays the original Sales Order Number. Also there is no such report in Account Receivable menu to show such information. Due to this, it is difficult for users to identify for which Sales order this Invoice is associated. We at Greytrix have added the Sales Order\u2026 <span class=\"read-more\"><a href=\"https:\/\/www.greytrix.com\/blogs\/sagemas\/2009\/08\/25\/display-sales-order-number-on-invoice-printing\/\">Read More &raquo;<\/a><\/span><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[4,191,213],"tags":[],"class_list":["post-109","post","type-post","status-publish","format-standard","hentry","category-accounts-receivable","category-sales-order","category-tips"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v26.3 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Show Sales Order Number When Printing an Invoice<\/title>\n<meta name=\"description\" content=\"Find out more about the number that appears in the invoice report&#039;s header. Please refer to the steps listed below.\" \/>\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\/sagemas\/2009\/08\/25\/display-sales-order-number-on-invoice-printing\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Show Sales Order Number When Printing an Invoice\" \/>\n<meta property=\"og:description\" content=\"Find out more about the number that appears in the invoice report&#039;s header. Please refer to the steps listed below.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.greytrix.com\/blogs\/sagemas\/2009\/08\/25\/display-sales-order-number-on-invoice-printing\/\" \/>\n<meta property=\"og:site_name\" content=\"GUMU\u2122 Integrations \u2013 Tips, Tricks and Components\" \/>\n<meta property=\"article:published_time\" content=\"2009-08-25T06:54:00+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-06-14T04:56:10+00:00\" \/>\n<meta property=\"og:image\" content=\"http:\/\/4.bp.blogspot.com\/_A6_b0zkYeSY\/SpOLGG6-qVI\/AAAAAAAAAis\/RvHSjHPmMBA\/s320\/SO.bmp\" \/>\n<meta name=\"author\" content=\"greysagemas\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"greysagemas\" \/>\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\/sagemas\/2009\/08\/25\/display-sales-order-number-on-invoice-printing\/\",\"url\":\"https:\/\/www.greytrix.com\/blogs\/sagemas\/2009\/08\/25\/display-sales-order-number-on-invoice-printing\/\",\"name\":\"Show Sales Order Number When Printing an Invoice\",\"isPartOf\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagemas\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagemas\/2009\/08\/25\/display-sales-order-number-on-invoice-printing\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagemas\/2009\/08\/25\/display-sales-order-number-on-invoice-printing\/#primaryimage\"},\"thumbnailUrl\":\"http:\/\/4.bp.blogspot.com\/_A6_b0zkYeSY\/SpOLGG6-qVI\/AAAAAAAAAis\/RvHSjHPmMBA\/s320\/SO.bmp\",\"datePublished\":\"2009-08-25T06:54:00+00:00\",\"dateModified\":\"2024-06-14T04:56:10+00:00\",\"author\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagemas\/#\/schema\/person\/b57e6e3564a12ef62967850ae0416728\"},\"description\":\"Find out more about the number that appears in the invoice report's header. Please refer to the steps listed below.\",\"breadcrumb\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagemas\/2009\/08\/25\/display-sales-order-number-on-invoice-printing\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.greytrix.com\/blogs\/sagemas\/2009\/08\/25\/display-sales-order-number-on-invoice-printing\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagemas\/2009\/08\/25\/display-sales-order-number-on-invoice-printing\/#primaryimage\",\"url\":\"http:\/\/4.bp.blogspot.com\/_A6_b0zkYeSY\/SpOLGG6-qVI\/AAAAAAAAAis\/RvHSjHPmMBA\/s320\/SO.bmp\",\"contentUrl\":\"http:\/\/4.bp.blogspot.com\/_A6_b0zkYeSY\/SpOLGG6-qVI\/AAAAAAAAAis\/RvHSjHPmMBA\/s320\/SO.bmp\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagemas\/2009\/08\/25\/display-sales-order-number-on-invoice-printing\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.greytrix.com\/blogs\/sagemas\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Display Sales Order Number on Invoice Printing\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagemas\/#website\",\"url\":\"https:\/\/www.greytrix.com\/blogs\/sagemas\/\",\"name\":\"GUMU\u2122 Integrations \u2013 Tips, Tricks and Components\",\"description\":\"Welcome to the GUMU\u2122 blog, your one-stop source to gain all the insights on seamless integration solutions for ERP and CRM systems. Developed by Greytrix, GUMU\u2122 is a powerful integration platform that bridges the gap between your business applications. Whether you\u2019re looking to integrate a CRM (Salesforce, Dynamics 365 CRM, and Sage CRM) or an ERP (Sage ERP, Acumatica) with each other or any other third-party application, GUMU\u2122 is a robust and reliable integrator tailored to your unique needs. Join us as we explore the abilities of GUMU\u2122 and learn how it transforms your integration experience. \",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.greytrix.com\/blogs\/sagemas\/?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\/sagemas\/#\/schema\/person\/b57e6e3564a12ef62967850ae0416728\",\"name\":\"greysagemas\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagemas\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/c3b4325cb326e36467f945b9b9adf2bb85e907fe092d42eb36b39743b492e626?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/c3b4325cb326e36467f945b9b9adf2bb85e907fe092d42eb36b39743b492e626?s=96&d=mm&r=g\",\"caption\":\"greysagemas\"},\"url\":\"https:\/\/www.greytrix.com\/blogs\/sagemas\/author\/greysagemas\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Show Sales Order Number When Printing an Invoice","description":"Find out more about the number that appears in the invoice report's header. Please refer to the steps listed below.","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\/sagemas\/2009\/08\/25\/display-sales-order-number-on-invoice-printing\/","og_locale":"en_US","og_type":"article","og_title":"Show Sales Order Number When Printing an Invoice","og_description":"Find out more about the number that appears in the invoice report's header. Please refer to the steps listed below.","og_url":"https:\/\/www.greytrix.com\/blogs\/sagemas\/2009\/08\/25\/display-sales-order-number-on-invoice-printing\/","og_site_name":"GUMU\u2122 Integrations \u2013 Tips, Tricks and Components","article_published_time":"2009-08-25T06:54:00+00:00","article_modified_time":"2024-06-14T04:56:10+00:00","og_image":[{"url":"http:\/\/4.bp.blogspot.com\/_A6_b0zkYeSY\/SpOLGG6-qVI\/AAAAAAAAAis\/RvHSjHPmMBA\/s320\/SO.bmp","type":"","width":"","height":""}],"author":"greysagemas","twitter_card":"summary_large_image","twitter_misc":{"Written by":"greysagemas","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.greytrix.com\/blogs\/sagemas\/2009\/08\/25\/display-sales-order-number-on-invoice-printing\/","url":"https:\/\/www.greytrix.com\/blogs\/sagemas\/2009\/08\/25\/display-sales-order-number-on-invoice-printing\/","name":"Show Sales Order Number When Printing an Invoice","isPartOf":{"@id":"https:\/\/www.greytrix.com\/blogs\/sagemas\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.greytrix.com\/blogs\/sagemas\/2009\/08\/25\/display-sales-order-number-on-invoice-printing\/#primaryimage"},"image":{"@id":"https:\/\/www.greytrix.com\/blogs\/sagemas\/2009\/08\/25\/display-sales-order-number-on-invoice-printing\/#primaryimage"},"thumbnailUrl":"http:\/\/4.bp.blogspot.com\/_A6_b0zkYeSY\/SpOLGG6-qVI\/AAAAAAAAAis\/RvHSjHPmMBA\/s320\/SO.bmp","datePublished":"2009-08-25T06:54:00+00:00","dateModified":"2024-06-14T04:56:10+00:00","author":{"@id":"https:\/\/www.greytrix.com\/blogs\/sagemas\/#\/schema\/person\/b57e6e3564a12ef62967850ae0416728"},"description":"Find out more about the number that appears in the invoice report's header. Please refer to the steps listed below.","breadcrumb":{"@id":"https:\/\/www.greytrix.com\/blogs\/sagemas\/2009\/08\/25\/display-sales-order-number-on-invoice-printing\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.greytrix.com\/blogs\/sagemas\/2009\/08\/25\/display-sales-order-number-on-invoice-printing\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.greytrix.com\/blogs\/sagemas\/2009\/08\/25\/display-sales-order-number-on-invoice-printing\/#primaryimage","url":"http:\/\/4.bp.blogspot.com\/_A6_b0zkYeSY\/SpOLGG6-qVI\/AAAAAAAAAis\/RvHSjHPmMBA\/s320\/SO.bmp","contentUrl":"http:\/\/4.bp.blogspot.com\/_A6_b0zkYeSY\/SpOLGG6-qVI\/AAAAAAAAAis\/RvHSjHPmMBA\/s320\/SO.bmp"},{"@type":"BreadcrumbList","@id":"https:\/\/www.greytrix.com\/blogs\/sagemas\/2009\/08\/25\/display-sales-order-number-on-invoice-printing\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.greytrix.com\/blogs\/sagemas\/"},{"@type":"ListItem","position":2,"name":"Display Sales Order Number on Invoice Printing"}]},{"@type":"WebSite","@id":"https:\/\/www.greytrix.com\/blogs\/sagemas\/#website","url":"https:\/\/www.greytrix.com\/blogs\/sagemas\/","name":"GUMU\u2122 Integrations \u2013 Tips, Tricks and Components","description":"Welcome to the GUMU\u2122 blog, your one-stop source to gain all the insights on seamless integration solutions for ERP and CRM systems. Developed by Greytrix, GUMU\u2122 is a powerful integration platform that bridges the gap between your business applications. Whether you\u2019re looking to integrate a CRM (Salesforce, Dynamics 365 CRM, and Sage CRM) or an ERP (Sage ERP, Acumatica) with each other or any other third-party application, GUMU\u2122 is a robust and reliable integrator tailored to your unique needs. Join us as we explore the abilities of GUMU\u2122 and learn how it transforms your integration experience. ","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.greytrix.com\/blogs\/sagemas\/?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\/sagemas\/#\/schema\/person\/b57e6e3564a12ef62967850ae0416728","name":"greysagemas","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.greytrix.com\/blogs\/sagemas\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/c3b4325cb326e36467f945b9b9adf2bb85e907fe092d42eb36b39743b492e626?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/c3b4325cb326e36467f945b9b9adf2bb85e907fe092d42eb36b39743b492e626?s=96&d=mm&r=g","caption":"greysagemas"},"url":"https:\/\/www.greytrix.com\/blogs\/sagemas\/author\/greysagemas\/"}]}},"_links":{"self":[{"href":"https:\/\/www.greytrix.com\/blogs\/sagemas\/wp-json\/wp\/v2\/posts\/109","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.greytrix.com\/blogs\/sagemas\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.greytrix.com\/blogs\/sagemas\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sagemas\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sagemas\/wp-json\/wp\/v2\/comments?post=109"}],"version-history":[{"count":2,"href":"https:\/\/www.greytrix.com\/blogs\/sagemas\/wp-json\/wp\/v2\/posts\/109\/revisions"}],"predecessor-version":[{"id":4951,"href":"https:\/\/www.greytrix.com\/blogs\/sagemas\/wp-json\/wp\/v2\/posts\/109\/revisions\/4951"}],"wp:attachment":[{"href":"https:\/\/www.greytrix.com\/blogs\/sagemas\/wp-json\/wp\/v2\/media?parent=109"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sagemas\/wp-json\/wp\/v2\/categories?post=109"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sagemas\/wp-json\/wp\/v2\/tags?post=109"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}