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 there's 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 recuiterMember since Nov 11, 2022 Archiz 067
from Basque Country, Spain