AnsweredAssumed Answered

Complex Serial number

Question asked by tanja on Jan 19, 2019
Latest reply on Jan 20, 2019 by tanja

Hi there,

 

I have to build a complex serial number. It should include the type of document, the Jear/Month and a serial number.

It looks like that:

 

a) O-1908-12345-Q3 or   (O is standing for Order, 1908 for 2019 August, serialnumber, Q3 for quarter of year

b) I-1911-12345-Q4         (I for Invoice)

 

the serial numbers should be incremented so long as the month is changed. In a new month, the serial numer should begin with 1

 

Sample: O-1908-12345-Q3 --> O-1909-00001-Q3

 

How can I realize it? I tried out many ways: SQL, separate Table,...

Thanks

 

Tanja

Outcomes