Skip to Content
0

How to calculate Batch Retest Date based on Retesting Schedule on Item master

May 07 at 11:21 AM

20

avatar image

oitm.png qc.png

Dear Experts,

I create a UDF at Item Master to keep track the retest period of the Item master.

UDF = U_UNE_RTSD (In Months)

Next, I create a FMS at QC Creation screen, QC Retest Date column(UDF on Batch table), the FMS will auto-refresh when user enters Analysis Date.

-------------

SELECT ADD_MONTHS(TO_DATE($["@UNE_QCCHECKHED"."U_UNE_ANDT"],'DD/MM/YY'),t0."U_UNE_RTSD" )
FROM "@UNE_QCCHECKHED"
Inner join t0 oitm t0."ItemCode"= "@UNE_QCCHECKHED"."U_UNE_ITCD"
WHERE "U_UNE_ANDT" > '01/01/01'

---------------------------

Screen shot attached ,Please advice.

Thanks.

Regards,

Danish

oitm.png (233.2 kB)
qc.png (260.3 kB)
SQL
10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

0 Answers