We have the next scenario: we use lot numbers to differentiate items (same items) depending on their purchase costs.
We use this method in order to put items on inventory issues on a FIFO base.
All the items purchased are used internally (for repairing, consuming etc.), non of them being sold to customers (the company is a service provider).
Almost every time an item is both we create a new lot because their prices are constantly changing and we end up with a high number of lots with quantity 0.
Is there a way to set up the system to delete the lots created after quantity=0?