Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Small and medium business | Business Central, N... / AP Aged TB with actual...
Small and medium business | Business Central, N...
Answered

AP Aged TB with actual FX rate on the transaction

(0) ShareShare
ReportReport
Posted on by Ola Darwish 905

Hi 

i m using multiple foreign currencies in my AP subledger.  sometimes user changes the FX rate on the transaction so its different from the currency FX rate in the currency exchange table.  

When I tried printing Aged AP report in home currency. I realized that it coverts all FX amount into home currency using the rate on the currency table not the rate that has been used in the transaction and ultimately posted to GL. Is there a way to print the Aged AP in home currency without the system converting the foreign currency amounts using exchange rate in the currency table rather than the exact exchange rate used in the tranaction?

Thanks 

Ola

Categories:
Financial Management
Purchasing
  • Ola Darwish Profile Picture
    Ola Darwish 905 on at
    RE: AP Aged TB with actual FX rate on the transaction

    Thanks Chris

    I m very surprised by how the report was built and I really cant understand the reason behind that.  Im also surprised that no one commented about that before

  • Verified answer
    Community Member Profile Picture
    Community Member 525 Microsoft Employee on at
    RE: AP Aged TB with actual FX rate on the transaction

    Ola,

    Ugh. The best I can think of is to create a Power BI or Jet Report to pull the detailed transaction and you have a column of data referencing the 1.3 rate vs. transaction rate.

    You could look at taken Vendor Ledger Entries and include Balance and Balance ($) to reflect USD and EURO posted values.

    Hope this helps.

    Thanks,

    Steve

  • Ola Darwish Profile Picture
    Ola Darwish 905 on at
    RE: AP Aged TB with actual FX rate on the transaction

    Hi Chris,

    Thank you for your reply.  Yes I did, but this will print amounts in the Vendor foreign currency. I need all foreign currencies to be printed in home currency as per the rate used in each transaction.

    so if my home currency is USD and i have a EUR transaction

    Exchange rate in Euro currency table is 1.3 but user for this transaction used 1.4

    i want the report to show the transaction in USD amount using 1.3 exchange rate as this is what has been posted to the GL

    Thanks

    Ola

  • Suggested answer
    Community Member Profile Picture
    Community Member 525 Microsoft Employee on at
    RE: AP Aged TB with actual FX rate on the transaction

    Ola,

    Did you run the Aged Accounts Payable report with the Options turned on for 'Print Amount in Vendor Currency' and 'Print Detail'. Each document will show Document Currency in the last column.

    Hope this helps.

    Thanks,

    Steve

    pastedimage1613398990449v1.png

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Dynamics 365 Community Update – Sep 16th

Welcome to the next edition of the Community Platform Update. This is a weekly…

Announcing Our 2024 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Dynamics 365 Community Newsletter - September 2024

Check out the latest community news

more Community News

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 283,860 Test role Public

#2
Ludwig Reinhard Profile Picture

Ludwig Reinhard 229,831 Microsoft Employee

#3
Martin Dráb Profile Picture

Martin Dráb 225,155 Moderator

Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans