asked on

Access Foreign Currency invoices

Hi

I have an Access database used for invoicing customers. A need has arisen to invoice a few customers in other currencies.
How would I store the data in my Invoices table? Should I store local currency in the tables and generate invoice documents in the foreign currency?
I am looking for a simplistic way to achieve this?
Should I use a table to store the exchange rate for each invoice?
Just looking for a few pointers
Thanks

SOLUTION

Sujith

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

SOLUTION

Pavel Celba

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

John Tsioumpris

In my previous company we did a lot of international sales...the solution a simple table with the exchange rate along with the needed currency symbols..

Murray Brown

ASKER

Thanks John so I am assuming that the Invoices table in that scenario would only hold local currency and then when Invoices are generated you use a conversion that looks at the data you mentioned

ASKER CERTIFIED SOLUTION

John Tsioumpris

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

mbizup

An alternative would be to have a lookup table for currency symbols, and handle the exchange rate on the fly by working in a function to lookup an up-to-date exchange rate. The invoice date could serve as a date stamp for the exchange rate, or you could add a dedicated field for this. Here are a couple of examples of exchange rate lookups using Yahoo's currency converter (in the second you may need to remove the indentations and whitespace between lines to get it to compile if you copy/paste it into Access). In both cases, you need to use the standard currency symbols:

http://access-excel.tips/get-exchange-rate-using-vba-access-function/
https://desmondoshiwambo.wordpress.com/2014/06/27/how-to-get-the-current-exchange-rateconvert-currency-in-access-excel-and-vba-using-yahoo-finance/

Scott McDaniel (EE MVE )

In most of the ERP applications I deal with, the value is stored as the LOCAL currency, with a Currency_Conversion_Rate field included. Since conversion rates change, you need the rate at the time the Invoice is created in order to accurately determine the converted cost.

Conversion rates are stored in a table, and code grabs the newest conversion when an invoice is entered. If the currency definition are the same (USD to USD, for example) then the conversion rate is 1.