You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Need SQL query to find AP invoice details based on the Drop Ship Sales order line

edited Jan 31, 2024 6:26AM in Purchasing 2 comments

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

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!