Skip to main content

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)

 

Hi @jrudolph 

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

 

 

 

 

 

 

Best Regards,

NNT


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

 


Reply