As I understand, all items must be currently priced in base currency only? If so, this makes simple things really complicated and basically makes ZOHO invoicing impossible to use for companies selling products in many currencies!
A working solution would be to allow ITEMS to be set in any valid system currency. Then based on the customer currency settings, the invoicing would do the exchange rate conversion accordingly:
1. If customer currency IS item currency, no visible conversion in invoice will be done (however, the system would convert this invoice to base currency for reports and dashboards)
2. If customer currency IS NOT item currency, the corresponding item in invoice will be converted to customer currency according to the active exchange rate.
3. To balance all this with actual payments (exchange currency has been changed between the invoice writing and customer payment) a new value: Exchange rate difference (+ or -) will be added automatically to payments and dashboards.
Base currency €
Customer currency $
Original invoice in customer currency $ 100 (in system € 75) by date xx.xx.xxxx
Payment from client $ 100 = € 73 on date xx.xx.xxxx
The difference € -2 is booked as Exchange rate difference in to the system
These improvements should be applied ASAP to really support multi currency invoicing.
Thanks,
Niko