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

Greytrix has some unique integration solutions developed for Sage CRM with Sage ERPs namely Sage X3Sage IntacctSage 100Sage 500, and Sage 300. 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.

Greytrix is a recognized Sage Champion Partner for GUMU™ Sage X3 – Sage CRM integration listed on Sage Marketplace and Sage CRM – Sage Intacct integration listed on Sage Intacct Marketplace. The GUMU™ Cloud framework 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.

For more information on our integration solutions, please contact us at sage@greytrix.com. We will be glad to assist you.