{"id":23154,"date":"2021-08-30T12:00:53","date_gmt":"2021-08-30T12:00:53","guid":{"rendered":"http:\/\/www.greytrix.com\/blogs\/sagex3\/?p=23154"},"modified":"2021-08-30T13:07:48","modified_gmt":"2021-08-30T13:07:48","slug":"mailing-label-from-the-crystal-report","status":"publish","type":"post","link":"https:\/\/www.greytrix.com\/blogs\/sagex3\/2021\/08\/30\/mailing-label-from-the-crystal-report\/","title":{"rendered":"Mailing label from the Crystal Report"},"content":{"rendered":"\n

In Sage X3<\/a>, there various reports in each module which are printed by users whenever applicable. Also for warehouse users it mandatory to print the labels and stick on the products\/Assets. One of our client has requested to design barcode label for their assets in their inventory.<\/p>\n\n\n\n

In this blog, we will see how to print the Barcode Labels by using the Crystal Reports. This report get prints all the labels as per the selected parameter range given by the user. This can be handled by using the \u201cMailing label report wizard\u201d option which is available in the crystal report.<\/p>\n\n\n\n

For this we have created a new custom screen name as \u201cBarcode Generation\u201d, from this screen user can print the barcode report. To print the report, we have created the filter parameter of \u201cFrom Site\u201d and \u201cTo Site\u201d, \u201cFrom Asset and \u201cTo Asset\u201d, \u201cFrom Physical Asset\u201d and \u201cTo Physical Asset\u201d from which user can filters the list of Barcode according to the selected range of the parameters.<\/p>\n\n\n\n

New Stuff:<\/strong> How to do setup and process for loaned products in Sage X3<\/a><\/p>\n\n\n\n

\"Barcode<\/a><\/center>\n
Barcode Generation Screen<\/center><\/font>\n\n\n\n

Follow the steps below:<\/p>\n\n\n\n

Step 1:<\/strong> Open the Crystal Reports<\/p>\n\n\n\n

Step 2:<\/strong> Select the \u201cMailing label report wizard\u201d option, refer the below screenshot:<\/p>\n\n\n\n

\"Home<\/a><\/center>\n
Home Screen<\/center><\/font>\n\n\n\n

Step 3: <\/strong>Go to File -> Page Setup -> Page Option and adjust the size of the page like Margins, Horizontal and Vertical size according to the size of the label paper.
For Example, let\u2019s assume the size of a label sheet is 4 x 1 inches, with 0 margins (left, right, top & bottom) as shown in the below screenshot:<\/p>\n\n\n\n

\"Page<\/a><\/center>\n
Page Setup<\/center><\/font>\n\n\n\n

Step 4: <\/strong>We have to adjust the detail line too, according to the size of the single label and give a gap between the labels. Here let’s assume the size of a single label will be 1.985 X 0.983 in.
To Adjust the size of the detail line: Right click on the Section->Section Expert->Layout.
We can adjust the size of the detail line from the \u201cDetail Size\u201d section and to adjust the gap we have to use the section \u201cGap Between Details\u201d.
We can also give the printing direction from \u201cPrinting Direction\u201d section.
If we want the labels to be printed sideways first and then downwards, then we need to select \u201cAcross then Down\u201d radio button and if we want the labels to be printed downwards first and then sideways then we need to select \u201cDown then Across\u201d radio button.<\/p>\n\n\n\n

\"Section<\/a><\/center>\n
Section Expert<\/center><\/font>\n\n\n\n

Step 5:<\/strong> On the LHS is where we create the desired format for the Barcode, and the same will be displayed on the RHS.<\/p>\n\n\n\n

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

Step 6: <\/strong>Create a group by on the field that gives the barcode, so that each barcode will get printed on a new page. Here we have created a group by based on PHYREF_0 and then created the barcode of the same field.<\/p>\n\n\n\n

To get the Barcode of a field, place the field inside the formula like ‘‘ & {your field} & ‘<\/em>‘ and drag and drop it on the design page.<\/p>\n\n\n\n

\"Formula<\/a><\/center>\n
Formula Editor<\/center><\/font>\n\n\n\n

After that right click on the formula field -> Format Editor, Go to Font section and change the text font to \u201cCode39AzaleaRegular3\u201d. By using this, we will get the field which is converted to the barcode. Refer below screenshot:<\/p>\n\n\n\n

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

Step 7: <\/strong>Once done with the above steps from the crystal report, we have to save the report and deploy the report in the respective folder and then print this report from the screen.<\/p>\n\n\n\n

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

As you can see from the above report output, the barcode is getting printed in \u201cAcross then Down\u201d fashion with the help of Mailing Label option from the crystal 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, there various reports in each module which are printed by users whenever applicable. Also for warehouse users it mandatory to print the labels and stick on the products\/Assets. One of our client has requested to design barcode label for their assets in their inventory. In this blog, we will see how to\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],"tags":[3193,3376,461,3375,3265],"class_list":["post-23154","post","type-post","status-publish","format-standard","hentry","category-integration","category-sage-erp-x3","tag-barcode","tag-barcode-generation","tag-crystal-report","tag-mailing-label","tag-sagex3"],"_links":{"self":[{"href":"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-json\/wp\/v2\/posts\/23154","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=23154"}],"version-history":[{"count":16,"href":"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-json\/wp\/v2\/posts\/23154\/revisions"}],"predecessor-version":[{"id":23269,"href":"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-json\/wp\/v2\/posts\/23154\/revisions\/23269"}],"wp:attachment":[{"href":"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-json\/wp\/v2\/media?parent=23154"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-json\/wp\/v2\/categories?post=23154"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-json\/wp\/v2\/tags?post=23154"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}