Hi Acumatica Community,
Good Evening!
How can I convert this values from -126,622,189.58 to (126,622,189.58 ) in ARM Reports (Column Sets).
Please see attached photo for your reference
Formula :
June Budget Ledger - June Actual Ledger- = Amount
Actual Budget Variance
Thank you !!
Best answer by Laura02
View original
+18
Hello,
This is from the demo balance sheet that comes with Acumatica.
Results:
Thank you Miss Laura !
Hi Miss Laura,
Additional question, When I run a report for Profit and Loss Statement. The Profit and Loss Account for specific accounts is running consolidated by default.
but when I select a unit sets (categories by sub-account) it captures all but the requirements can capture only 25 percent of the total (depends on the % setup per unit set). Is there a way to set up this requirement although this G/L is not used a sub-account or used default sub-accounts (00-000-00) upon posting? or simply, the value depends on the unit sets that I selected upon report generation (Automatic Calculated).
Thank you !!
+18
Hi, I think you are saying that you have one Branch/Company sharing one YTD Net Income account. The balance in the YTD Net Income account (or the amount of net income on the P & L) represents a lump sum that has different owners with different % ownership. You would like to show the correct amount, correct % ownership based on each node in the Unit Set. Do I understand correctly?
I have two ideas you can try.
I think you will need to calculate the % in the Row Set (Using TOT line with a calculation in the Value column) , and then use Unit Group to connect each % line to the proper unit group for printing.
Calculations can also happen in the column set.
Or consider using GL Allocation feature to allocate Retained Earnings by % to separate RE accounts in the GL.
Thanks Miss Laura. :)
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.
