Enhancing a custom screen in Sage X3 with filters and additional columns

With the help X3 we manage production items. This means that we add personalized prints on cups / poster, etc. For managing these production orders we have a custom table [ZPDT] in SQL Server in which all these orders are handled. In X3 theres an existing mask showing information from this table.

In order to improve the production flow we want to establish 3 adjustments:

1. This mask should be extended by following filters: Auftragsnummer and Produktionsplatz, both values are available in ZPDT: ZSOH_0 and PRODPLACE_0

2. In addition the grid should also show the Date of a scan with status 10. this information can be joined via ZPID:

SELECT ZPID_0, CREDATTIM_0
FROM [sageprod].[LIVE].[ZPSTATUS]
WHERE STATID_0 = 10

3. we need the possibility to remove some records of the list. currently we have to delete them via SQL, but it should be possible to cancel single production orders via mask. Therefore a new status canceled should be introduced. we can use the field ZENDFLG_0 for this new status. the canceled orders should also be filterable, but in the regular mask they should be hidden.

We will provide access to a test environment where this feature can be implemented.
About the recuiter
Member since Nov 11, 2022
Archiz 067
from Basque Country, Spain

---

---

Offer to work on this project closes in 13 days!
Are you interested in this Opportunity?

Looking for help? Checkout our video tutorial
How to search and apply for jobs

How to apply? Do you have more questions about the Job?
See frequently asked questions