For example I want to use base_grand_total
. I know that this value is displayed in the base currency on paper.
I have the data at sales_flat_order
:
base_cur. global_cur. order_cur. store_cur. base_to_gl_rate base_to_ord_rate store_to_base_rate store_to_ord_rate
CZK CZK CZK CZK 1.0000 1.0000 1.0000 1.0000
EUR EUR EUR EUR 1.0000 0.0385 1.0000 0.0385
CZK CZK CZK CZK 1.0000 1.0000 1.0000 1.0000
PLN PLN PLN PLN 1.0000 0.1667 1.0000 0.1667
The Base Currency of Website is CZK.
In which currency magento keeps the base_grand_total
values in this case? Order currencies?
EDIT.
What currency is used if base and order currencies are different?
For example, base currency CZK, order currency EUR.
Thank you!
Best Answer
normally the
base_grant_total
(and all other fields that begin withbase_
) are kept in the value you set for default currency in the backend in system->configuration.The
grant_total
is kept in the currency used to place the order.