I feel like this is a very simple question. I am just using the accountbeginningbalance / ending / totaldebits / totalcredits functions to automate a TB summary.
My issue is the directionality of the results. IE accounttotalcredits is resulting in a positive number, rather than a negative one. If I need to make the formulae negative so be it.
The larger issue is with accountbeginningbalance as liabilites and income are coming in as positive numbers, when they should be negative. I'd much rather just be able to use the same formulae all the way down the column vs having a different formulas for different accounts.
Thoughts?
0 Votes
Gabriel Michaud posted
6 months ago
AdminBest Answer
Hi Nathaniel,
There's an option at the workbook level that can control the account balance sign. If you select the "Reversed" option, the credit balances of liability and income accounts will be displayed as negative numbers, and the debit balances will be displayed as positive numbers. In this mode, the total balance of all accounts will always equal to zero (as long as you don't include the YTD Net Income account) and you will not have to make the formula negative.
There's an option at the workbook level that can control the account balance sign. If you select the "Reversed" option, the credit balances of liability and income accounts will be displayed as negative numbers, and the debit balances will be displayed as positive numbers. In this mode, the total balance of all accounts will always equal to zero (as long as you don't include the YTD Net Income account) and you will not have to make the formula negative.
0 Votes
I feel like this is a very simple question. I am just using the accountbeginningbalance / ending / totaldebits / totalcredits functions to automate a TB summary.
My issue is the directionality of the results. IE accounttotalcredits is resulting in a positive number, rather than a negative one. If I need to make the formulae negative so be it.
The larger issue is with accountbeginningbalance as liabilites and income are coming in as positive numbers, when they should be negative. I'd much rather just be able to use the same formulae all the way down the column vs having a different formulas for different accounts.
Thoughts?
0 Votes
Gabriel Michaud posted 6 months ago Admin Best Answer
Hi Nathaniel,
There's an option at the workbook level that can control the account balance sign. If you select the "Reversed" option, the credit balances of liability and income accounts will be displayed as negative numbers, and the debit balances will be displayed as positive numbers. In this mode, the total balance of all accounts will always equal to zero (as long as you don't include the YTD Net Income account) and you will not have to make the formula negative.
If you're using Velixo Classic, please refer to this page: https://helpacumatica.velixo.com/support/solutions/articles/153000018620
If you're using Velixo NX, please refer to this page: https://helpacumatica.velixo.com/support/solutions/articles/153000011797
Regards,
Gabriel
1 Votes
2 Comments
Nathaniel Travis posted 6 months ago
awesome, I knew it must be a simple solution!
Thank you!
0 Votes
Gabriel Michaud posted 6 months ago Admin Answer
Hi Nathaniel,
There's an option at the workbook level that can control the account balance sign. If you select the "Reversed" option, the credit balances of liability and income accounts will be displayed as negative numbers, and the debit balances will be displayed as positive numbers. In this mode, the total balance of all accounts will always equal to zero (as long as you don't include the YTD Net Income account) and you will not have to make the formula negative.
If you're using Velixo Classic, please refer to this page: https://helpacumatica.velixo.com/support/solutions/articles/153000018620
If you're using Velixo NX, please refer to this page: https://helpacumatica.velixo.com/support/solutions/articles/153000011797
Regards,
Gabriel
1 Votes
Login or Sign up to post a comment