Hi @Unscented0296 

can you post here your sql code?

select '' as "Kunde, Ort", 'Summe 1: Gruppe' as "Nr., Summen", sum(Menge) as Bestand
from IFSINFO.BT_STOCK_EOM
where Art = 'Bestand'
and kunr LIKE 'C%'

union

select '' as "Kunde, Ort", 'Summe 2: Anonym -NB' as "Nr,, Summen", sum(Menge) as Bestand
from IFSINFO.BT_STOCK_EOM
where Art = 'Bestand'
and Ort LIKE 'Anonym%'
and Artikel NOT LIKE '99%'
group by kunr

union

select '' as "Kunde, Ort", 'Summe 3: Gruppe +Anonym -NB = Board'  as "Nr, Summen", sum(Menge) as Bestand
from IFSINFO.BT_STOCK_EOM
where Art = 'Bestand'
and kunr LIKE 'C%'
or Ort LIKE 'Anonym%'
and Artikel NOT LIKE '99%'

union

select '' as "Kunde, Ort", 'Summe 4: NB = Nebenbahnen'  as "Nr, Summen", sum(Menge) as Bestand
from IFSINFO.BT_STOCK_EOM
where Art = 'Bestand'
and Artikel LIKE '99%'

union

select '' as "Kunde, Ort", 'Summe 5: Alle anderen Kunden'  as "Nr, Summen", sum(Menge) as Bestand
from IFSINFO.BT_STOCK_EOM
where Art = 'Bestand'
and Name NOT like 'Anonym'
and kunr not like 'C%'

union

select '' as "Kunde, Ort", 'Summe 6: Macher Gesamt'  as "Nr, Summen", sum(Menge) as Bestand
from IFSINFO.BT_STOCK_EOM
where Art = 'Bestand'

union

select '' as "Kunde, Ort", 'Summe 7: Auftragsbestand Gruppe'  as "Nr, Summen", 
sum(desired_qty) as Bestand
from customer_order_line
where promised_delivery_date > sysdate
and customer_no LIKE 'C%'

union

select '' as "Kunde, Ort", 'Summe 8: Auftragsbestand Andere'  as "Nr, Summen", 
sum(desired_qty) as Bestand
from customer_order_line
where promised_delivery_date > sysdate
and customer_no NOT LIKE 'C%'

union

select '' as "Kunde, Ort", 'Summe 9: Auftragsbestand Gesamt'  as "Nr, Summen", 
sum(desired_qty) as Bestand
from customer_order_line
where promised_delivery_date > sysdate

So it seems IFS somehow got it wrong.

I deleted the quick report, created a brand new one with the exact same query and now it’s working. That’s pretty frustrating to be honest, because from my perspective I am not doing anything differently, but suddenly the output is correct.  

Can it be that IFS saves an old/incorrect version of the quick report and keeps using it even though it changed?

I have to correct this. Even after deleting the report and creating a new one, it sometimes gets sum7 and sum9 completely wrong when being scheduled.

Hi,

Is it possible that the user manually running the report is missing access to one or more sites? And the user set to be running the scheduled task has more/all sites?

BR

Johan