Skip to main content
Question

Report Designer Bringing in a Proforma Invoice to a Main Report

  • May 22, 2026
  • 1 reply
  • 13 views
P
Jr Varsity II
Forum|alt.badge.img

Hi All,

I need some help with regards to bringing the amounts from a proforma Invoice to a main report.

I have attached the zip file for the main report(PM652500.rpx) and the subreport. (PM652500CI.rpx)

I have the below parameters on the main report. 

 

 

Below is the external parameter for the sub report. 

 

 

Parameters on the subreport 

 

 

My problem is, I can’t figure out how to populate the amounts for [PMProformaLineWithPrevious.CuryLineTotal] on the main report which on the below column.

 

1 reply

BenjaminCrisman
Acumatica Employee
Forum|alt.badge.img+4
  • BenjaminCrisman
  • Acumatica Support Team
  • May 22, 2026

​@pauledpalina66 Am I understanding correctly that the amounts display correctly in the subreport, it’s only when the column is used in the main report that it fails?

If this is the case, you will need to set the value in the subreport as a variable and then use the following format to use subreport variables in the main report; if subreport variable name is $LineTotal, then you would use $[SubreportName]_LineTotal.

This will call the value from the subreport into the main report

    Terms & ConditionsAccessibility statement
    About Acumatica ERP system
    Acumatica Cloud ERP provides the best business management solution for transforming your company to thrive in the new digital economy. Built on a future-proof platform with open architecture for rapid integrations, scalability, and ease of use, Acumatica delivers unparalleled value to small and midmarket organizations. Connected Business. Delivered.
    © 2008 — 2024  Acumatica, Inc. All rights reserved