Notifications
Announcements
No record found.
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
Hi fhg-fic , try report 313(Vendor\item Purchases)
You can filter on Vendor , Item(Value Tab) and dates.
Thanks msalim, prior to my post, I already browsed that report but I overlooked the Value Tab at the bottom. thanks again.
does this answer your question or do you still need assistance?
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.
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
msalim responded on 17 Feb 2016 9:11 AM
=======
Alexander Ermakov responded on 17 Feb 2016 10:34 AM
=====
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.
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
thanks to all for the support, appreciated.
Pl. verify the relevant answer, that has helped you.....
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.
As AI tools become more common, we’re introducing a Responsible AI Use…
We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…
These are the community rock stars!
Stay up to date on forum activity by subscribing.