How to assign report Destination based on condition

By | September 27, 2019

We may come under a situation where we have to set different destination according to the user or we have to set a destination for a user based on a particular condition.

To set different destination based on user we can simply define this in :

All -> Setup -> Destination -> Destination by user

Now, to set destinations for a user based on a particular condition, follow the below steps:

  • Navigate to All -> Setup -> Destination -> Destination by user
  • Add a condition in ‘Additional information’ field as this field has the higest priority while printing.
  • This field is linked with the ‘Add info formula’ field which is present in Report code screen.
  • In this field, set the parameter which is associated with the value we have added in the ‘Additional information’ field.

For example :

  • We want to set ‘PREVIEW’ destination by default if the sales order site is ‘FR011’.
  • We have added the value of site in ‘Additional information’ field as shown in below.
Destinations by user screen.
Fig: Additional information’ field
  • Now we will define the parameter of this value in ‘Add info formula’ field which is present in Report code as shown below.
add info formula field
Fig: Setting parameter in ‘Add info formula’ field

General Parameter screen.
Fig: Destination modified
  • Hence, when we print the report in which the site is ‘FR011’. The system will use the ‘PREVIEW’ as destination as shown in the above figure.

Hope this works.

About Us
Greytrix – a globally recognized Premier Sage Gold Development Partner is a one-stop solution provider for Sage ERP and Sage CRM needs. Being recognized 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 expertise.

Greytrix caters to a wide range of Sage Enterprise Management (Sage X3) offerings – a Sage Business Cloud Solution. Our unique GUMU™ integrations include Sage X3 for Sage and Magento eCommerce along with Implementation and Technical Support worldwide for Sage X3 (Sage Enterprise Management). Currently we are Sage X3 Implementation Partner in East Africa, Middles East, Australia, Asia. 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 for Sage X3 to Sage business partners, end users and Sage PSG worldwide.

Greytrix is a recognized Sage Rockstar ISV Partner for GUMU™ Sage X3 – Sage CRM integration also listed on Sage Marketplace; GUMU™ integration for Sage X3 – Salesforce is a 5-star app listed on Salesforce AppExchange.

For more information on Sage X3 Integration and Services, please contact us at We will be glad to assist you.