Hi Everyone I am using a Shift screen to control and cash my cashiers seperatly using emre shift system but instead of running on different tills it is mapped to diffrent user roles, each with its own cashier. My Cashup screen for each cashier looks as follows:
end of the shift the cashier just enters the count of each Denomination. The button settings are as follows:Ok here is my rub the sustem works fine sofar I used QMcKay cashout screen and rules and modified it to suit my novice abilities. Ok EACH demonination has a value for EACH cashie, thus CO Set 1R200 Value and {SETTING:1R200} for cashier 1 and CO Set 2R200 Value and {SETTING:2R200} for cashier 1. Yeah seriously you can stop laughing i am an idiot and i know it. My Action is as follows:Again an action for each demonination for each cashier. My Rules are:Ok here I have as you can see a CO Set 1R200 Value and a CO Set 1Count Value again for each Cashier and denomination. and my report for the specific cashier :Cashier1 Cashup Report.pdf (64.4 KB)
[ :1,1,1]
>CASHIER1 REPORT
>SALES
Sales||[=F(TN('{ACCOUNT TOTAL:Cash1}')+TN('{ACCOUNT TOTAL:Credit Card1}'),'0.00')]
>SYSTEM TOTALS
Payout||[=F(TN('{ACCOUNT TOTAL:Customer Accounts1}'),'0.00')]
Cash||{ACCOUNT TOTAL:Cash1}
Card||{ACCOUNT TOTAL:Credit Card1}
>TOTAL||[=F(TN('{ACCOUNT TOTAL:Cash1}')+TN('{ACCOUNT TOTAL:Credit Card1}'),'0.00')]
>DECLARED TOTALS
Cash||[=F((TN('{SETTING:1R200}')*200+TN('{SETTING:1R100}')*100+TN('{SETTING:1R50}')*50+TN('{SETTING:1R20}')*20+TN('{SETTING:1R10}')*10+TN('{SETTING:1R5}')*5+TN('{SETTING:1R2}')*2+TN('{SETTING:1R1}')*1+TN('{SETTING:150c}')*0.5+TN('{SETTING:120c}')*0.2+TN('{SETTING:110c}')*0.1),'0.00')]
Card||[=F(TN('{SETTING:1Card}'),'0.00')]
Void||[=F(TN('{SETTING:1Void}'),'0.00')]
Float||[=F( TN('{SETTING:1float}')+TN('{SETTING:1extra}'),'0.00')]
>TOTAL||[=F((TN('{SETTING:1R200}')*200+TN('{SETTING:1R100}')*100+TN('{SETTING:1R50}')*50+TN('{SETTING:1R20}')*20+TN('{SETTING:1R10}')*10+TN('{SETTING:1R5}')*5+TN('{SETTING:1R2}')*2+TN('{SETTING:1R1}')*1+TN('{SETTING:150c}')*0.5+TN('{SETTING:120c}')*0.2+TN('{SETTING:110c}')*0.1)+TN('{SETTING:1Card}')+TN('{SETTING:1Void}')+TN('{ACCOUNT TOTAL:Customer Accounts1}')-TN('{SETTING:1float}')-TN('{SETTING:1extra}'),'0.00')]
>CASH UP AUDIT
>TOTALS
System||[=F(TN('{ACCOUNT TOTAL:Cash1}')+TN('{ACCOUNT TOTAL:Credit Card1}'),'0.00')]
Declared||[=F(TN('{SETTING:1R200}')*200+TN('{SETTING:1R100}')*100+TN('{SETTING:1R50}')*50+TN('{SETTING:1R20}')*20+TN('{SETTING:1R10}')*10+TN('{SETTING:1R5}')*5+TN('{SETTING:1R2}')*2+TN('{SETTING:1R1}')*1+TN('{SETTING:150c}')*0.5+TN('{SETTING:120c}')*0.2+TN('{SETTING:110c}')*0.1+TN('{SETTING:1Card}')-TN('{SETTING:1float}')-TN('{SETTING:1extra}')+TN('{ACCOUNT TOTAL:Customer Accounts1}'),'0.00')]
>Difference||[=F(TN('{SETTING:1R200}')*200+TN('{SETTING:1R100}')*100+TN('{SETTING:1R50}')*50+TN('{SETTING:1R20}')*20+TN('{SETTING:1R10}')*10+TN('{SETTING:1R5}')*5+TN('{SETTING:1R2}')*2+TN('{SETTING:1R1}')*1+TN('{SETTING:150c}')*0.5+TN('{SETTING:120c}')*0.2+TN('{SETTING:110c}')*0.1+TN('{SETTING:1Card}')-TN('{SETTING:1float}')-TN('{SETTING:1extra}')+TN('{ACCOUNT TOTAL:Customer Accounts1}')-TN('{ACCOUNT TOTAL:Cash1}')-TN('{ACCOUNT TOTAL:Credit Card1}'),'0.00')]
>CASH
System||[=F(TN('{ACCOUNT TOTAL:Cash1}'),'0.00')]
Declared||[=F((TN('{SETTING:1R200}')*200+TN('{SETTING:1R100}')*100+TN('{SETTING:1R50}')*50+TN('{SETTING:1R20}')*20+TN('{SETTING:1R10}')*10+TN('{SETTING:1R5}')*5+TN('{SETTING:1R2}')*2+TN('{SETTING:1R1}')*1+TN('{SETTING:150c}')*0.5+TN('{SETTING:120c}')*0.2+TN('{SETTING:110c}')*0.1)+TN('{ACCOUNT TOTAL:Customer Accounts1}')-TN('{SETTING:1float}')-TN('{SETTING:1extra}'),'0.00')]
>Difference||[=F((TN('{SETTING:1R200}')*200+TN('{SETTING:1R100}')*100+TN('{SETTING:1R50}')*50+TN('{SETTING:1R20}')*20+TN('{SETTING:1R10}')*10+TN('{SETTING:1R5}')*5+TN('{SETTING:1R2}')*2+TN('{SETTING:1R1}')*1+TN('{SETTING:150c}')*0.5+TN('{SETTING:120c}')*0.2+TN('{SETTING:110c}')*0.1)+TN('{ACCOUNT TOTAL:Customer Accounts1}')-TN('{SETTING:1float}')-TN('{SETTING:1extra}')-TN('{ACCOUNT TOTAL:Cash1}'),'0.00')]
>CARD
System||[=F(TN('{ACCOUNT TOTAL:Credit Card1}'),'0.00')]
Declared||[=F(TN('{SETTING:1Card}'),'0.00')]
>Difference||[=F(TN('{SETTING:1Card}')-TN('{ACCOUNT TOTAL:Credit Card1}'),'0.00')]
>COUNTS
Tickets||{REPORT TICKET COUNT}
Orders||{REPORT ORDER DETAILS:O.Quantity.Sum:(ODI=True)}
>Amount per Ticket||[=F(TN('{REPORT TICKET TOTAL}')/TN('{REPORT TICKET COUNT}'))]
now my questions:
-
can I do the TN(’{SETTING:count}’) x demonination sum in the Rule itself to free up the need for calculationg each and every denomination?
-
if i can do the calculaions in the Rule do i just call up {SETTING:Rbalance} in the Report to get my totals?
-
otherwise how can i call up my {SETTING:} in the Reporting without having to do all those calculations?
Thanks for taking the time reading my book