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

(1) Share

Report

Posted on by joshtechsolutions

4,376

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!

All responses (3)

Answers (1)

Verified answer

YUN ZHU 74,036 Super User 2024 Season 2 on at

Like (1)

Report

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

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
Suggested answer

Valentin Castravet 24,910 Super User 2024 Season 2 on at

Like (3)

Report

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

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/
gdrenteria 12,290 Most Valuable Professional on at

Like (1)

Report

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

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