Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Finance | Project Operations, Human Resources, ... / purchTable - entity
Finance | Project Operations, Human Resources, ...
Suggested answer

purchTable - entity

(1) ShareShare
ReportReport
Posted on by KP-08101030-0 83
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 83 on at
    purchTable - entity
    Doesnt work on joining with exchangerateentity because the rates may have been updated
  • KP-08101030-0 Profile Picture
    KP-08101030-0 83 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 2,179 Super User 2025 Season 1 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 83 on at
    purchTable - entity
    Hi Jonas, below you can see exchange rate
     
  • Jonas "Jones" Melgaard Profile Picture
    Jonas "Jones" Melgaard 2,179 Super User 2025 Season 1 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 83 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 2,179 Super User 2025 Season 1 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

Quick Links

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Vahid Ghafarpour – Community Spotlight

We are excited to recognize Vahid Ghafarpour as our February 2025 Community…

Congratulations to the January Top 10 leaders!

Check out the January community rock stars...

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 292,234 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 230,994 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans