Vendor bill sequence

When confirming a vendor bill, Odoo generates a unique vendor bill reference number. By default, it uses the sequence format BILL/year/month/incrementing-number (e.g., BILL/2025/01/00001), which restarts from 00001 each year.

However, it is possible to change the sequence format and its periodicity, and to mass-resequence vendor bills.

注釈

Changes made to reference numbers are logged in the chatter.

Changing the default sequence

To customize the default sequence, open the last confirmed vendor bill, click Reset to Draft, and edit the vendor bill's reference number.

Editing the reference number of a vendor bill.

Odoo then explains how the detected format will be applied to all future vendor bills. For example, if the current vendor bill's month is withdrawn, the sequence's periodicity will change to every year instead of every month.

Editing the reference number of a vendor bill.

ちなみに

The sequence format can be edited directly when creating the first vendor bill of a given sequence period.

Mass-resequencing vendor bills

It can be helpful to resequence multiple vendor bill numbers. For example, when importing vendor bills from another accounting system and the reference originates from the previous software, continuity for the current year must be maintained without restarting from the beginning.

注釈

この機能は、管理者またはアドバイザー権限を持つユーザのみが利用できます。

Follow these steps to resequence vendor bill numbers:

  1. 開発者モード を有効化します。

  2. In the vendor bills list view, select the vendor bills that need a new sequence.

  3. アクション メニューをクリックし、再付番 を選択します。

  4. 並び順 フィールドで以下を選択して下さい:

    • 現在の並び順を維持する: 現在の番号の順番は変わりません。

    • 記帳日で並び替え: 記帳日で番号を並び替えます。

  5. 最初の新しいシーケンス番号 を設定します。

  6. 変更をプレビュー して 確認 をクリックします。

再付番オプションウィンドウ

注釈

  • To indicate where the sequence change began, the first vendor bill in the new sequence is highlighted in red in the Vendor Bills list. This visual marker is permanent and purely informational.

  • If there are any irregularities in the new sequence, such as gaps, cancelled, or deleted entries within the open period, a Gaps in the sequence message appears in the Vendor Bills journal on the Accounting dashboard. To view more details about the related vendor bill(s), click Gaps in the sequence. This visual marker is temporary and will disappear once the entry's accounting date is on or after the lock date.

ちなみに

Resequencing is not possible:

  • When entries are before a lock date.

  • When the sequence leads to a duplicate.

  • When the range is invalid. For example, if the Bill Date doesn't align with the date in the new sequence, such as using a 2024 sequence (BILL/2024/MM/XXXX) for an vendor bill dated in 2025.

In these cases, a Validation Error message appears.