Anyone knows if it's possible to auto-generate a transaction/reference number on a custom field for a new bill? Does this require scripting? Case requirement: Generate a custom reference no. when bill is selected as non-invoice (custom field)

I don't think this possible via basic customization. This requires a workflow

I'm curious how this could be done with workflow!

1. Create a custom record with single integer field - this will serve as the storage of the reference number with starting value of 1. 2. On beforesubmit, get this value and set it to the custom field within the transaction record 3. After record submit, update the integer field by incrementing the value to 1

Nice