Skip to Content
0
Former Member
Feb 22, 2017 at 02:47 PM

Validation Formule for expiration date in PI sheet

95 Views

Hi,

We have a requirement to validate that the components materials those are going o consume is not expired during PI sheet execution date. SLED is implemented and getting SLED date in browser based PI sheet. Now to make validation, we have tried 2 ways

1. using formula VDATE 0001 (Staging date) > VWRT001PPPI_BATCH...here for non expired material also it is showing error message as internal error in formul VDATE>VWRT001

2. tried to calculate duration between staging date and SLED usng FM:

COPF_DETERMINE_DURATION...then validating whether it is greater than zero or not. here error is internal date error (YYYYMMDD).

Assume method 1 is easy, but please help if you face the same issue.

Thanks

Krish