I could add a identity field as autoincrement.
But what happens when I want to insert a backdated entry which has to be sorted datewise in ledger report and the balances calculated in that order.