Mailing label from the Crystal Report

In Sage X3, we have created a new custom screen name as “Barcode Generation”, from this screen user can print the barcode report. To print the report, we have create the filter parameter of “From Site” and “To Site”, “From Asset and “To Asset”, “From Physical Asset” and “To Physical Asset” from which user can filters the list of Barcode according to the selected range of the parameters.

New Stuff: How to do setup and process for loaned products in Sage X3

Barcode Generation Screen
Barcode Generation Screen

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 handle by using the “Mailing label report wizard” option which is available in the crystal report.

Follow the steps below:

Step 1: Open the Crystal Reports

Step 2: Select the “Mailing label report wizard” option, refer the below screenshot:

Home Screen
Home Screen

Step 3: 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’s 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:

Page Setup
Page Setup

Step 4: 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 “Detail Size” section and to adjust the gap we have to use the section “Gap Between Details”.
We can also give the printing direction from “Printing Direction” section.
If we want the labels to be printed sideways first and then downwards, then we need to select “Across then Down” radio button and if we want the labels to be printed downwards first and then sideways then we need to select “Down then Across” radio button.

Section Expert
Section Expert

Step 5: On the LHS is where we create the desired format for the Barcode, and the same will be displayed on the RHS.

Design
Design

Step 6: 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.

To get the Barcode of a field, place the field inside the formula like ‘‘ & {your field} & ‘‘ and drag and drop it on the design page.

Formula Editor
Formula Editor

After that right click on the formula field -> Format Editor, Go to Font section and change the text font to “Code39AzaleaRegular3”. By using this, we will get the field which is converted to the barcode. Refer below screenshot:

Format Editor
Format Editor

Step 7: 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.

Output
Output

As you can see from the above report output, the barcode is getting printed in “Across then Down” fashion with the help of Mailing Label option from the crystal report.

About Us

Greytrix – a globally recognized and one of the oldest Sage Development Partner 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.

Greytrix caters to a wide range of Sage X3, a Sage Business Cloud Solution, offerings. Our unique GUMU™ integrations include Sage X3 for Sage CRMSalesforce.com, Dynamics 365 CRM and Magento eCommerce along with Implementation and Technical Support worldwide for Sage X3. Currently we are Sage X3 Implementation Partner in East Africa, Middle East, Australia, Asia, US, UK. We also offer best-in-class Sage X3 customization and development services, integrated applications such as POS | WMS | Payment Gateway | Shipping System | Business Intelligence | eCommerce and have developed add-ons such as Catch – Weight  and Letter of Credit and India Legislation for Sage X3 to Sage business partners, end users and Sage PSG worldwide.

Greytrix is a recognized Sage champion ISV Partner for GUMU™ Sage X3 – Sage CRM integration also listed on Sage Marketplace; GUMU™ integration for Sage X3 – Salesforce is a 5-star rated app listed on Salesforce AppExchange and GUMU™ integration for Dynamics 365 CRM – Sage ERP listed on Microsoft AppSource.

For more information on Sage X3 Integration and Services, please contact us at x3@greytrix.com, We will like to hear from you.