Skip to main content
Post a question

Notifications

Announcements

No record found.

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

Formula for GL Totalling not working

Posted on 2 May 2022 08:14:11 by 323

Good morning, 

I have created four GL accounts with the below No:

  • TA-Current Liab_T
  • Loans_ET
  • Provisions_ET
  • Net Pension Liab_ET

I also need a Total GL with the Totalling formula below: 

"TA-Current Liab_T" - "Loans_ET" - "Provisions_ET" - "Net Pension Liab_ET"

I have tried few things, but I keep getting errors. Does anybody know how to put it so it works?

Thanks

Alejandra

  • Suggested answer
    Dallefeld Profile Picture
    Dallefeld 11,425 User Group Leader on 02 May 2022 at 21:47:11
    RE: Formula for GL Totalling not working

    Steve is right numbers work much better and Begin/End Totals work super well.

    You account numbers won't even sort well. If you're worried about data entry, don't you type the name and the account comes up....this is what I do for my accounting.

    The sorting would be :

    Net Pension...

    Loans...

    Provisions....

    TA-Current...

    If you used numbers:

    100 TA-Current Liab_T      $ -100

    200 Loans_ET                    $ - 200

    300 Provisions_ET             $   100

    400 Net Pension Liab_ET  $ - 300

    Account 500 could be a Total Account Type 100+200+300+400, calculation -100+-200+200+-300 or $ - 400

  • Verified answer
    Community Member Profile Picture
    Community Member Microsoft Employee on 02 May 2022 at 15:19:25
    RE: Formula for GL Totalling not working

    Alejandra,

    I first have to ask why you created the G/L Accounts with letters and not actual numbers within the Chart of Accounts structure. If you create them as actual numbers, within the COA range, you can create simple Totaling Formulas. Below is a screen shot of an example.

    pastedimage1651504735908v1.png

    If you need more help send a pic of what you are trying to accomplish in your COA and we can reply back.

    Hope this helps.

    Thanks,

    Steve

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