Hello All,

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

 

For Example:

 

If I received 5 Materials for the Month of September 2017 the Lot Number would be the following

1709001

1709002

1709003

1709004

1709005

 

If I received 3 Materials for the Month of October 2017 the Lot Number would be the following

1710001

1710002

1710003

Any Help is Highly Appreciated..

Thank you

 

Edited September 2, 20178 yr by Lola

Some questions: 

1.  Do you want this lot number to auto-generate as you create a record?

2.  Is it possible you would create a record that would not be in the current month, i.e, you're entering records today (9/2) from last month?

3.  Is there a received date also entered when you create a new record (would make it easier if it were)?

 

Hi Steve,

8 minutes ago, Steve Martino said:

1.  Do you want this lot number to auto-generate as you create a record?

Yes

9 minutes ago, Steve Martino said:

2.  Is it possible you would create a record that would not be in the current month, i.e, you're entering records today (9/2) from last month?

No.

9 minutes ago, Steve Martino said:

3.  Is there a received date also entered when you create a new record (would make it easier if it were)?

Yes

I see Phil took care of you in the other forum.