Show default currency on invoice as well as currency used?

Hi,

I wonder if anyone can help me.
My store has 5 available currencies £GBP (default), US$, CAN$, AUS$ and Euro.

Whenever someone places an order in a currency other than £GBP their currency shows on the invoice which is fine but it makes it difficult for me when it comes to tax time. I keep copies of all invoices incase I ever need to produce them for tax purposes, but because they don't show the GBP equivalent on them it isn't clear how much the order total is.

what I would like to do is keep the invoice as is but under order total add an extra section for order total in GBP.

An even better option would be if I could leave the customers invoice as is and only include the GBP equivalent on the admin invoice.

Any ideas or advice would be greatly appreciated.

Thanks

Does anyone have any ideas how I can do this?

I could aslo do with this.

I sell in British Pounds, but my VAT has to be calculated in Euros, so something like was Phil suggests would save a lot of people a great deal of time when calculating exchange rates. At the moment I am doing it on a daily basis, and tbh, is a right pain in the bum. :P

All thats needed really, is to be able to show 2 currencies on the admin invoice. I have tried to do it, but its not happening for me. I tried to go by how its done in the 'Display Different Currencies' module.

Any help appreciated

regards

DB

Hi,
When I log into my admin control panel goto customers-->orders and open an order the middle panel that shows the address, payment method, payment currency, paypal fees etc has a place for exchange rate but there is no value entered for it. How can I get the exchange rate to display on the order pages?

Thanks

Your duplicate posts have been merged.> Phil020782:

Hi,
When I log into my admin control panel goto customers-->orders and open an order the middle panel that shows the address, payment method, payment currency, paypal fees etc has a place for exchange rate but there is no value entered for it. How can I get the exchange rate to display on the order pages?You're talking about the "gray" table that shows information about the order as reported from PayPal.
I wouldn't advise messing with that.
Phil020782:

Hi,I wonder if anyone can help me.
My store has 5 available currencies £GBP (default), US$, CAN$, AUS$ and Euro.

Whenever someone places an order in a currency other than £GBP their currency shows on the invoice which is fine but it makes it difficult for me when it comes to tax time. I keep copies of all invoices incase I ever need to produce them for tax purposes, but because they don't show the GBP equivalent on them it isn't clear how much the order total is.

what I would like to do is keep the invoice as is but under order total add an extra section for order total in GBP.

An even better option would be if I could leave the customers invoice as is and only include the GBP equivalent on the admin invoice.

/admin/orders.php
Around line 418 you've got this section of code:<tr> <td class="main"><strong><?php echo ENTRY_ORDER_ID . $oID; ?></td> </tr>Change that to this:```
<tr>
<td class="main"><strong><?php echo ENTRY_ORDER_ID . $oID; ?></strong>
<div align="right"><?php if ($order->info['currency'] != DEFAULT_CURRENCY && $order->info['currency_value'] != 1 && $currencies->get_value(DEFAULT_CURRENCY) == 1) echo 'Prices in ' . $order->info['currency'] . ' — Exchange Rate: 1 x ' . DEFAULT_CURRENCY . ' = ' . $order->info['currency_value'] . ' ' . $order->info['currency']; ?> </div></td>
</tr>

Thanks Dr. Byte,
That has sorted the issue with adding the exchange rate to the order page but I still need to add the GBP eqivalent order total to the invoice.

I've located from the database that the value I need to callup on the invoice is field "order_total" from table "orders" because this value is always the default currency regardless of the currency used for the order.

Please could you help with this issue too?

Thanks

echo $order->info['order_total']

Still can't get it to work, I assume the file to change is admin/invoice.php?

I tried adding the code you suggested, no change.

I also tried adding the following code:

<?php
$order_check = $db->Execute("select order_total
                             from " . TABLE_ORDERS . "
                             where orders_id = '" . (int)$oID . "'");
							 
							 echo $order->info['order_total']
?>

That didn't work either

Apparently I misunderstood what you were asking for.

/admin/invoice.php
At line 202, insert this new line, as shown:```
?>
[B]<tr align="right"><td colspan="2"><br /><?php echo $order->info['total'] . ' ' . DEFAULT_CURRENCY; ?></td></tr>[/B]
</table></td>
</tr>
</table></td>

That worked like a dream thanks