Hi everyone. I need help about showing currency total in my reports.
I have TL, $, €, £ as cash payment options. As you can see from picture below, all my foreign currency payments are converted to TL. I want to see them as foreign currency.
Hi friend. No, this is only adding symbols before payments. $,€,£ still converted to TL in report.
What i need is i want to see the amount of foreign currency in reports. The picture that i gave shows me TL exchange of currencies. Report need to be something like this ;
>Income Totals||
Cash||{ACCOUNT DEBIT TOTAL:Cash}
Dollar||$ {ACCOUNT DEBIT TOTAL:Dollar Cash} **648TL / Dollar rate = The currency in my case**
GBP||£ {ACCOUNT DEBIT TOTAL:Gbp Cash} **605TL / GBP rate = The currency in my case**
Euro||€ {ACCOUNT DEBIT TOTAL:Euro Cash} **787.50TL / Euro rate = The currency in my case**
Credit Card||{ACCOUNT DEBIT TOTAL:Credit Card}
I need this because i am accepting foreign currencies but at the end of day i do not know how much dollar, euro, pound i got in my case.
Thank you for your help.
Our local currency is TL. So i have diffrent currency for same payment type. if a table bill is 100TL, i have option for customer to pay this 100tl exchange of $,€,£. I got some help with this line and this is what i want ;
Did you manage? I use a similar setup, I can help you. I have different rates for each payment type. I created a multi currency report which shows me totals already converted to foreign currency.
Hello, I use this report, you will have to know your account IDs for your payment accounts then replace my currencies with yours
[Multi Currency Report:2, 1, 1, 1]
>Currency||Amount
USD Cash||[=F(TN('{ACCOUNT TRANSACTION TOTAL:Payment Transaction:Cash}')+TN('{ACCOUNT TRANSACTION TOTAL:Customer Cash Payment:Cash}'))]
INT CC||[=F(TN('{REPORT SQL DETAILS:SELECT SUM(ROUND(Exchange, 3)) as [Total] FROM AccountTransactionValues where AccountId = 588 and [Date] > '{Start}' and [Date] < '{End}':F.Total}'))]
Zim Switch|[=F(TN('{REPORT SQL DETAILS:SELECT SUM(ROUND(Exchange, 2)) as [Total] FROM AccountTransactionValues where AccountId = 6 and [Date] > '{Start}' and [Date] < '{End}':F.Total}'))]
Ecocash|[=F(TN('{REPORT SQL DETAILS:SELECT SUM(ROUND(Exchange, 2)) as [Total] FROM AccountTransactionValues where AccountId = 7 and [Date] > '{Start}' and [Date] < '{End}':F.Total}'))]
Bond| [=F(TN('{REPORT SQL DETAILS:SELECT SUM(ROUND(Exchange, 2)) as [Total] FROM AccountTransactionValues where AccountId = 582 and [Date] > '{Start}' and [Date] < '{End}':F.Total}'))]
>Totals (Exc USD)|[=F(TN('{ACCOUNT TOTAL:LOYAL}')+TN('{REPORT SQL DETAILS:SELECT SUM(ROUND(Exchange, 2)) as [Total] FROM AccountTransactionValues where AccountId = 6 and [Date] > '{Start}' and [Date] < '{End}':F.Total}')+TN('{REPORT SQL DETAILS:SELECT SUM(ROUND(Exchange, 2)) as [Total] FROM AccountTransactionValues where AccountId = 7 and [Date] > '{Start}' and [Date] < '{End}':F.Total}')+TN('{REPORT SQL DETAILS:SELECT SUM(ROUND(Exchange, 2)) as [Total] FROM AccountTransactionValues where AccountId = 582 and [Date] > '{Start}' and [Date] < '{End}':F.Total}')+TN('{REPORT SQL DETAILS:SELECT SUM(ROUND(Exchange, 2)) as [Total] FROM AccountTransactionValues where AccountId = and [Date] > '{Start}' and [Date] < '{End}':F.Total}'))]
>Total USD Cash||[=F(TN('{ACCOUNT TRANSACTION TOTAL:Payment Transaction:Cash}')+TN('{ACCOUNT TRANSACTION TOTAL:Customer Cash Payment:Cash}'))]
>Total Int CC|| [=F(TN('{REPORT SQL DETAILS:SELECT SUM(ROUND(Exchange, 2)) as [Total] FROM AccountTransactionValues where AccountId = 588 and [Date] > '{Start}' and [Date] < '{End}':F.Total}'))]
>Totals (Inc USD)|[=F(TN('{ACCOUNT TOTAL:LOYALTY CARD}')+TN('{REPORT SQL DETAILS:SELECT SUM(ROUND(Exchange, 2)) as [Total] FROM AccountTransactionValues where AccountId = 6 and [Date] > '{Start}' and [Date] < '{End}':F.Total}')+TN('{REPORT SQL DETAILS:SELECT SUM(ROUND(Exchange, 2)) as [Total] FROM AccountTransactionValues where AccountId = 7 and [Date] > '{Start}' and [Date] < '{End}':F.Total}')+TN('{REPORT SQL DETAILS:SELECT SUM(ROUND(Exchange, 2)) as [Total] FROM AccountTransactionValues where AccountId = 588 and [Date] > '{Start}' and [Date] < '{End}':F.Total}')+TN('{REPORT SQL DETAILS:SELECT SUM(ROUND(Exchange, 2)) as [Total] FROM AccountTransactionValues where AccountId = 582 and [Date] > '{Start}' and [Date] < '{End}':F.Total}')+TN('{REPORT SQL DETAILS:SELECT SUM(ROUND(Exchange, 2)) as [Total] FROM AccountTransactionValues where AccountId = 5 and [Date] > '{Start}' and [Date] < '{End}':F.Total}'))]
>|
>Fill In Today's Rate:||