Small and medium business | Business Central, N...

Sales invoice in $ but LCY (AED) shows $ amount

(0) Share

Report

Posted on by mohsenask

8080.Screenshot-2020_2D00_05_2D00_17-14.20.55.png 1881.Screenshot-2020_2D00_05_2D00_17-14.18.38.png

Im very new to Dynamics

Ive created multiple sales invoices in various currencies. $, €, AED - the Base currency of the company is AED

On the main Insight pages, it shows the amount as a sum of all invoices but currency as AED without converting the other currencies into AED. Similarly the sales invoice list also shows the currency as $ but under LCY shows the amount as the $ amount instead of converting.

Exchange rates are setup

please help

I have the same question (0)

All responses (7)

Answers (0)

Sort by

SThakur 414 on at

Like (0)

Report
Copy link

Link copied!

Hi,

Looks like a screenshot from within Dynamics Business Central. Is that the case?

Could you share the screenshot of your currency exchange rates setup?

Have you setup the adjustment exchange rates to update the exchange rates periodically?

Thanks,

Shilpi

Was this reply helpful? Yes No
mohsenask 10 on at

Like (0)

Report
Copy link

Link copied!

Hi Shilpi

Thanks for your reply

Yes its Dynamics Business Central

Ive updated the adjustment exchange rates and run the job too. Screenshots attached

Was this reply helpful? Yes No
SThakur 414 on at

Like (0)

Report
Copy link

Link copied!

There is a separate forum for Dynamics 365 Business Central, if you post your question at that forum you might get quick response.

What was the currency code you used for the adjustment batch job on the day you posted the adjustment?

Your adjustment exchange rate is 0.00 for 13/01/2020 so it seems your adjustment batch job did not generate the results as your were expecting.

The posting date [ which specifies the date on which adjustment entries are posted ]of the sales invoices as per your screenshot range from 15/01/2020 to 1/04/2020, but the adjustment batch job date 13/01/2020 displays value 0.00 so it picked up the LCY .

Can you check the adjustment exchange rate entries for the posted date and also the G/L [gains and losses] account entries?

Was this reply helpful? Yes No
mohsenask 10 on at

Like (0)

Report
Copy link

Link copied!

I assumed that the job will pick up the last exchange rate which was for 6th May. However I updated the rate for all dates, and ran the job for both currencies ; AED and USD

I don't see any entries in any of the G/L accounts either. This is driving me crazy :-(

Was this reply helpful? Yes No
Ludwig Reinhard Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

moved to the bc forum

Was this reply helpful? Yes No
Suggested answer

Marco Mels Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hello,

If you do not get further traction on this forum, then please raise a support request to Microsoft support for further analysis. You can do this via your CSP or Dynamics partner.

Thanks.

Was this reply helpful? Yes No
mohsenask 10 on at

Like (0)

Report
Copy link

Link copied!

Could it be that the invoices have already been posted?? and the adjustment should be applied before posting those invoices??

Was this reply helpful? Yes No