Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Small and medium business | Business Central, N... / Question about General...
Small and medium business | Business Central, N...
Answered

Question about General Journals + Line_No Field

(0) ShareShare
ReportReport
Posted on by NerdyCanuck 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,433 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

Congratulations 2024 Spotlight Honorees

Kudos to all of our 2024 community stars! 🎉

Meet the Top 10 leaders for December

Congratulations to our December super stars! 🥳

Start Your Super User Journey

Join the ranks of our community heros! 🦹

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,476 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans