Report order cycle distributor totals by supplier gives wrong information in relation to delivery method

[nicolasVr]

Description

This is the only report that displays delivery method for order cycles. But the result is wrong as explained below.

Expected Behavior

The report should give the total quantity for each delivery method :
Product | Qtty | Delivery Method
A | 3 | Place X
A | 4 | Place Y

Actual Behaviour

Instead of that there is only 1 line per product and I don't know how the delivery method displayed is chosen. We'll get for our example :
Product | Qtty | Delivery Method
A | 7 | Place X

Steps to Reproduce

Ask a report for an order cycle where a product has been ordered with 2 different delivery methods.

Workaround

No report with this information !

Severity

s3 ?

[RachL]

@chahmedejaz Ahmed hold on I don't think we have budget for this one. Can you have a look at estimating the issues I've linked here instead ? https://openfoodnetwork.slack.com/archives/C01T75H6G0Z/p1728638876580479

[chahmedejaz]

Sure @RachL let me do that 👍