Thank you for supporting the Cloud Customer Connect Community in 2024. It's a gift to work with you!

Look back
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

Unable to Reflect Inbound Shipment no and outbound Order No for VAS activity

Summary:

I'm working on a report where I've to reflect Shipment No and Order No. for each VAS activity. But whenever I create join between IB_Shipment_dtl and Inventory_history to get shipment no. or with Order_dtl to get order no. report parameters get ineffective. To resolve this issue I've tried to create two different report, for inbound and outbound, but I've faced same issue.

Content (please ensure you mask any confidential information):

When we perform VAS there is no shipment no. or Order no. refelect in Inventory_History so there is only one possible join which is Container. So I've used Container no to create join between Ib_shipment_dtl and Order_dtl as it could be either Inbound or Outbound. But creation of this one possible join made add report parameters ineffective and report run for All company/facility and as date parameter is also not effective so it returns all data available for VAS activity.

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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