Quality Date Approval

[Arthur Wang]

Question:

 

Our Plant runs 24×7.  We are making missing quantity report in which we are picking requirement date from RESB table, but Quality department works for 24×5 and quality people want that Lab approval date should be 7 days before requirement date from RESB so that they can analyze the materials in time. We cannot subtract 7 directly from requirement date as we have weekend offs and holidays so how we can make lab approval date dynamic?   In case we only want to include Saturday and Sunday off for quality department only and 7 days working for Plant then how we can make approval field dynamic.

 

Answer:

 

There are no standard solution for this.  In this case, you can try developing a new report based on RESB requirement date validating with factory calendar information (exclude holidays and week off).

 

Use function module HOLIDAY_CHECK_AND_GET_INFO

 

Regarding approval process either you can validate Requirement date with Factory calendar as suggested above or if this behavior should work for Quality users only, then build a Logic where Quality users will be maintained in a Z table against plant and include your Logic say [X(req. date )-5 ]days for QA approval.

[Author]

Posts