We are a company that sells plumbing tees, elbows, valves, etc.
When customers are finished with a project, they just bring back a large box with a mixture of parts. The warehouse writes up the part numbers and quantities. These parts could have been bought on the same or difference invoices, sometimes up to 100s of invoices.
Right now, I am having to go to the history of every single part, click on an invoice, and see if any of the other parts are also on the invoice, instead of just doing a credit for invoice after invoice.
Is there any kind of way to type in multiple part#s and find out if any are on the same invoice? Or an easier way to do a return on multiple parts purchased on multiple invoices (when you don't know the original invoice #)?
What is the valuation of the parts? FIFO, Lot or Serial?