Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics NAV (Archived) / Use Begin-Total and En...
Microsoft Dynamics NAV (Archived)

Use Begin-Total and End-Total without an account Number on End-Total?

(0) ShareShare
ReportReport
Posted on by Community Member Microsoft Employee

I have a nested Natural Account (i.e. general ledger) scheme. I'd like to use Begin-Total and End-Total rather than Total accounts so that I can take advantage of automated indentation.

I don't want to waste account codes on End-Total accounts; I'd also love not to have to maintain any textual description. Example:

ID Name Type
10000 Current assets Begin-Total
10200 Trade and other current receivables Begin-Total
10210 Current trade receivables Posting
10220 Current receivables due from related parties Posting
10230 Current prepayments Posting
????? Trade and other current receivables (END)??? End-Total
????? Current assets (END)??? End-Total

Is this possible? If not, is there a way to use Total accounts instead but still have access to automated indentation?

*This post is locked for comments

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Use Begin-Total and End-Total without an account Number on End-Total?

    Perfect, thanks. The reason I like using "E" is the symmetry. Any trailing zero is closed by "E" (if it needs to be). "1000" is closed by "1EEE", "1230" is closed by "123E", etc. Knowing that 1199 closes 1000 (or 1100, or 1110, or 1190) isn't immediately obvious.

  • mmv Profile Picture
    mmv 11,465 on at
    RE: Use Begin-Total and End-Total without an account Number on End-Total?

    Hi,

    There is no hard and fast rule to maintain the same sequence.  You may keep 11EE for the End Total.  Usually, we prefer to keep next number - 5 or - 10 (i.e if your next account code 1200, usually, 1199 is used as End Total (as in your case)).

    You may use 11EE, there is no issue.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Use Begin-Total and End-Total without an account Number on End-Total?

    No, I mean I don't want to throw away an account number on an End-Total field when it does the same exact thing as the Begin-Total field.

    Here's a similar example that I tried in CRONUS, which works, but I don't know if it's best practice:

    4454.pic2.png

    So here 11EE closes 1100 (so I get the advantage of automated indenting), but it doesn't force me to use up a numeric digit (which I can leave for posting or real children accounts).

    Is this best practice?

  • mmv Profile Picture
    mmv 11,465 on at
    RE: Use Begin-Total and End-Total without an account Number on End-Total?

    Hi,

    Do you mean that you are going to use 5 question mark characters as the G/L Account Code?  

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,735 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,466 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans