2 different sales tax messes with report

I have 2 sales tax, 21% and 6%. Now for my report, it messes up:

Werk periode: {WORKPERIOD ID}

[VERKOOP 21%:2,1, 1]
{ACCOUNT TRANSACTION DETAILS:Sales Hoog}
>VERKOOP HOOG||€ [=F((TN('{ACCOUNT CREDIT TOTAL:Sales    Hoog}')+TN('{ACCOUNT CREDIT TOTAL:BTW Hoog}'))/121*100,'#,#0.00')]
>BTW 21%||€ [=F((TN('{ACCOUNT CREDIT TOTAL:Sales Hoog}')+TN('{ACCOUNT CREDIT TOTAL:BTW Hoog}'))/121*21,'#,#0.00')]
>TOTAAL||€ [=F(TN('{ACCOUNT CREDIT TOTAL:Sales Hoog}')+TN('{ACCOUNT CREDIT TOTAL:BTW Hoog}'),'#,#0.00')]

[VERKOOP 6%:2,1, 1]
{ACCOUNT TRANSACTION DETAILS:Sales Laag}
>VERKOOP HOOG||€ [=F((TN('{ACCOUNT CREDIT TOTAL:Sales Laag}')+TN('{ACCOUNT CREDIT TOTAL:BTW Laag}'))/106*100,'#,#0.00')]
>BTW 6%||€ [=F((TN('{ACCOUNT CREDIT TOTAL:Sales Laag}')+TN('{ACCOUNT CREDIT TOTAL:BTW Laag}'))/106*6,'#,#0.00')]
>TOTAAL||€ [=F(TN('{ACCOUNT CREDIT TOTAL:Sales Laag}')+TN('{ACCOUNT CREDIT TOTAL:BTW Laag}'),'#,#0.00')]

[VERKOOP TOTAAL:2,1, 1]
{ACCOUNT TRANSACTION DETAILS:Sales Hoog}
>TOTAAL||€ [=F(TN('{ACCOUNT CREDIT TOTAL:Sales Laag}')+TN('{ACCOUNT CREDIT TOTAL:Sales Hoog}'),'#,#0.00')]

[BTW TOTAAL:2,1, 1]
{ACCOUNT TRANSACTION DETAILS:Sales Hoog}
>TOTAAL||€ [=F(TN('{ACCOUNT CREDIT TOTAL:BTW Laag}')+TN('{ACCOUNT CREDIT TOTAL:BTW Hoog}'),'#,#0.00')]

[BETALINGEN:2, 1, 2]
>BETAALD|{REPORT PAYMENT DETAILS:P.Amount.Sum:Payment.Amount > 0}

[WERKELIJK BINNEN EN BETAALD:3, 1]
CONTANT|{ACCOUNT TOTAL:Cash}
PIN|{ACCOUNT TOTAL:Credit Card}
TOTAAL|{ACCOUNT TOTAL:Payment Accounts}

[TYPE BETALING:2, 1, 2]
{REPORT PAYMENT DETAILS:P.Name,P.Amount.Percent,P.Amount.Sum:Payment.Amount > 0}
>TOTAAL|{REPORT PAYMENT DETAILS:P.Amount.Sum:Payment.Amount > 0}

[CREDIT BETALING:2, 1, 2]
{REPORT REFUND PAYMENTS}

[BAR VERKOOP:1, 1] 
{REPORT ORDER DETAILS:O.User,O.ExactTotal.Sum}
@{REPORT PAYMENT DETAILS:P.User,P.Amount.Sum::{0}:,} 

[AFGEREKEND DOOR $1:1, 1, 1] 
{REPORT PAYMENT DETAILS:P.Name,P.Amount.Percent,P.Amount.Sum:(PU=$1)} 
>BRUTO OMZET|{REPORT PAYMENT DETAILS:P.Amount.Sum:(PU=$1)}

[ITEMS VERKOCHT:5, 2, 2,1]
@{REPORT ORDER DETAILS:O.MenuItemName,O.ExactTotal.Sum.desc:(ODI=True):{0}:,}
>{REPORT ORDER DETAILS:O.MenuItemName,O.Quantity.Sum.desc,O.ExactTotal.Sum.desc:(ODI=True) and O.MenuItemName="$1"}
{REPORT ORDER DETAILS:'     '+[O.PortionName],O.Quantity.Sum.desc,O.ExactTotal.Sum.desc:(ODI=True) and O.MenuItemName="$1":2}

Only in the 6 percent it is showing on order level…?! Why :frowning:

Just to clarify things: I used this to keep track of my low and high tax sales.

So I made a extra sales account where everything that doesn’t contain alcohol is going to low sales (6% tax) and everything with alcohol goes to high sales (21% tax).

For some reason it works on the high (original) sales account, but it gives back every sales transaction on my low sales account.