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.