Skip to main content

Notifications

Announcements

No record found.

Small and medium business | Business Central, N...
Suggested answer

finding item history Purchase Price which is not in local currency

(0) ShareShare
ReportReport
Posted on by 188

We are using AUD as local currency, all our item purchase prices are in USD, what is the quicker way to find the last buy prices by date, by quantity and by vendor?

We have been looking for it under Vendor>Related>History, could not find the original buy price in USD currency:

 pastedimage1664574738148v1.png

  • LaserCopr Profile Picture
    LaserCopr 188 on at
    RE: finding item history Purchase Price which is not in local currency

    thanks Zhu for this, but the report still showing in Local Currency

    Purchase-Price-in-USD----Item-List_5F00_Report_5F00_Purcahse_5F00_Vendor-Item-Purchases.png

    Is there a report similar as below Sales Line report, but for Purchase?

    2022_2D00_05_2D00_17-11_5F00_10_5F00_16_2D00_Sales-Lines-_2D00_-Wiise.png

  • Suggested answer
    YUN ZHU Profile Picture
    YUN ZHU 74,117 Super User 2024 Season 2 on at
    RE: finding item history Purchase Price which is not in local currency

    Hi, How about using Vendor/Item Purchases report?

    pastedimage1652747510872v1.png

    pastedimage1652747528277v2.png

    pastedimage1652747538506v3.png

    Hope this helps.

    Thanks.

    ZHU

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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Verified Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,405 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,455 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans