Skip to main content

Notifications

Small and medium business | Business Central, N...
Answered

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

Posted on by 4,332
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!
  • Verified answer
    YUN ZHU Profile Picture
    YUN ZHU 71,953 Super User 2024 Season 2 on at
    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)
     
    Thanks.
    ZHU
  • Suggested answer
    Valentin Castravet Profile Picture
    Valentin Castravet 24,061 Super User 2024 Season 2 on at
    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.
     
  • gdrenteria Profile Picture
    gdrenteria 11,307 Most Valuable Professional on at
    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.
     
    Best
    GR

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

November Spotlight Star - Khushbu Rajvi

Congratulations to a top community star!

Forum Structure Changes Complete!

🔔 Be sure to subscribe to the new forums you are interested in to stay up to date! 🔔

Dynamics 365 Community Platform update – Oct 28

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

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 290,912 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 229,355 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans