Skip to Content

Journal Entry Sequence for Invoice

6 min read
May 8, 2024
Odoo Apps

Managing accounting document numbering is an essential requirement for every business. Many organizations use different numbering formats for customer invoices, vendor bills, journal entries, credit notes, and debit notes. Earlier Odoo versions allowed users to easily configure journal-specific sequences, but this functionality was removed in Odoo 14.

The Journal Entries Sequence Odoo App restores this valuable functionality and enables accounting teams to create, customize, and manage independent numbering sequences for each journal. Businesses can configure unique invoice sequences, refund sequences, and journal entry numbering rules according to their accounting policies and regulatory requirements.

This application is especially useful for companies operating multiple departments, branches, subsidiaries, or business units where separate document numbering is required for compliance, auditing, and reporting purposes.

Also Read: Invoice Cancel/Journal Entry Cancel Access Rights

Why Use Journal Entry Sequences?

Accurate document numbering is critical for maintaining organized accounting records. Using dedicated journal sequences helps businesses:

  • Maintain separate numbering for different journals.
  • Simplify audit and compliance processes.
  • Improve document traceability.
  • Follow country-specific accounting regulations.
  • Manage customer invoices and refunds independently.
  • Reduce manual errors in accounting operations.
  • Create standardized accounting workflows.

Features

1) Allow Create Journal Sequence.

Users can create unique numbering sequences for each accounting journal. Every journal can have its own prefix, suffix, sequence length, and numbering pattern.

Benefits include:

  • Separate invoice numbering for different departments.
  • Distinct sequences for sales and purchase journals.
  • Better accounting organization.
  • Improved record management.

2) Allow Create Refund Journal Sequence.

The application allows separate numbering for refund documents such as customer credit notes and vendor refunds.

Benefits include:

  • Easy identification of refund transactions.
  • Better financial reporting.
  • Improved audit trail.
  • Separate tracking of corrections and adjustments.

3. Full Sequence Customization

Users can configure:

Configuration OptionDescription
PrefixAdd custom text before sequence numbers
SuffixAdd custom text after sequence numbers
Sequence SizeDefine the number length
Increment StepSet automatic numbering increments
Starting NumberConfigure the first sequence number
Company SettingsApply company-specific configurations

4. Accounting Advisor Access Control

For security purposes, only users with Accounting Advisor permissions can create or modify journal sequences.

This ensures:

  • Controlled access to accounting configurations.
  • Prevention of accidental sequence changes.
  • Better internal compliance.
  • Improved accounting governance.

Access Rights Configurations

Only users with "Accounting Advisor" access rights can create and change sequence for journal.

Access Rights Configurations

Journal Configuration

Under Invoicing > Configurations > Journal menu user have to configure journel sequence.

Journal Configuration

On journal, under "Sequence Settings" user have to select sequence, also select refund sequence.

Journal Configuration

Journal Sequence

User can set "Prefix", "Suffix", "Sequence Size" and all other options and this will applied to journal sequence.

Journal Sequence

User can see created customer invoice with sequence number as per configurations.

Journal Sequence

Refund Journal Sequence

User can set "Prefix", "Suffix", "Sequence Size" and all other options and this will applied to refund journal sequence.

Refund Journal Sequence

User can see created customer credit note with sequence number as per configurations.

Refund Journal Sequence

Business Benefits

Improved Accounting Accuracy

Automatic sequence generation eliminates manual numbering errors and ensures consistency across all accounting documents.

Better Audit Compliance

Auditors can easily review and track accounting records because every journal follows a predefined numbering structure.

Faster Accounting Operations

Accounting teams spend less time managing document numbers and more time focusing on financial analysis and business operations.

Enhanced Financial Control

Separate sequences provide greater visibility into transactions generated from different journals and departments.

Common Use Cases

Multi-Branch Companies

Different branches can maintain independent invoice numbering systems.

Manufacturing Businesses

Separate sequences can be used for production, sales, procurement, and accounting journals.

Service Companies

Distinct numbering can be assigned to invoices, refunds, and adjustment entries.

Retail Organizations

Each store or business unit can maintain its own accounting document numbering structure.

How This App Helps Odoo 14 Users

Since journal sequence customization was removed from Odoo 14, many businesses lost the ability to manage journal-specific numbering. This application restores that functionality and provides the same flexibility available in earlier Odoo versions.

Users can continue working with familiar accounting workflows while maintaining complete control over invoice and journal numbering.

Importance of Separate Invoice and Refund Sequences

Many businesses generate thousands of invoices and credit notes every month. Using the same numbering sequence for both document types can create confusion during reconciliation, reporting, and auditing processes.

Separate refund sequences provide several advantages:

Better Transaction Identification

Accounting staff can instantly identify whether a document is an invoice or a refund simply by reviewing the document number.

Improved Audit Trail

Auditors can quickly review refund transactions without searching through regular invoice sequences.

Simplified Financial Reporting

Separate sequences make it easier to prepare reports related to customer refunds, vendor returns, and credit adjustments.

Enhanced Compliance

Many industries and countries require businesses to maintain clearly distinguishable numbering systems for invoices and credit notes.

Journal Sequence Configuration Examples

Example 1: Sales Invoice Journal

ConfigurationValue
Journal NameSales Journal
PrefixSI/2026/
Sequence Length6
Starting Number000001
ResultSI/2026/000001

Example 2: Vendor Bill Journal

ConfigurationValue
Journal NamePurchase Journal
PrefixPB/2026/
Sequence Length6
Starting Number000001
ResultPB/2026/000001

Example 3: Customer Credit Note Journal

ConfigurationValue
Journal NameCustomer Refund
PrefixCN/2026/
Sequence Length6
Starting Number000001
ResultCN/2026/000001

Example 4: Vendor Refund Journal

ConfigurationValue
Journal NameVendor Refund
PrefixVR/2026/
Sequence Length6
Starting Number000001
ResultVR/2026/000001

Advantages of Using This Module

AdvantageBenefit
Custom Journal SequencesBetter accounting organization
Separate Refund SequencesImproved refund tracking
Access ControlEnhanced security
Automated NumberingReduced manual effort
Compliance SupportEasier audits and reporting
Flexible ConfigurationAdaptable to business requirements

Why Businesses Choose This Module

Organizations choose the Journal Entries Sequence Odoo App because it restores a highly demanded accounting feature that was removed in Odoo 14. The module provides flexibility, control, and compliance while maintaining a familiar user experience.

Whether your business processes hundreds or millions of accounting transactions annually, proper sequence management contributes to better financial organization, stronger internal controls, and improved operational efficiency.

By implementing dedicated journal sequences and refund sequences, businesses can establish a scalable accounting framework that supports growth while ensuring consistency across all financial records.

Conclusion

The Journal Entries Sequence Odoo App is an essential solution for organizations that require complete control over accounting document numbering. By enabling journal-specific sequences and refund sequences, businesses can maintain accurate records, improve compliance, streamline accounting processes, and restore the sequence management functionality that was previously available in earlier Odoo versions.

Whether you manage a small business or a large enterprise, this module helps establish a structured and reliable accounting environment while ensuring every financial document follows your preferred numbering standards.

Frequently Asked Questions

Can I create separate sequences for different journals?

Yes. Each journal can have its own independent numbering sequence.

Can I configure separate refund numbering?

Yes. The module supports dedicated refund sequences for customer and vendor refunds.

Can existing sequences be modified?

Yes. Users with Accounting Advisor permissions can update sequence configurations.

Does the module support multi-company environments?

Yes. Each company can maintain separate journal sequences.

Can I customize prefixes and suffixes?

Yes. Prefixes, suffixes, padding length, and starting numbers can all be configured.

Why is this functionality important?

Proper sequence management improves accounting accuracy, auditing efficiency, compliance, and financial reporting.

Journal Entry Sequence for Invoice
Dhruv Parmar Jr. Odoo Developer

About the Author

I am an Jr. Odoo Developer with expertise in custom module development, ERP implementation, and workflow automation. My work focuses on delivering scalable and efficient solutions tailored to business needs.
Book a Consultation

Share this post