How to Show Information in Footer Based on Line Item Inventory Item's Attached Attribute

  • 5 December 2022
  • 2 replies

Userlevel 3
Badge +1

We have a custom report based on the Invoices form where data needs to be picked to the report footer to show a summary of the line items. The Inventory ID field has an Attribute called HSCODE in the Inventory Form (there are 4-5 fixed HSCODES)

Based on this information if the line items of the invoices have the same HSCODE for different inventory items, we should cumulate their totals, but if the separate lines have different UOMs we should show that as well. What would be the best approach to achieve this result? The expected result would be something like this in the footer section.



Best answer by lauraj46 5 December 2022, 19:05

View original

2 replies

Userlevel 7
Badge +8

Hi @TharidhiP ,

I would suggest using a subreport.  In the subreport you can group and total as needed.  Insert the subreport in the footer and link it to your main report based on the invoice reference number.


Userlevel 3
Badge +1

Image screenshots where data is picked is attached below for reference.

Invoice Screen with Inventory ID
Particular Inventory Item ID’s Attribute Called HSCODE



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