We are implementing an Oracle ERP solution for our client and we want to align on recommended approach for COA numbering. We always recommend having unique value lengths (numeric) by segment without having values lead with a zero due to varying reasons such as file transfer or excel add-in solutions due to the truncation of the leading zero.
The client would like to have their segments have leading zeros and we are against that approach for reasons above. The alternative options they would like to explore are alpha numeric values (A123445) or having a dynamic segment length for a single segment e.g. Account will be 1234 or 123 at times.
Please confirm best practice when numbering or limitations on the clients perspective.