I have several accounts for intercompany transactions that have an account class of “IC”. The client does not have different accounts for AR and AP intercompany.
When they print the Balance Sheet, if the net of the Account Class is positive, they want it in the Asset section and if negative, they want it in the Liability section.
Does anyone know if this is possible and if so how to do it?
Thanks.
Hi
Have you looked at the Value column and this is where you can add your iif statement:
I wanted to add this from the help:
Got it resolved. I was making it much more difficult than it needed to be. Simple as adding a new line and multiplying the original line by -1, hiding the original line and then modify total line.
Example:
line # 100 - has the DNS settings - this line marked hidden - this line is not included in total
Line #110 - in value column formulas is: @100*-1 - this line is printed & included in total
Thank you for sharing your solution with the community
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.