Skip to main content

Notifications

Announcements

Forum Structure Changes Coming Soon!
News and Announcements icon
Dynamics 365 Community / Forums / Finance forum / purchTable - entity
Finance forum
Suggested answer

purchTable - entity

(1) ShareShare
ReportReport
Posted on by KP-08101030-0 59
Hello Friends,
 
wanted to know if we have an entity related to the table PurchTable. I have a report whereby i need to have the exchange rate. 
 
Any guidance please.
 
Thanks
 
  • KP-08101030-0 Profile Picture
    KP-08101030-0 59 on at
    purchTable - entity
    Hi Jonas
     
    I think what i will do is join on the ExchangeRateEntity on Transaction date.
     
    Will try and see if i can retrieve the exchange rate which was used at the transaction date.
  • Jonas "Jones" Melgaard Profile Picture
    Jonas "Jones" Melgaard 1,522 on at
    purchTable - entity
    I misspoke, you have a fixed exchange rate on the purchase order, the field is called ExchRateFixed. But it's only used for invoicing. That field is in the "PurchTableBiEntity" entity. But I do wonder if this is a customization that field you are showing, because it's normally not visible nor filled out.
     
    No purchase order entity will not return the exchange rate if it is not specified. Normally that value comes from exchange rates in F&O.
    If you have to use an entity, you will have to make a customization to the entity to add currency as a calculated field.
  • KP-08101030-0 Profile Picture
    KP-08101030-0 59 on at
    purchTable - entity
    Hi Jonas, below you can see exchange rate
     
  • Jonas "Jones" Melgaard Profile Picture
    Jonas "Jones" Melgaard 1,522 on at
    purchTable - entity
    I assume you mean this?
     
    You only have the currency in the standard application, not a fixed exchange rate.
    Can you send a screen shot of what you see?
  • KP-08101030-0 Profile Picture
    KP-08101030-0 59 on at
    purchTable - entity
    Hi Jones
     
    Thank you for your prompt reply. 
     
    But then where can i retrieve the exchange rate that was used. I can see it on the screen  under price and discount section which refers to the purctable.
     
    What would suggest
     
    Thanking you in advance
     
     
  • Suggested answer
    Jonas "Jones" Melgaard Profile Picture
    Jonas "Jones" Melgaard 1,522 on at
    purchTable - entity

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

News and Announcements

Forum Structure Changes Coming Soon!

Quick Links

Forum Structure Changes Coming on 11/8!

In our never-ending quest to help the Dynamics 365 Community members get answers faster …

Dynamics 365 Community Platform update – Oct 28

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

Replay: Dynamics 365 Community Call ERP Edition | October 9, 2024

Another great gathering of our Community!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 229,021 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,150

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans