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):