Skip to Content

Auto calculate Batch Retest Date

Dear Experts,

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

UDF = U_UNE_RTSD

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

SELECT ADD_DAYS(ADD_DAYS('1900-01-01 00:00:00.000', $[OBTN."InDate".date]), CAST(A1."U_UNE_RTSD" AS integer))
FROM OITM A1
INNER JOIN OBTN A2 ON A1."ItemCode" = A2."ItemCode"

Screen shot attached ,Please advice.

Thanks.

Regards,

Danish

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

0 Answers