We do construction projects to our clients, to keep track of everything that goes out to the project we open a new project and link a sale to that project, every time that something goes out from the warehouse to the project we make a delivery linked to that project. So at the end of the project we have an invoice with everything that we used on the project and a way to keep track on expenses and inventory.

The issue is when we need to make a return from the project back to inventory, we have to search on each delivery order, find the correct one, and make a return based on that delivery order. We have projects with more than 100 delivery.

The question is, can we make a return based on the sales order instead of the delivery order? We tried doing a return manually and using the sales order as Document reference, but the sales order didn't got updated and showed the same amount of products from before the return.

Also maybe this is not the best way to keep track on a project, does anybody knows a better way?