did anyone encountered duplicate numbering with a client having 2 subsidiaries with different fiscal calendar? the auto advance numbering create sequence by fiscal year but the the YY comes from the transaction, causing duplication.

Last co I was at had multiple sub, and at subsidiary we set up prefix for transaction #'s - something like this: