Missing Ordered Qty in AR Invoice

[Former Member]

Hi all

With reference to SAP Support Message 306166, Qty Ordered is always blank in AR Invoice transaction when a single AR Invoice is copied from two Delivery Orders whether or not there is partial delivery.

Please help to feedback to your development team for this poor limitation as we observed there is no such limitation when multiple Sales Order is copied to Delivery Order.

This information is important when Customer Print AR Invoice together as Delivery Orders on Pre-printed Forms that combine AR Invoice and Delivery Order with carbon copies to block price information.

Kedalene Chong

[former_member583013 · Accepted solution]

Qty Ordered is not brough over to the Invoice as it is already captured and made available in the Delivery.

If you want this in the Invoice you can create a UDF and add a Formatted search to pull this information and then map this user field to the Invoice PLD

Suda

[Former Member]

Can I know the Query required?

[Former Member]

u can try out this query

SELECT T0.Quantity FROM [dbo].[RDR1] T0, [dbo].[DLN1] T1 WHERE T1.BaseEntry = T0.DocEntry and T1.DocEntry = $[$38.45]

Sagar