Skip to Content

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

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)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

0 Answers