I need to do a report where amounts are posted in different sections and columns based on wether they are Debit or credit
For instance in a Balance Sheet :
Bank accounts are posted under the Assets or Liabilities section
and amount in a Credit or Debit column
This is something that can be done in the report designer, but is there any way with the ARM?
Many thanks
Christine
Page 1 / 1
Hi @cbuiss53
I could not find an option to get the Ending Debit balance or Ending Credit balance on Column set, Data source selection. Hence, using Reports designer should be better option than ARM to reflect numbers in above manner.
Regards,
Thank you @vkumar. I was suspecting that but I tried anyway :)
Hello All and Vish
I am new to Acumatica and have just realised after trying to write a basic ARM report that Acumatica basically hold the accounting data in the equivalent of an old fashioned T account. So everything is held as debits and credits but the value of the field is positive. This makes creating reports and moving data much more difficult than the convention that I am used as an accountant of the data actually being held as a negative or a positive with no need to refer to the General Ledger Type to work out it’s actual value. I am thinking that maybe this is unusual it’s certainly a change for me as I have never had to work with data in this format before. Is it an American convention?
Is it something that could be considered that the debit and credit entries take on their real value i.e. a credit to sales is a minus etc.
Also the standard reports have lots of hard coded sub totals and this again is a bit old school, I think people these days prefer to have to raw data rather than somebody else’s idea of what you want, this data then can’t be downloaded for manipulation, who needs subtotals and totals these days?
This is a bit of a rant but seeing in the community the mention of the financials being difficult to get out of the system I justed wanted to add my frustrations to the list. Maybe someone can point out the positives in this data structure so I can see them and feel better?