You want to see the Inbound Delivery ID details in the confirmation journal report, however the delivery ID displayed with # value.
Reproducing the Issue
- Go to the Business Analytics work center.
- Go to the Data Sources view & select Design Data Sources.
- Select the Data Source ID SCMCFJU01 -Confirmation Journal.
- Select Preview.
- Move Original Document Type, Reference Document Type and Inbound Delivery ID to rows.
- Inbound Delivery ID is displayed as #.
The confirmation journal report is meant to show only the confirmations that affect the inventory for particular selection parameters. In this case the Inbound Delivery Notification (IDN) is shown as the Reference Document Type because IDN is the immediate preceding document to the confirmations listed. If you want to see the details of the Inbound Delivery, you need to navigate to Display Original Document details and from the document flow, you can see the inbound delivery. The characteristics Inbound Delivery ID and Inbound Delivery Item ID in the confirmation journal report are part of special stock separators in backend of your system. They hold values only in case of Return to Customer/Supplier scenarios. For normal inbound deliveries, this field does not store value. Hence the Delivery ID value appears as # in the report.
Note: You can make use of the characteristics Reference Document Type and Reference Document ID to check the receipts against the report. For these characteristics you would get the Inbound Delivery Notification ID instead of the "nbound delivery ID.
KBA , AP-RC-ANA , C4C, ByD, Travel: Analytics Tools & Frameworks , How To