By using this website, you agree to our Terms of Use (click here)
Hi Guys,
Apologies if this has been covered before we are trying to build a report in MYOB Advanced (Aussie version of Accumatica)
We have a sub report and want to access values or a variable in the main report for calculations.
Doing some research online we see mention of syntax like $subReport1_Variable but this does not work when we try.
If anyone can provide tips of how to access values from a sub report in a main report that would be greatly appreciated.
Cheers,
Bri!
You use parameters to pass from main to sub.
Refer Lesson 5 of S130 Open Uni training.
https://openuni.acumatica.com/courses/reporting/s130-inquiries-reports-and-dashboards/
https://openuni.acumatica.com/wp-content/uploads/2017/08/S130_DataRetrievalAnalysis_2017R2-1.pdf
@royce-lithgo
Hello
This does not assist me.
Let me explain further, I have a sales order report which lists the orders and their total payments against the order (the total payments is a subreport). What we need to do is a calculation on the main report which will subtract the order value from the total payments (the sub report).
How do we reference the sub report in the calculation, so we can get the remaining balance on the report?
Thank you for you assistance
I don't think you can pass values back from a subreport. Can't you calculate the remaining balance in the main report without relying on the totals from the subreport?
SOOrder.CuryUnpaidBalance perhaps?
@royce-lithgo
No we have tried that and it does not work.
Thanks again for your assistance
@roycelithgo and @brian you can pass variables from sub reports back to the parent/main report,
the syntax is =$*subreport name*_*variable name*
@roycelithgo and @brian you can pass variables from sub reports back to the parent/main report,
the syntax is =$*subreport name*_*variable name*
Why doesn't it work? That field above is the unpaid balance for the Sales Order as shown on the page.
@royce-lithgo
Below are the fields you suggested in a generic inquiry and you can see they don't match the sales order
Which is why we have had to use a sub report to bring the payments in.
Try holding down Ctrl + Alt and clicking on the field of interest. It will give you the DAC reference (Data Class + Data Field).
Click on the amount, not the label.
Also you have duplicated data in your GI - have you joined SOLine in as well?
Last time I looked at that Payments DAC, it wasn't getting calculated outside of the Sales Orders (SO301000) screen, but maybe that's changed in recent versions.
Assuming it hasn't changed, it's a pain to have to use Subreports, but I don't know a better way.
See this post for fun with passing Subreport variables back to a Main report:
https://www.augforums.com/augforums/acumatica-report-designer/passing-variables-from-sub-report-not-resetting-value-when-no-value-in-subreport/
Online Members
