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

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Small and medium business | Business Central, N...
Suggested Answer

Question about General Journals + Line_No Field

(0) ShareShare
ReportReport
Posted on by 10

Hi there! My employer is looking to have me create a General Journal entry based on a sum of payments made to our customer management application, which is separate from Microsoft Dynamics. I will be programmatically adding these values together and inserting the journal entry. Once finished, I need to associate something unique from that journal entry (such as an id field) to the records I added together.

After spending some time analyzing the responses generated from doing this, I have identified the Line_No field as the most likely to fulfill this purpose. Based on the test entries I created, the Line_No field appears to be unique and is incremented in amounts of 10,000. I'm hoping someone here can confirm that I am interpreting this correctly and that the line number will always be unique. If someone can confirm that, I would sincerely appreciate it.

I have the same question (0)
  • Suggested answer
    MahGah Profile Picture
    15,581 on at

    Hi

    As far as I can tell and know Line No in each general journal is unique. in the other words if you have journal A and then line 10,000 you only can have one of this number. But after posting journal A if you create Journal B then you will have another 10,000 line.

    My recommendation is to test this: create one general journal with 2 lines then try Edit in Excel and try to change Line_NO to be identical and then publish and see the result.

  • NerdyCanuck Profile Picture
    10 on at

    Ohh I forgot about being able to view the records in Excel. Our vendor had shown that feature off months ago and I haven't had cause to use it (as I'm a developer, not a user of Business Central), so it promptly fell off my radar. Thank you for the tip, I'll give that a try!

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

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Congratulations to our 2025 Community Spotlights

Thanks to all of our 2025 Community Spotlight stars!

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

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 2,055 Super User 2026 Season 1

#2
YUN ZHU Profile Picture

YUN ZHU 1,063 Super User 2026 Season 1

#3
Dhiren Nagar Profile Picture

Dhiren Nagar 1,014 Super User 2026 Season 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans