implementation of transaction no. generator
handle null values correctly when generating transaction numbers