Skip to main content

Notifications

Announcements

No record found.

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

Question about General Journals + Line_No Field

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.

  • NerdyCanuck Profile Picture
    NerdyCanuck 10 on at
    RE: Question about General Journals + Line_No Field

    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!

  • Suggested answer
    MahGah Profile Picture
    MahGah 15,428 on at
    RE: Question about General Journals + Line_No Field

    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.

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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,280 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,214 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans