AugForums.com

An Acumatica User Group

  • Free
    • Start Here
    • In-Person Gatherings
    • Power BI Workshop
    • Podcast
    • Rolodex
    • Blog
    • Forums
  • Paid
    • AugSQL
    • GI Course
    • GI Library
    • Consulting
  • Register
Acumatica Forums

By using this website, you agree to our Terms of Use (click here)

Forums
AUG Forums
Acumatica Report De...
Variable from Foote...
 
Notifications
Clear all

Questions Variable from Footer included in running total

 
Acumatica Report Designer
Last Post by Cdiangelo 3 years ago
1 Posts
1 Users
1 Reactions
1,344 Views
RSS
Cdiangelo
Posts: 3
 Cdiangelo
Topic starter
December 6, 2022 12:48 pm
(@cdiangelo)
Active Member
Joined: 6 years ago

Hi all, I need assistance with this Statement form I've been working on. I need to display the Statement in Detail (sometimes), this will be Statement Type "D" as opposed to "S" for Summary. On the Detail Statement they would like to see the Line Items from the Invoice, but if there's Tax on the Header, I also need this displayed. I have a DtlBalance Variable that works with everything but Tax, and it's in one of two situations. If the Tax is the last line of the entire Statement, I'm 100% good. If there are following lines for another Document I have either an issue with it adding the same number every subsequent line or not adding at all. I can't seem to get that sweet spot! I've attached screenshots of the two situations I described and the report.

In the report I color coded lines and fields to track them on the report, I'll correct formatting once I have the variable and calculations working correctly. Thank you for assistance!!!

And in running the last screenshots I think I may have rolled back on some things working while I was trying to get this to work. Again, thanks for any guidance.

AR641500.rpx
2022 12 06 09h29 43

 


Tim Rodman reacted
Forum Jump:
  Previous Topic
Next Topic  
Forum Information
Recent Posts
Unread Posts
Tags
  • 12 Forums
  • 2,528 Topics
  • 10.9 K Posts
  • 11 Online
  • 2,412 Members
Our newest member: Peter Paasch
Latest Post: Tax on Inventory Transfer
Forum Icons: Forum contains no unread posts Forum contains unread posts
Topic Icons: Not Replied Replied Active Hot Sticky Unapproved Solved Private Closed

Online Members

 No online members at the moment

Acumatica Forums

Terms of Use & Disclaimers :: Privacy Policy

Copyright © 2026 · AUG Forums, LLC. All rights reserved. This website is not owned, affiliated with, or endorsed by Acumatica, Inc.

‹›×

    ‹›×