Get all items from Delivery Trip

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?

1 Like