How do I create an authorization number based on date such as........
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!