Production Calendar Error When Drag And Drop.
Hi
When I drag and drop production orders I get the below error which relates to the routing date in table wor4.
"Drag and Drop Action failed Starter date must be later than or the same as the document start date (wor4.startdate)line1
Is there a work around to this. After testing the drag and drop action does in some cases update the route stage date but not always.
I am using Version 202.06. The SQL source is as per the below.
SELECT distinct
T0.DocEntry AS 'PrimaryKey',
T0.ObjType AS 'ObjectType',
T0.StartDate AS 'StartDate',
T0.DueDate AS 'EndDate',
CONCAT(T0.DocNum, N' of Item ''',T0.ItemCode, N''' - Quantity: ', CAST(T0.PlannedQty AS INT),' - Labour Hrs ',cast(sum(T1.[PlannedQty])as decimal (10,2))) AS 'Subject',
CASE T0.Status
WHEN 'P' THEN 'Planned'
WHEN 'R' THEN 'Released'
END AS 'Location'
FROM OWOR T0 INNER JOIN WOR1 T1 ON T0.[DocEntry] = T1.[DocEntry] AND T1.[ItemType] = 290
WHERE (@StartDate BETWEEN T0.StartDate AND T0.DueDate OR T0.StartDate BETWEEN @StartDate AND @EndDate OR T0.DueDate BETWEEN @StartDate AND @EndDate)
AND T0.Status IN ('R') and T0.[ItemCode] not Like 'pcbas%%' and T0.[U_Scheduled] = 'YES' and CONVERT(int,ROUND((t0.CmpltQty * 100)/t0.PlannedQty,0)) < 90
Group by T0.DocEntry, T0.ObjType, T0.StartDate, T0.DueDate, T0.DocNum, T0.ItemCode, T0.PlannedQty, T0.Status
Order by t0.docentry
Iniciar sesión para dejar un comentario.
Comentarios
0 comentarios