Need SQL query to find AP invoice details based on the Drop Ship Sales order line
We have dropship sales order where line 1 had total 90 qty and corresponding PO also have one line with total 90 qty. The total PO 90 qty got received in 2 batch with 32 & 58 qty. As a result SO line 1 got split into line 1.1 with 32 qty and 1.2 58 qty but on PO there is only one line with total 90 qty. In the system AP is generated for 58 QTY, but not for pending 32 QTY. I need SQL query to find AP invoice details based on the Drop Ship Sales order line
Tagged:
0