Need table joins between Inventory On hand table and Review completed Transactions — Cloud Customer Connect
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

Need table joins between Inventory On hand table and Review completed Transactions

in Purchasing 1 comment

Summary:

Hi Team,

We have a business requirement to build a report with below columns :

Item
Item Description
Item Category
On hand Original
Review completed date
Warehouse
Subinventory
Locator
On Hand Serial Number
Unit Cost
Total Cost

I was able to build the query but not able to pull the review completed transaction date. Could you please share a query for this.

Thanks & Regards,

Maruthi Reddy.

Content (please ensure you mask any confidential information):

NA

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

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

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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