I’m customizing the purchase receipt report (10124). I have a calculated field in the Purch. Rcpt. Line data item called LineTotal. I want the sum of the LineTotal from the lines in the report to be displayed in the custom Word layout. I created another calculated field in the Purch. Rcpt. Header data item called TotalAmount and I’m trying to use it to total the LineTotal value that I calculated in the Purch. Rcpt. Line data item for the report.
I tried using the LineTotalCalc() in the expression editor like below:
This is just displaying the first line’s value and not a total. Is there a way to total a SOD designed calculated field from one data item in another?
Thanks for your help!
hougaard Answered question April 8, 2025
To do that I think I would need to somehow create a calculated field on the Purch. Rcpt. Line table that was the result of multiplying the Unit Cost LCY value times the Quantity. I haven’t been able to figure out how to do that with one of your tools. Is that something that is possible with SOD or Toolbox 2.0?