{"id":7720,"date":"2014-05-31T08:47:56","date_gmt":"2014-05-31T08:47:56","guid":{"rendered":"http:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/?p=7720"},"modified":"2014-05-31T08:47:56","modified_gmt":"2014-05-31T08:47:56","slug":"printing-custom-report-from-sage-crm","status":"publish","type":"post","link":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2014\/05\/31\/printing-custom-report-from-sage-crm\/","title":{"rendered":"Printing Custom Sage 300 Report from Sage CRM"},"content":{"rendered":"

There may arise a scenario where one would need to print custom Sage 300 form from Sage CRM. To achieve this, we will need to tweak the standard Sage 300 report printing macro to enable report printing from Sage CRM.
\nIn this blog we will discuss the technical guidelines for amending the additional code required for printing reports from Sage CRM order entry screen.
\nThe New Stuff :<\/strong><\/span> Customize Sage CRM Order screens to promote Orders into Sage 300 ERP<\/a>
\n<\/a>
\nFollow below code snippet:
\nStep1:<\/strong> Define the Variable in general declaration section:
\n<SNIP >
\nDim temp As Boolean
\nDim rpt As AccpacReport
\nDim rptPrintSetup As AccpacPrintSetup
\nDim session As AccpacSession
\nDim newdblink As AccpacDBLink
\nDim printrpt As AccpacPrintReport
\n<\/SNIP >
\nStep 2:<\/strong> Calling our Custom Report \u201cOEPICK01.rpt\u201d
\n<SNIP >
\nSet newdblink = adsOEORDH.DBLink
\nSet session = adsOEORDH.DBLink.session
\nSet rpt = session.ReportSelect(“OEPICK01[C:\\Program Files\\Sage\\Sage 300 ERP\\OE61A\\ENG\\OEPBPICK.RPT]”, ”\u00a0\u00a0\u00a0\u00a0\u00a0 “, ”\u00a0\u00a0\u00a0\u00a0\u00a0 “)
\nrpt.SetParam “SELECTBY”, “0”\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 ‘ Report parameter: 2
\nrpt.SetParam “SORTBY”, “0”\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 ‘ Report parameter: 3
\nrpt.SetParam “FROMSELECT”,\u00a0\u00a0 ‘ Report parameter: 4
\nrpt.SetParam “TOSELECT”,\u00a0\u00a0 ‘ Report parameter: 5
\nrpt.SetParam “FROMLOC”, ” ”\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 ‘ Report parameter: 6
\nrpt.SetParam “TOLOC”, “ZZZZZZ”\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 ‘ Report parameter: 7
\nrpt.SetParam “PRINTBY”, “0”\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 ‘ Report parameter: 14
\nrpt.SetParam “SERIALLOTNUMBERS”, “1”\u00a0\u00a0\u00a0\u00a0 ‘ Report parameter: 15
\nrpt.SetParam “PRINTKIT”, “1”\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 ‘ Report parameter: 11
\nrpt.SetParam “PRINTBOM”, “1”\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 ‘ Report parameter: 12
\nrpt.SetParam “REPRINT”, “1”\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 ‘ Report parameter: 8
\nrpt.SetParam “QTYDEC”, “0”\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 ‘ Report parameter: 9 – O\/E Sales History:Detail,Sort by\u00a0\u00a0 Item Number
\nrpt.SetParam “COMPLETED”, “0”\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 ‘ Report parameter: 10
\nrpt.SetParam “SESHNDL”, “1454615”\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 ‘ Report parameter: 13
\nrpt.NumOfCopies = 1
\nrpt.Destination = PD_FILE
\nrpt.Format = PF_PDF
\ntemp = rpt.PrintReport
\nSet printrpt = New AccpacPrintReport
\nprintrpt.ReportViewer session, rpt.WebReportURL
\n<\/SNIP >
\nIn the Order Entry screen we have implemented the same code on the click of the \u201cPrint forms\u201d button as shown below.<\/p>\n

\"Order<\/a><\/p>\n

Using the above code you can easily print the custom report from the Sage CRM.<\/p>\n

\"Printing_Report\"<\/a><\/p>\n

Also Read:<\/strong>
\n1. Update Bill-To-Address and Ship-To Address on OE Order Entry Screen<\/a>
\n2. Populate Items on Order Entry Screen using Template Code<\/a>
\n3. Template feature for Order Entry in Sage 300 ERP<\/a>
\n4. Open Orders Inquiry for Sage 300 ERP Order Entry Screen<\/a>
\n5. Generate BOM and Kitting items on the fly from Order Entry screen in Sage 300 ERP<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"

There may arise a scenario where one would need to print custom Sage 300 form from Sage CRM. To achieve this, we will need to tweak the standard Sage 300 report printing macro to enable report printing from Sage CRM. In this blog we will discuss the technical guidelines for amending the additional code required\u2026 Read More »<\/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":[2],"tags":[79,643,2311,2324,2475,2497],"class_list":["post-7720","post","type-post","status-publish","format-standard","hentry","category-sage-accpac","tag-accpac","tag-custom-report-from-sage-crm","tag-sage","tag-sage-300","tag-sage-crm","tag-sage-integrated-crm"],"yoast_head":"\nPrinting Custom Sage 300 Report from Sage CRM - Sage 300 ERP \u2013 Tips, Tricks and Components<\/title>\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\/2014\/05\/31\/printing-custom-report-from-sage-crm\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Printing Custom Sage 300 Report from Sage CRM - Sage 300 ERP \u2013 Tips, Tricks and Components\" \/>\n<meta property=\"og:description\" content=\"There may arise a scenario where one would need to print custom Sage 300 form from Sage CRM. To achieve this, we will need to tweak the standard Sage 300 report printing macro to enable report printing from Sage CRM. In this blog we will discuss the technical guidelines for amending the additional code required\u2026 Read More »\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2014\/05\/31\/printing-custom-report-from-sage-crm\/\" \/>\n<meta property=\"og:site_name\" content=\"Sage 300 ERP \u2013 Tips, Tricks and Components\" \/>\n<meta property=\"article:published_time\" content=\"2014-05-31T08:47:56+00:00\" \/>\n<meta property=\"og:image\" content=\"http:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2014\/05\/Order-Entry.jpg\" \/>\n<meta name=\"author\" content=\"sage300\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"sage300\" \/>\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\/2014\/05\/31\/printing-custom-report-from-sage-crm\/\",\"url\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2014\/05\/31\/printing-custom-report-from-sage-crm\/\",\"name\":\"Printing Custom Sage 300 Report from Sage CRM - 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\/2014\/05\/31\/printing-custom-report-from-sage-crm\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2014\/05\/31\/printing-custom-report-from-sage-crm\/#primaryimage\"},\"thumbnailUrl\":\"http:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2014\/05\/Order-Entry.jpg\",\"datePublished\":\"2014-05-31T08:47:56+00:00\",\"author\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/#\/schema\/person\/1aced4e22c30ccf606960de27c9542f5\"},\"breadcrumb\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2014\/05\/31\/printing-custom-report-from-sage-crm\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2014\/05\/31\/printing-custom-report-from-sage-crm\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2014\/05\/31\/printing-custom-report-from-sage-crm\/#primaryimage\",\"url\":\"http:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2014\/05\/Order-Entry.jpg\",\"contentUrl\":\"http:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2014\/05\/Order-Entry.jpg\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2014\/05\/31\/printing-custom-report-from-sage-crm\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Printing Custom Sage 300 Report from Sage CRM\"}]},{\"@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\/1aced4e22c30ccf606960de27c9542f5\",\"name\":\"sage300\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/#\/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\":\"sage300\"},\"url\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/author\/sageaccpac\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Printing Custom Sage 300 Report from Sage CRM - Sage 300 ERP \u2013 Tips, Tricks and Components","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\/2014\/05\/31\/printing-custom-report-from-sage-crm\/","og_locale":"en_US","og_type":"article","og_title":"Printing Custom Sage 300 Report from Sage CRM - Sage 300 ERP \u2013 Tips, Tricks and Components","og_description":"There may arise a scenario where one would need to print custom Sage 300 form from Sage CRM. To achieve this, we will need to tweak the standard Sage 300 report printing macro to enable report printing from Sage CRM. In this blog we will discuss the technical guidelines for amending the additional code required\u2026 Read More »","og_url":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2014\/05\/31\/printing-custom-report-from-sage-crm\/","og_site_name":"Sage 300 ERP \u2013 Tips, Tricks and Components","article_published_time":"2014-05-31T08:47:56+00:00","og_image":[{"url":"http:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2014\/05\/Order-Entry.jpg","type":"","width":"","height":""}],"author":"sage300","twitter_card":"summary_large_image","twitter_misc":{"Written by":"sage300","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2014\/05\/31\/printing-custom-report-from-sage-crm\/","url":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2014\/05\/31\/printing-custom-report-from-sage-crm\/","name":"Printing Custom Sage 300 Report from Sage CRM - 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\/2014\/05\/31\/printing-custom-report-from-sage-crm\/#primaryimage"},"image":{"@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2014\/05\/31\/printing-custom-report-from-sage-crm\/#primaryimage"},"thumbnailUrl":"http:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2014\/05\/Order-Entry.jpg","datePublished":"2014-05-31T08:47:56+00:00","author":{"@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/#\/schema\/person\/1aced4e22c30ccf606960de27c9542f5"},"breadcrumb":{"@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2014\/05\/31\/printing-custom-report-from-sage-crm\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2014\/05\/31\/printing-custom-report-from-sage-crm\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2014\/05\/31\/printing-custom-report-from-sage-crm\/#primaryimage","url":"http:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2014\/05\/Order-Entry.jpg","contentUrl":"http:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2014\/05\/Order-Entry.jpg"},{"@type":"BreadcrumbList","@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2014\/05\/31\/printing-custom-report-from-sage-crm\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/"},{"@type":"ListItem","position":2,"name":"Printing Custom Sage 300 Report from Sage CRM"}]},{"@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\/1aced4e22c30ccf606960de27c9542f5","name":"sage300","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/#\/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":"sage300"},"url":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/author\/sageaccpac\/"}]}},"_links":{"self":[{"href":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-json\/wp\/v2\/posts\/7720","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\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-json\/wp\/v2\/comments?post=7720"}],"version-history":[{"count":0,"href":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-json\/wp\/v2\/posts\/7720\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-json\/wp\/v2\/media?parent=7720"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-json\/wp\/v2\/categories?post=7720"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-json\/wp\/v2\/tags?post=7720"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}