Job Order Sequential Number Scheme

[fmadmin]

Hello Everyone,

 

I have been working on this calculation for a while and I am getting no where. Please help.

 

I am trying to have an "Order Number" automatically appear when a person selects the "New Job Order" button.

 

The challenge I am having is I need a Job Order Number to contain the last number in the current year (2008 = 8), the current month in two digits (May = 05), plus a sequential number starting with "1". Example would look like this: 8050001. The next Job Order Number would be 8050002. When the next month comes the Job Order Number needs to change to 806, but keep the sequential number started in May. Example: 8060003.

 

Any help would be greatly appreciated.

[HBMarlowe]

The challenge I am having is I need a Job Order Number to contain the last number in the current year (2008 = 8), the current month in two digits (May = 05), plus a sequential number starting with "1". Example would look like this: 8050001. The next Job Order Number would be 8050002. When the next month comes the Job Order Number needs to change to 806, but keep the sequential number started in May. Example: 8060003.

 

Suppose that records for job numbers 8050003 and 8050004 are deleted. Should the next job number be 8050005 or 8050003?

[fmadmin]

Thanks for the great question.

 

The sequential number should continue. So in your example the next number would be 8050005.

 

The purpose for this is sometimes job orders are scheduled to happen but sometimes fail to develop due to uncontrollable events.

[HBMarlowe]

OK. Here is one way. Create a number field, JobNumberSerial, and make it auto-enter serial number, do not modify. You had a three-zero pad in your example, so start the numbering at 0001, incrementing by 1. Next create a number field, JobNumber, and make it auto-enter by calculation, leaving the "Do not replace existing value" box checked. Here is the calculation:

 

Right ( Year ( Get ( CurrentDate ) ) ; 1 ) & Right ( "0" & Month ( Get ( CurrentDate ) ) ; 2 ) & JobNumberSerial

 

edit: removed statement

[fmadmin]

I want to thank you for you time and effort.

 

The scheme worked great.

 

Thanks!