Retrieving PO_LINE_ID for COGS Transactions Linked to Sales Orders in Back-to-Back Process
Summary:
How can I trace the PO_LINE_ID associated with a Cost of Goods Sold (COGS) transaction in the XLA tables, generated during the shipping process of a Sales Order line in a Back-to-Back (B2B) process? I understand that multiple Purchase Order (PO) lines can be linked to a single Sales Order line.
Content (please ensure you mask any confidential information):
Hello,
We are using the Back-to-Back (B2B) process, where a Sales Order line creates a Purchase Requisition, which subsequently creates a Purchase Order (PO) line.
During the shipping process for the Sales Order line, a Cost of Goods Sold (COGS) transaction is generated in the XLA tables. I'm using the following query to retrieve the COGS entries:
0