Skip to main content
Answer

how to pass a date from a subreport

  • March 17, 2023
  • 4 replies
  • 153 views

wfilipiak67
Captain II
Forum|alt.badge.img+3

Hi, 

A client is using the Production Edition. 
The Sales Order lines can be tied to different production orders. 

We are trying to get the earliest start date of the production tickets and print it in the header of the Sales Order. 
I created a subreport that prints the Min ( AMProdItem.StartDate) correctly. I even have it set as a variable that prints $EDate = Min ( AMProdItem.StartDate). These are both printing correctly in the subreport. 

My question is how do I / or can I get the $EDate to be returned? 
When I set the Value as =$subReport1_EDate, I get a zero that prints. 

Or is there a better way to get the earliest start date from multiple production to print on the Sales Order.

Thank you, 
Bill

Best answer by mcraig95

I have had success with sub reports.  Here is where the information is captured.

The next is displaying it in the calling program

4 replies

xkylewrightx
Varsity III
Forum|alt.badge.img
  • Varsity III
  • March 17, 2023

Is it possible that there is an issue passing your parameter from the main report to the sub report?

I.e. when running the sub-report from your main report, the sub is not able to determine which sales order you are pulling production tickets for?

Here is information on how to pass the parameter from the main to the sub:

https://help-2022r1.acumatica.com/Help?ScreenId=ShowWiki&pageid=7bbd5bbb-cd1a-4e10-9472-9497deb48f2f


Forum|alt.badge.img+1
  • Varsity I
  • Answer
  • March 17, 2023

I have had success with sub reports.  Here is where the information is captured.

The next is displaying it in the calling program


miguel80
Semi-Pro III
Forum|alt.badge.img+3
  • Semi-Pro III
  • March 22, 2023

Hello,

Have you checked the reset conditions on the variable? Could you attach a version of the subReport?


Forum|alt.badge.img+12
  • Acumatica Support Team
  • March 22, 2023

Hi @wfilipiak67 

Can you confirm the Subreport name reflected is correct (including case) i.e., ‘subReport1’?

$subReport1_EDate

Regards,