In order to allow me to focus on Consulting (click here) and Courses (click here), I continue to review all posts here in the Forums, but, in general, I'm only personally responding to posts that I mark as #AcumaticaTnT (click here). For Questions (click here), others may respond, or you can post over at Community.Acumatica.com (click here).
Questions Variable from Footer included in running total
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.