Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics NAV (Archived)

Purchased Items History Report

Posted on by 47

Hi, new to nav 2015, i need to a generate Purchased Items History Report that can be filtered per item or per vendor or order date, how can i get it through NAV 2015? thanks

*This post is locked for comments

  • Verified answer
    fhg-fic Profile Picture
    fhg-fic 47 on at
    RE: Purchased Items History Report

    Thanks, all of the answers have relevant to my queries and help in a way but digging more with NAV led me to this -> Inventory-Purchase Order which has most of the fields I need. Thanks again

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Purchased Items History Report

    Pl. verify the relevant answer, that has helped you.....

  • fhg-fic Profile Picture
    fhg-fic 47 on at
    RE: Purchased Items History Report

    thanks to all for the support, appreciated.

  • Suggested answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Purchased Items History Report

    Hi,

    Try to use Page - 529 (Posted Purchase Invoice Lines).

    You would get all the required details here. Further, extract the relevant information in excel, make the pivot and get the required reporting.

    Hope this helps.

    Best Regards,

    Vishal Salot

  • fhg-fic Profile Picture
    fhg-fic 47 on at
    RE: Purchased Items History Report

    Alexander Ermakov  responded on 17 Feb 2016 10:34 AM  

    You can also drill down to stock value in any item card and then drop filters to see all items, and then filter by purchase type - you will get all the purchased items. which you can filter by dates and by items.

    =====

    Thanks Alex, but if possible the requirement is to list all purchased items history report with item#, desc, ref po#, order_qty, rec_qty, vendor, date that can be filtered to item or vendor or date.

  • fhg-fic Profile Picture
    fhg-fic 47 on at
    RE: Purchased Items History Report

    msalim  responded on 17 Feb 2016 9:11 AM  

    does this answer your question or do you still need assistance?

    =======

    in a way yes, thanks, though better if I could see the qty purchased, received and the PO#. will try if i could find one. thanks

  • fhg-fic Profile Picture
    fhg-fic 47 on at
    RE: Purchased Items History Report

    in a way yes, thanks, though better if I could see the qty purchased, received and the PO#. will try if i could find one. thanks

  • Suggested answer
    Alexander Ermakov Profile Picture
    Alexander Ermakov 28,094 on at
    RE: Purchased Items History Report

    You can also drill down to stock value in any item card and then drop filters to see all items, and then filter by purchase type - you will get all the purchased items. which you can filter by dates and by items.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Purchased Items History Report

    does this answer your question or do you still need assistance?

  • fhg-fic Profile Picture
    fhg-fic 47 on at
    RE: Purchased Items History Report

    Thanks msalim, prior to my post, I already browsed that report but I overlooked the Value Tab at the bottom. thanks again.

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

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,214 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans