Skip to Content
0
Dec 01, 2011 at 05:21 AM

Query to Generate a [Lot Number] in Specified Format

28 Views

Hello All,

I've created a Row-Level UDF (Alpha-numeric-15) in Marketing Documents. I would use it on the GRPO as Mandatory field. The name of UDF is LotNum

Once entering the GRPO transaction, I need to create a Unique and Continuous "Lot Number" for each Item. The pattern would be "9999/ItemCode/YY"

Where

9999 = 4 digits of Lot Number Code

ItemCode = PDN1.ItemCode

YY = 2 digits from Current Year

Could anyone of you be kind enough to share the query to achieve this goal?

Thanks and best regards,

JAQ