{"id":21244,"date":"2020-11-30T14:09:48","date_gmt":"2020-11-30T14:09:48","guid":{"rendered":"http:\/\/www.greytrix.com\/blogs\/sagex3\/?p=21244"},"modified":"2020-11-30T14:11:41","modified_gmt":"2020-11-30T14:11:41","slug":"how-to-add-comment-text-from-transaction-screen-to-the-crystal-report","status":"publish","type":"post","link":"https:\/\/www.greytrix.com\/blogs\/sagex3\/2020\/11\/30\/how-to-add-comment-text-from-transaction-screen-to-the-crystal-report\/","title":{"rendered":"How to add Comment Text from transaction screen to the Crystal Report"},"content":{"rendered":"\n

In Sage X3<\/a>, user have an option to add comment against every transaction screen on right panel after attachment symbol. In this comment field user can enter an additional information as per the requirements for e.g. description, terms & conditions, declaration, note etc. This comment field is considered as a header comment field which is applicable for that particular transaction. Some of our clients has a requirement to print this comment field on the standard or custom report.<\/p>\n\n\n\n

Refer the below screenshot for Comment field.<\/p>\n\n\n\n

New Stuff:<\/strong> How to solve if added tab in window is not visible after global validation of window<\/a><\/p>\n\n\n\n

\"Comment<\/a><\/center>\n
Comment Option<\/center><\/font>\n\n\n\n

By clicking on highlighted symbol you will get a window where user enters text, as shown in the below screenshot:<\/p>\n\n\n\n

\"Comment<\/a><\/center>\n
Comment Window<\/center><\/font>\n\n\n\n

For example, If user have one report name as \u201cPurchase Order Report\u201d and he wanted to print this comment field into this report then we have to follow the steps mentioned below:<\/p>\n\n\n\n

Step 1:<\/strong> Refer below screenshot for SQL Query snippet:<\/p>\n\n\n\n

\"SQL<\/a><\/center>\n
SQL Query<\/center><\/font>\n\n\n\n

Step 2:<\/strong> After adding query for ‘ACLOB’ table in the report we need to add that ‘CLOB’ field (the CLOB field holds the actual comment) into this report wherever we want to add, as shown in the below screenshot.<\/p>\n\n\n\n

\"Crystal<\/a><\/center>\n
Crystal Report<\/center><\/font>\n\n\n\n

Step 3:<\/strong> if the CLOB type is RTF (Rich Text), right click the field added to the report (CLOB_0), select “Format Field”, then select the Paragraph tab, and select the “Text Interpretation” as “RTF Text” and click on \u201cOK\u201d button. Refer below screenshot.<\/p>\n\n\n\n

\"Format<\/a><\/center>\n
Format Field<\/center><\/font>\n\n\n\n

After following above steps, user will able to see those comments in the report whatever user has added into the comment section on transaction level.
<\/p>\n\n\n\n

Refer below screenshot of the sample output.<\/p>\n\n\n\n

\"Output\"<\/a><\/center>\n
Output<\/center><\/font>\n\n\n\n

By following above steps in the crystal report, we will be able to print the comment field from any screen on the particular report.<\/p>\n\n\n\n

About Us<\/strong><\/h2>\n\n\n\n

Greytrix \u2013 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 and expertise, 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 has some unique integration solutions developed for Sage CRM<\/a> with Sage ERPs namely Sage X3<\/a>, Sage Intacct<\/a>, Sage 100<\/a>, Sage 500<\/a>, and Sage 300<\/a>. We also offer best-in-class Sage ERP and Sage CRM customization and development services to Business Partners, End Users, and Sage PSG worldwide. Greytrix helps in the migration of Sage CRM from Salesforce | ACT! | SalesLogix | Goldmine | Sugar CRM | Maximizer. Our Sage CRM Product Suite includes addons like  Greytrix Business Manager, Sage CRM Project Manager, Sage CRM Resource Planner, Sage CRM Contract Manager, Sage CRM Event Manager, Sage CRM Budget Planner, Gmail Integration, Sage CRM Mobile Service Signature, Sage CRM CTI Framework.<\/p>\n\n\n\n

Greytrix is a recognized Sage Champion Partner for GUMU™ Sage X3 \u2013 Sage CRM integration listed on Sage Marketplace<\/a> and Sage CRM \u2013 Sage Intacct integration listed on Sage Intacct Marketplace<\/a>. The GUMU™ Cloud framework<\/a> by Greytrix forms the backbone of cloud integrations that are managed in real-time for the processing and execution of application programs at the click of a button.<\/p>\n\n\n\n

For more information on our integration solutions, please contact us at sage@greytrix.com<\/a>. We will be glad to assist you.<\/p>\n","protected":false},"excerpt":{"rendered":"

In Sage X3, user have an option to add comment against every transaction screen on right panel after attachment symbol. In this comment field user can enter an additional information as per the requirements for e.g. description, terms & conditions, declaration, note etc. This comment field is considered as a header comment field which is\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":[13,8,2796],"tags":[3160,461,1565,3161,1822],"class_list":["post-21244","post","type-post","status-publish","format-standard","hentry","category-integration","category-sage-erp-x3","category-technical","tag-comment-window","tag-crystal-report","tag-purchase-order","tag-rtf-text","tag-sage-x3"],"_links":{"self":[{"href":"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-json\/wp\/v2\/posts\/21244","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-json\/wp\/v2\/comments?post=21244"}],"version-history":[{"count":8,"href":"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-json\/wp\/v2\/posts\/21244\/revisions"}],"predecessor-version":[{"id":21263,"href":"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-json\/wp\/v2\/posts\/21244\/revisions\/21263"}],"wp:attachment":[{"href":"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-json\/wp\/v2\/media?parent=21244"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-json\/wp\/v2\/categories?post=21244"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-json\/wp\/v2\/tags?post=21244"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}