Hi All,

I would like to write query to get the invoice qty in following conditions

1)Warehouse transfer has completed.
2)Invoice is also confirmed but receipt has not confirmed for that invoice

I will give selection criteria only warehouse and Item and query should return the sum of all invoice qty of that particular ITEM and warehouse for above condition.

This query i am trying for LN 6.1 FP2.

Please help me to write this query.

Regards
king1980