Inventory Last Used Report

Inventory module>Reports> Reports List

This report gives a list of all inventory items and the last document on which it was used