By using this website, you agree to our Terms of Use (click here)
I am customizing the AR Invoice report, AR641000.
When installment terms are used on an invoice, when released, the master invoice is in a closed status and the child invoices are generated with a single line of detail. I am trying to build the invoice form so that the detail from the master prints on the child invoices. The good news is that I am not trying to have each detail line's proportional amount listed on the report, only the line descriptions.
I am needing to print the total invoice amount in what looks like the detail section of the invoice report. I can't get it to print where I want it.
I have a subreport that collects the detail descriptions from the master and is printing in a GroupFooter. When I print any dollar amounts to the right of the subreport, the dollar amounts are not displayed/printed.
If I put the dollar amounts in a separate GroupFooter section, the dollars do print, just not in the location I want them to print. I want them to print to the right of the first line of the detail descriptions.
Ideas?
Hi DWS253,
Welcome to ARC Forums!
Would you be able to attach the Report and Subreport to this Topic discussion?
If so, I'd be happy to take a look at it.
Invoice report is built to print detail lines only if the InventoryID = "COMMENT"
Subreport used to try and print the child invoice total amount. Probably not needed. Theory was if the CuryLineTotal wouldn't print next to the Detail Lines subreport, maybe another subreport
The first thing I notice is that the allocated space on the Base report (ar641000.rpx) for the Subreport (ar641005.rpx) is only 504px:
But ar641005.rpx is 18.46 cm (or ~697.78px) wide:
In my experience, the Subreport will expand to ~697.78px wide, regardless of the fact that you only allocated 504px to it on the Base report.
That could be the reason why your amounts to the right of the Subreport are getting "taken over" by the Subreport.
Acumatica Version 6.10.0472 used when composing this response
Doug Johnson wrote a PM Summary report that, in part, has one subreport sitting beside another. I am thinking it might be a clue on how to get this to work. Have you seen that report?
Do you mean this article?
http://www.acumatica.com/blog/technical-tuesday-building-project-overview-report-part-3/
That's a really cool article with a great example.
Did you try shrinking the width of the subreport? I probably didn't do a good enough job of explaining what I meant above. I just meant to shrink the width of the ar641005.rpx report.
I just tried it in my environment and it seemed to solve the problem.
Attached is the shrunken (is "shrunken" a word?) version of the ar641005.rpx file that I came up with.
Acumatica Version 6.10.0472 used when composing this response