A few questions regarding the values in the Vendor Ledger Entries..

(1) Share

Report

Posted on by joshtechsolutions

5,085

Hi Community,

I would like to find out..

For below case, where Currency is USD

1. How would I know how much is the currency exchange rate if I don't go to currencies and check?

2. How come the value in the Remaining amount and the value in the Amount doesn't match?

3. What can I do to investigate what else is not done yet hence it was not match?

Appreciate your guidance and if possible screenshots.

Thank you!

I have the same question (0)

All responses (3)

Answers (1)

Sort by

Gerardo Rentería Ga... 27,052 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!

Hi

Where does this transaction come from?
Having the USD currency code explicitly in the record indicates that it is not the local currency (this value would be empty). Therefore, you must go to the list of currencies and there is an exchange rate section. You could use the Currency Factor field to identify the exchange rate.

Convert foreign currency to local base currency - Dynamics NAV | Microsoft Learn

Best

GR

Was this reply helpful? Yes No
Suggested answer

Valentin Castravet 32,741 Super User 2026 Season 1 on at

Like (3)

Report
Copy link

Link copied!

1. You can use the 'Original Currency Factor' field, which stores the exchange rate used for the transaction. If you run the Adjust Exchange Rate batch job at month-end, you can also use the 'Adjusted Currency Factor' field. These fields are not visible on the page by default, but they do exist in the underlying table.

2. In your case, it appears to be a vendor ledger entry for an invoice. The entry indicates you have an invoice for 40,000 that you need to pay the vendor. The remaining amount is 9,000, which means you’ve already paid the vendor 31,000. You created a payment for 31,000 and applied it to the invoice. The only time the two amounts will match is when the entry is created and no payment has been applied yet.

3. If you select the entry and click on 'Applied Entries,' you can see the vendor ledger entry corresponding to the 31,000 payment that has been applied.

Valentin Castravet
Work: Zander ERP Services
Blog: Dynamics 365 Business Central Insights
LinkedIn: www.linkedin.com/in/valentin-c-0500a247/

Was this reply helpful? Yes No
Verified answer

YUN ZHU 101,643 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!

Just adding some information. The Currency Factor field already exists on the purchase order and posted purchase invoice.

This is also available in Vendor Ledger Entries.

PS: Business Central 2023 wave 2 (BC23): Add existing table fields to optimize your pages (Adding Table Fields to Page without Page Extensions)

https://yzhums.com/43183/

Thanks.

ZHU

Was this reply helpful? Yes No