Small and medium business | Business Central, N...

General Journal Number Series

(3) Share

Report

Posted on by Niki

427

Hi Experts,

I have three batches in my general journal an I am maintaining three separate number series for those batches as follows.

Batch 1 no series start from CR0001

Batch 2 no series start from SH0001

Batch 3 no series start from AH0001

My issue is, when I post transaction on my first batch my doc no will be CR0001. And then when I go to batch 2, my doc no should be SH0002. after post the transaction , if i go to the batch 3 doc no should be AH0003. Likewise I need generate numbers only but not to change my English letters of the number series.

Can I do this in dynamic 365 BC. please advice me

Categories:

Dynamics 365 Business Central

I have the same question (0)

All responses (6)

Answers (0)

Suggested answer

Yi Yong 2,555 Super User 2025 Season 2 on at

Like (0)

Report

Hello,

You can't do this without customization.

Also, it is no ideal because you will have missing numbers. In your example, missing of SH0001 in ledger entry.

This will definitely get flag by auditors.

If your purpose is to identify the journal is posted from which batch, then there is no reason to do this.

In General Ledger Entries, you can add Batch Name to the page via Customize page or get your partner to do so.

Was this reply helpful? Yes No
Suggested answer

Tech-Lucky 1,267 Super User 2025 Season 2 on at

Like (1)

Report

This is not feasible as per the standard functionality. While it can be customized, it does not make practical sense and is not recommended. We may be able to suggest better alternatives if you can share more details on why you need it to work in this way.

Was this reply helpful? Yes No
Suggested answer

Sumit Singh 10,078 on at

Like (1)

Report
Standard Limitation
Business Central does not support cross-series sequential numbering out of the box. Each number series increments independently. So:

CR series will go: CR0001, CR0002, CR0003…

SH series will go: SH0001, SH0002, SH0003…

AH series will go: AH0001, AH0002, AH0003…

This means you cannot maintain a global sequence across batches while retaining prefixes without customization.

ALSO AS MENTIONED BY @YI YONG, IT CAN BE AN AUDIT ISSUE.

STILL IF AUDITORS ARE NOT HAVING ANY ISSUE AFTER DISCUSSION WITH THEM AS PER YOUR COUNTRY REGULATION THEN WE CAN DO BELOW CUSTOM APPROACH.

Customizable Solution (Recommended)
You can achieve your goal with a small AL customization:
Logic:

Create a custom number series table that stores:

Last used number (e.g., 0001, 0002, etc.)

Prefix per batch (CR, SH, AH)

On posting, fetch the next global number, increment it, and combine with the batch prefix.

Store the updated number back in the table.

Override the document number assignment logic in the journal posting routine.

Example Output:

Batch Prefix Last Used Next Doc No

CR CR 0001 CR0004

SH SH 0002 SH0005

AH AH 0003 AH0006

Note: This response was created in collaboration with Microsoft Copilot to ensure clarity and completeness. I hope it helps to some extent.
Mark the Answer as Verified if this is Helpful.

Was this reply helpful? Yes No
Suggested answer

Dynamics_Decoded_Gokul 451 on at

Like (1)

Report

Hi

Customization is one of the way to handle this requirement.

but if you keep the number series as running for all the three batches and use a custom field to capture the char as option or text field and flow it upto General ledger entries so that you can review the information when ever its required.

Thanks

Gokulnath

Was this reply helpful? Yes No
Suggested answer

Khushbu Rajvi. 20,275 Super User 2025 Season 2 on at

Like (2)

Report

Agree with the previous responses, You can achieve this by the customization.

Was this reply helpful? Yes No
Suggested answer

YUN ZHU 95,329 Super User 2025 Season 2 on at

Like (0)

Report

As mentioned by the experts above, this can only be done through customization. The use of one No. Series in the standard will not affect the other.

PS: Dynamics 365 Business Central: How to combine the No. Series with the date (No Customization)

https://yzhums.com/16424/

Hope this helps.

Thanks.

ZHU

Was this reply helpful? Yes No