Is it possible to use fiscal year in advanced numbering for vendor bills that are pending approval?

Hi,

I have an issue with advanced numbering on vendor bill records. I need the vendor bill transaction number to include the current fiscal year (not transaction date year). It works fine when the bill is created in the current year (current transaction date) OR when the transaction date is set to previous year and the approval status is set to approved.

However, when the transaction date is set to the previous year and the bill's status is pending approval, the year in the transaction number is the previous year and not the current one.

According to documentation what I understand is that the posting period from which the fiscal year is taken, is only defined after the bill is approved. However, the correct year does show in the posting period field on the bill record even when the status is pending approval. So I don't understand why the transaction number then includes the wrong year.