Prevent use of existing Lot numbers in Receipts

SOLVED

I have a client that would like to put a control on the Lot field in Receipts.   They want more than just disabling the field in the entry transaction.   

They use BP Lot numbers and recently had a user assign an old Product Lot number to the receipt through the lookup table. 

My thought was to use a control table to ensure data integrity, however I can't quite see the way to configure the Control.  Or if it is even possible. 

Any ideas? 

Thank you

Top Replies

  • assign an old Product Lot number to the receipt through the lookup table

    Hi  

    I am not quite sure to understand what the lookup table refers to. Can you provide the fucntion code and/or…