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

How to join INV_TRANSFER_ORDER_HEADERS with GL_JE_LINES to get period name?

edited Oct 31, 2024 5:30PM in Inventory Management 1 comment

Summary:

I am using INV_TRANSFER_ORDER_HEADERS,INV_TRANSFER_ORDER_lines table in my report to get transfer data but i want to run this report for particular month and add the period name in Parameter also so i can see data for particular month. I am not able to find any date or period attribute in INV_TRFR table. How to join this Inv transfer table to GL tables to get period name?

Content (please ensure you mask any confidential information):


Version (include the version you are using, if applicable):



Code Snippet (add any code snippets that support your topic, if applicable):

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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