I have always been curious about how EVO get the WIP Variance (JC-M)
This query will show anything that has a "WIP Variance" but how do evo gets the Variance Value?
SELECT
WORKORD.MTWO_WIP_STATUS,
WORKORD.MTWO_WIP_WOPRE,
WORKORD.MTWO_WIP_WOSUF,
WORKORD.MTWO_WIP_DESC,
WORKORD.MTWO_WIP_ATOTAL,
WORECV.MTWOR_REF
FROM WORKORD INNER JOIN WORECV ON (WORKORD.MTWO_WIP_WOSUF = WORECV.MTWOR_WOSUF) AND (WORKORD.MTWO_WIP_WOPRE = WORECV.MTWOR_WOPRE)
WHERE WORKORD.MTWO_WIP_STATUS = 'C'
AND WORECV.MTWOR_REF = 'WIP Variance'
AND WORECV.MTWOR_AVGC <> 0
AND WORKORD.MTWO_WIP_ATOTAL <> 0
Kelloggs