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
Get Started with Redwood: Oracle Cloud SCM and Purchasing

Query dropship and receipts

Summary:

Query dropship and receipts

Content (please ensure you mask any confidential information):

Hello everyone, I need a query to associate sales order lines with their respective receipts.

The issue I'm found is, for example, my sales order has three lines with the same item but different quantities, and when my purchase order is generated, it only has one line with the total of the sales order. When a receipt is created, I can't find a way to associate each receipt with its corresponding line in the sales order.

Example:

Sales Order

Purchase Order:

Receipts

How can receipt lines be linked to purchase order lines?

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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