How can I get all items from a Delivery Trip?
Scenario: ERP is for a distributor that delivers wholesale goods. They have several trucks, each that will deliver to multiple customers each day. If I create a delivery trip, I can pull the customers for the route, but how can I add items from their invoices or delivery Note, etc?
Is there a report I can use to generate this based on customer group (create group for each route/truck)?
Any ideas?
Thanks in advance!
EDIT: Thinking out loud here. I think the flow will need to start with delivery note. When creating the delivery trip, I can pull in customers and associated delivery notes. I will need a way to fetch all items for all delivery notes within the delivery slip. Does anyone know how to accomplish this?