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 …