Hello –

I am looking for a report in zoho inventory that I can’t seem to find. Below is what I need the report to do:

• Calculate the average cost of all quantities purchased for each item using the amount from the BILL paid This should include the price we paid for the item, as well as any landed costs associated with the item
• Most reports I’ve seen are calculating on the “cost” associated with the item from the item profile – however, we pay different prices for items each time we purchase. We need to know the average cost we PAID for the item (this would be calculated by adding up all of the different prices we’ve paid for the item from the bill and divided by how many items we purchased). This would include in stock and already sold items

• We would also like to calculate the average price for each item sold from the invoices created in this same report
• This would allow us to take the average COST of each item (what we paid) and the average PRICE of each item for the items sold, and determine what our profit has been for the items sold to date, what price adjustments we need to make for the remaining inventory and if we need to wait for an item to go on sale to purchase it again

• For example, lets say we purchased the following:
• 2/1/22 - Item 1, 15QT x $10 = $150
• Landed Cost - $1.50
• 3/1/22 – Item 1, 10QT x $8 = $80
• Landed Cost - $1.00
• 4/1/22 – Item 1, 5QT x $6 = $30
• Landed Cost - $.50
• Total Items = 30 
• Total Cost = $263
• Average Cost Per Item = $8.77