Fetching the latest drawing No. after changing Sampling Drawing Procedure

[former_member620323]

Hi QM Masters,

I have 1 Report in that I fetch Drawing No. against Inspection Lot.

When I create a Inspection Lot at that time Drawing No. will generated in the system. Sampling Drawing procedure is assigned to the Lot. But the problem is that When I change the sampling procedure New Drawing No. is generated against the same lot.

Both Drawing No. are updated in QPRS table against the same lot. That's why It is difficult to fetch the latest Drawing no.

How I fetch the latest drawing no. after changing the SDP?

Gives me the Expert logic to fetch the data.

[Former Member]

Hi can you check the fields ENTDATUM and ENTZEIT for sample drawing date and time or this date is different for you in the same table QPRS

Regrads,

Smruti

Edited by: smruti.ranjan on Feb 7, 2012 12:02 PM

[former_member620323]

If I assign sampling Drawing procedure on dated 01.01.2012 , then after some time I changed the SDP .

How system calculate the latest Drawing No.

I use call function QPRS_READ_LAST_DRAW_FOR_LOT'

Is it right step to do?

[Former Member]

Yes This should ive you the Last drawing no