Skip to main content
Question

Getting the Total Quantity on the Sales Order Invoice Print Screen - Report Designer

  • September 24, 2024
  • 4 replies
  • 96 views

I am trying to pull the total quantity from the invoice screen (via Report Designer) when it is under the sales order tab (so not released yet), as some customers need the invoice prior to our Financial Director releasing the invoices. 

Anyone know a way to do this? I have to do the below within report designer, but the system seems to get confused when there is more than one sales orders on the invoice. 

 

Value used in Report Designer
The value the report gives me (should be 15,234 units for this example)
Pulling from this page (Sales orders → Invoices)

 

4 replies

nhatnghetinh
Captain II
Forum|alt.badge.img+11
  • Captain II
  • September 25, 2024

Hi @jrudolph 

Please try joining with SOLine.
=> Total Quantity = SUM ([SOLine.ShippedQty])

 

 

 

 

 

 

Best Regards,

NNT


  • Author
  • Freshman I
  • September 25, 2024

@nhatnghetinh - 
I am still not getting the correct number. How should I be grouping/sorting this report?
 

 


Chris Hackett
Community Manager
Forum|alt.badge.img
  • Acumatica Community Manager
  • November 13, 2024

Hi @jrudolph were you able to find a solution? Thank you!


  • Author
  • Freshman I
  • November 14, 2024

@Chris Hackett - I unfortunately was not able to get this working.