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, 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
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
Pl. verify the relevant answer, that has helped you.....
thanks to all for the support, appreciated.
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
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.
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
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
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.
does this answer your question or do you still need assistance?
Thanks msalim, prior to my post, I already browsed that report but I overlooked the Value Tab at the bottom. thanks again.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
André Arnaud de Cal... 291,280 Super User 2024 Season 2
Martin Dráb 230,214 Most Valuable Professional
nmaenpaa 101,156