Find more Network And System Administration Remote Jobs posted recently Worldwide

Required Sage X3,Application Programming,Microsoft SQL Server freelancer for Sage X3 expert needed for production management job

Posted at - Jan 20, 2023

Toogit Instant Connect Enabled


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 May 20, 2018 Terry Whin Yate
from Bali, Indonesia

Skills & Expertise Required

Sage X3 Application Programming Microsoft SQL Server 

Candidate shortlisted and hired
Hiring open till - Feb 21, 2023

Work from Anywhere
40 hrs / week
Hourly Type
Remote Job
$19.20
Cost

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


Apply on more work from home jobs posted in Network And System Administration category.