FrontAccounting forum — Exchange Rate not working (if define manually)

Re: Exchange Rate not working (if define manually)

null@example.com (techhawksglobal) — Tue, 23 Jan 2018 21:30:02 +0000

Dear apmuthu

Thanks alot for instant reply for the query. as you always help everybody at this forum.

As you suggested, I now came to know that currency conversion will not be seen at the input screen as I was expecting . and it can only be observed at backened in GL enteries.

thanks again.

Re: Exchange Rate not working (if define manually)

null@example.com (apmuthu) — Mon, 22 Jan 2018 16:55:18 +0000

Attached is a set of screenshots for a forex purchase invoice and the corresponding forex converted payment along with their views and GL entries.

Re: Exchange Rate not working (if define manually)

null@example.com (apmuthu) — Mon, 22 Jan 2018 16:25:03 +0000

At the time of making the Supplier Invoice entry in USD, there is no conversion needed even if the company currency is in SAR except for the GL entries that would get converted in the Purchases account - check the GL entries for the transaction after Purchase Invoice entry.

Again, when making payment in USD from a cheque drawn on a USD denominated bank account, no conversion is needed except for the GL entries on the purchases / stock inventory accounts - check them as well.

You should have an Exchange Variances Account assigned in Setup => System and General Setup that will be used for Balance Sheet, P&L Account and costing / settlement purposes.

Alternatively, if you entered the exchange rate manually, try to logout and login again and then make the Supplier Invoices and the Payments to Suppliers. This is assuming you are plagued with some browser cache - set the browser options to clear cache on exit.

Re: Exchange Rate not working (if define manually)

null@example.com (techhawksglobal) — Mon, 22 Jan 2018 10:13:14 +0000

Both Supplier and Purchase Invoice enter are NOT in USD.
Supplier currency is in USD but the company base currency is Saudi Riyal (SAR). The Purchase price of item is also defined in USD in Item master input screen.
so while making a direct Inovice, system picks the amount in USD but not converting in SAR when we are adding item in list.

Re: Exchange Rate not working (if define manually)

null@example.com (apmuthu) — Mon, 22 Jan 2018 04:00:20 +0000

Since both Supplier Currency and Purchase Invoice entry are in USD, there is no conversion needed. Make sure you have entered it in USD Amounts too in both cases. Hopefully, if you pay the Supplier from your USD Bank Account, then too there will not be any exchange rate conversion. Only in the Balance Sheet and P&L Account will it reflect in Saudi Riyal after conversion. Make sure your exchange rate is entered preferably a day earlier (may be there might be some glitch there - but no one has complained so far).

Exchange Rate not working (if define manually)

null@example.com (techhawksglobal) — Sun, 21 Jan 2018 22:28:31 +0000

we have newly setup FA in our organization. We have defined conversion rates manually in Banking and General Ledger-->Maintenance--> Exchange Rates

Company Currency is Saudi Riyal
and for USD
"Date to Use From:" 01-Jan-2017
"Exchange Rate:" 3.75

If we are making a Direct Purchase Invoice Entry from Purchase module for a supplier having currency in USD.
Item is also defined in USD for this supplier. but currency conversion is not happening when we are adding any item in the list.

Can anyone identify what I'm missing that currency conversion is not happening.
Kindly help.