How to fetch the Work center while printing the report in Sage X3

By | January 29, 2021

Recently there was a requirement in Sage X3 to create a report which will fetch the data on the basis of Work center. In this report we have fetched the Work center wise data and grouped the product with respect to quantity. So we have created the report for Work center which has the filter criteria for work center, site, product and date range.

New Stuff: Validation on Miscellaneous receipt based on Tolerance value

[Report Dictionary-1]
[Report Dictionary-1]

As shown in above screenshot, we have created the new report code in which we have added the filter criteria of date range, product code range, site range and work center range and saved it. When we click on Print button, and then click on finder we will be able to select the product which we wish to print and also select the respective site for the same. But when we click on work center finder, it does not fetch the work centers which are present in the master.

[Report Dictionary-2]
[Report Dictionary-2]

As you can see in the above screenshot, we are unable to fetch the work center when we click on finder. To solve this concern we will be creating a custom data type named “ZWST”.

[Custom Data type - ZWST]
[Custom Data type – ZWST]

In the above screenshot, we have created the custom data type “ZWST” with reference to the standard data type. In Convergence tab, in the Action table, we have added the selection type “SWSTB” which is the standard action code used for work center selection.

[Report Dictionary - 3]
[Report Dictionary – 3]

Further we have saved the changes and validated the data type created and also saved the report code as shown in the above screenshot.

[Work center finder]
[Work center finder]

Thus, once we click on Print button for printing the report we will now be able to select the work centers which are present in the master. As shown in above screenshot, now we are able to fetch work center while printing the 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 Sales Commission App for Sage X3 simplifies commission calculations and postings on sales transactions.

The GUMU™ Cloud framework by Greytrix forms the backbone of cloud integrations that are managed in real-time for processing and execution of application programs at the click of a button.

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 would like to hear from you.