Skip to Content
0

Auto calculate Batch Retest Date

Jan 11 at 06:52 AM

32

avatar image

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

10 |10000 characters needed characters left characters exceeded

or second

0

Cannot see the screenshot

0
* Please Login or Register to Answer, Follow or Comment.

0 Answers