query sold per bp per month_update

[former_member798634]

Good afternoon,

I need some help with a query I have. The query should let me see for what amount we sold per BP. However, it doesn't work completely. If I adjust to put the whole year, the pane freezes:

After 10 minutes finally pane is working again, though see results: Somewhere it's getting information that's not correct because the amounts are running in the millions.

While the correct is less:

Who can explain to me where those big amounts are coming from?

I hope you can help me out.

Regards.

[Johan_H]

Hi Mark,

Can you please post the query as text, instead of as a screenshot?

Regards,

Johan

[former_member798634]

Hi Johan,

Unfortunately, it doesn't even open the query any more. The pane freezes.

The following i had in wordpad written:

LEFT JOIN JDT1 T4 ON T4.ShortName = T0.CardCode AND Month(T4.Duedate) = 4 AND Year(T4.Duedate) = 2022 AND T4.TransType

in ('13','14')

(SUM(T8.Debit) - sum(T8.Credit)) AS 'August', (SUM(T9.Debit) - sum(T9.Credit)) AS 'September', (SUM(T10.Debit) - sum(T10.Credit)) AS 'October', (SUM(T11.Debit) - sum(T11.Credit)) AS 'November', (SUM(T12.Debit) - sum(T12.Credit)) AS 'December'

Hope you can help

[Mazzucco]

Do you use the outgoing invoice module? If yes, you can directly consult it if you want to know how much was sold to each customer.