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 query to calculate average cost of item.

Summary: Need query to calculate average cost of item. Cannot use the item PAC from the PAC item cost table instead wanted to use the inbound transaction for calculating the avg cost as Oracle seeded functionality does. We need it as client doesn't want to include the TP price from the TO to affect the avg cost but it cannot be excluded in Oracle.


Content (please ensure you mask any confidential information):


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



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!