I want to create an auto enter Lot Number for new incoming material base on YYMMXXX
YY - Two digits of the Current Year
MM - Months Number
XXX - Number of Material Incoming
If I received 5 Materials for the Month of August 2017 the Lot Number would be the following
If I received 3 Materials for the Month of September 2017 the Lot Number would be the following
Any Help is Highly Appreciated..