Monthly Lot Numbers

[Lola]

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, 2017 by Lola

[Steve Martino]

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)?

 

[Lola]

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

[Steve Martino]

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