AnsweredAssumed Answered

How do I create an authorization number based on date such as........

Question asked by TalienaCucura on Oct 18, 2010
Latest reply on Oct 19, 2010 by TalienaCucura

Title

How do I create an authorization number based on date such as........

Post

We have client records that are claims.... some are authorized some are not therefore each record is not consecutive. 

However, the claims that are authorized should consist of the following format.............. 

Example , the first authorized claim for the day will be Authorization number = 101018001

The  break down is the first two numbers from left to right represent the last two digits of this year "10"
the third and forth two numbers left to right representing the month "10" 
the fifth and sixth numbers representing the day of the month "18"
and the last three digits representing the number of claim authorized on that day which is incremented by one each time a claim is authorized. 

After all information is entered, we want to be able to click a button on the layout that issues this number in the above format.  ANY IDEAS ????????????

Claims that are not authorized will not have this authorization number in the record, it will simply show it as rejected. 

NEED HELP PLEASE THANK YOU!

Outcomes