web
You’re offline. This is a read only version of the page.
close
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 915

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

I have the same question (0)
  • Suggested answer
    Community Member Profile Picture
    Community Member on at

    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

  • Ola Darwish Profile Picture
    Ola Darwish 915 on at

    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

  • Verified answer
    Community Member Profile Picture
    Community Member on at

    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 915 on at

    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

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Small and medium business | Business Central, NAV, RMS

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 2,664

#2
YUN ZHU Profile Picture

YUN ZHU 960 Super User 2025 Season 2

#3
Jainam M. Kothari Profile Picture

Jainam M. Kothari 773 Super User 2025 Season 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans