web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

🚀 Season of Sharing Community Challenge Launch!
Ask A Community Pro
Introducing our New Video Series: Community Spotlight
News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Small and medium business | Business Central, N... / Genera Journal Documen...
Small and medium business | Business Central, N...
Suggested Answer

Genera Journal Document Number

(1) ShareShare
ReportReport
Posted on by BBBCMAN 389
Hi All,
 
We use monthly journals to copy from excel and paste into general journal and each time we need to change the Document No. field in excel before posting it into general journal in BC.  Is there a way to paste all other column other than document no. and BC automatically fill the document number from no. series.
 
Thanks,
B
Categories:
Dynamics 365 Business Central
I have the same question (0)
  • Suggested answer
    Mansi Soni Profile Picture
    Mansi Soni 10,148 Super User 2026 Season 1 on at
    Hello @BBBCMAN,
     
    To configure automatic document numbering in Microsoft Dynamics 365 Business Central, first go to No. Series from the search and create (or use) a series such as GENJNL. Add a No. Series Line with a starting number (e.g., GJ000001), set the increment to 1, and ensure the line is open and valid for the posting date. This defines how the system generates sequential numbers for your documents. Microsoft explains that number series are used to assign unique, sequential identifiers to transactions and records, helping maintain audit consistency and reduce errors.
     
    Next, open General Journal Batches, select your batch, and assign the created No. Series to it. Make sure Increment Document No. is enabled if available. After this setup, you can paste journal lines from Excel without the Document No., and Business Central will automatically generate it during entry or posting. 
     
    Also check this functionality nicely explained by @YUN ZHU https://yzhums.com/56738/
     
    Hope this answer helps you!
     
    If this answer helps you, kindly Mark it as verified answer.
     
    Regards,
    Mansi Soni
  • BBBCMAN Profile Picture
    BBBCMAN 389 on at
    Hi Mansi,
     
    Yes I have no. series setup with default numbers. selected.  But when you paste all other column including the document no. as empty its just paste everything and leave blank for document number so user wouldn't able to post.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

News and Announcements

🚀 Season of Sharing Community Challenge Launch!
Ask A Community Pro
Introducing our New Video Series: Community Spotlight

Quick Links

Season of Sharing Community Challenge Launch!

Jump in, show your community spirit, and win prizes!

Women in Power Builds Momentum

Expanding mentorship, skilling, and AI innovation

Congratulations to the April Top 10 Community Leaders

These are the community rock stars!

Leaderboard > Small and medium business | Business Central, NAV, RMS

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 2,250 Super User 2026 Season 1

#2
YUN ZHU Profile Picture

YUN ZHU 1,799 Super User 2026 Season 1

#3
AndrewThomas81 Profile Picture

AndrewThomas81 1,390

Last 30 days Overall leaderboard

Featured topics

Microsoft Training Manuals

Product updates

Dynamics 365 release plans