Skip to main content
Solved

Use iif statement in Row Set


Forum|alt.badge.img

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.

Best answer by bduprey51

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

View original
Did this topic help you find an answer to your question?

4 replies

Kandy Beatty
Captain II
Forum|alt.badge.img+16
  • Captain II
  • 2137 replies
  • October 5, 2022

Hi @bduprey51 

Have you looked at the Value column and this is where you can add your iif statement:

 


Kandy Beatty
Captain II
Forum|alt.badge.img+16
  • Captain II
  • 2137 replies
  • October 5, 2022

I wanted to add this from the help:

 


Forum|alt.badge.img
  • Author
  • Jr Varsity III
  • 41 replies
  • Answer
  • October 5, 2022

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


Chris Hackett
Community Manager
Forum|alt.badge.img
  • Acumatica Community Manager
  • 2525 replies
  • October 5, 2022

Thank you for sharing your solution with the community @bduprey51 !


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings