Skip to main content
Business Central forum
Answered

Formula for GL Totalling not working

editSubscribe (0) ShareShare
ReportReport
Posted on by 275

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,415 UG Leader on at
    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 UG Leader on at
    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

Helpful resources

Quick Links

What Motivates a Super User?

We know many of you visit the Dynamics 365 Community and Power Platform…

Demystifying Copilot with Sundar…

Industry experts answer burning questions directly from our amazing Community…

Enabling Copilot Case and Conversation…

Agents can easily recap an ongoing chat, transcribe a voice conversation…

Leaderboard

#1
Andre Arnaud de Calavon Profile Picture

Andre Arnaud de Cal... 282,978 Super User

#2
Martin Dráb Profile Picture

Martin Dráb 222,562 Super User

#3
nmaenpaa Profile Picture

nmaenpaa 101,138

Product updates

Dynamics 365 release plans