Skip to main content



No record found.

Microsoft Dynamics SL forum

currency calculations

Posted on by Microsoft Employee


A customer has asked about the calculations used on the Detail GL - MC version because it appears incorrect when compared to the Currency Rate Maintenance by Date screen.

The transactions in question were entered in USD in a database whose base currency is CAD.  The module = IN and the transaction type = BI.  (I don't know what kind of transaction this is.  The help contains no BI transaction type for the inventory module - I'm looking at intran.trantype schema.)

The transaction amount in Base currency is $8199.80, and in USD is $8578.99. The dates are 10/8 and 10/19.

The currency rates from 9/30 would have been in effect.  They use AVG rate type, and that is the only kind of rates I see in the Currency Rate Maintenance by Date screen.

They look like: USD to CAD multiply by by 1.008 and CAD to USD multiply by .992800.

When I do the calculations I get $8140.76 in USD not $8578.99.

Where else can the translated amount be coming from? 

Thank you!

Laura Barber


  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    Re: currency calculations

    Have figured out this is a Flexible Billings Invoice.  The Invoice Date and Deposit Date are both 10/31/2012.  The Invoice was entered 10/18/2012.  on 10/18/2012, the 10/31/2012 AVG currency rate had not yet been entered.

    The 9/30 rate was 1.008 and the 10/31 rate entered on 11/1/2012 was 1.005.

    The GL Detail report is using 1.046.  Where is this coming from?

    Thank you!


Helpful resources

Quick Links

Replay now available! Dynamics 365 Community Call (CRM Edition)

Catch up on the first D365 Community Call held on 7/10

Community Spotlight of the Month

Kudos to Saurav Dhyani!

Congratulations to the June Top 10 community leaders!

These stars go above and beyond . . .


André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 288,459 Super User

Martin Dráb Profile Picture

Martin Dráb 225,783 Super User

nmaenpaa Profile Picture

nmaenpaa 101,148


Featured topics

Product updates

Dynamics 365 release plans