I am looking for a report to find most frequently purchased items in D365O. I have seen the Vendor Statistics reports, but I think this only gives the amounts that have already been invoiced by the vendor.
Is there a report will show all items that have been ordered over a period of time, but not necessarily invoiced?
Take a look to Procurement and sourcing\Purchase orders\Purchase order follow-up\Open purchase order by item report, you can modify the filter in the Records to include section, clear Line status = Open order and that would give you all the information, you may need to modify the report to fit your needs, but this report will show you how many times an item was purchased with the date, PO, vendor, item #, etc
Thanks Hector! I am there, but for some reason I cannot remove the criteria or delete the range. Any ideas?
Hi Kristine… I didn’t notice it is a “fixed” filter, I was searching if there is a way to change this kind of filter with no succeed… I hope you can find the way. Maybe you should export the purchase order lines entity and make your own data analysis
Hi Hector, thanks for the reply. I realized I couldn’t change or delete the filter. I will see if I can find the set up to maybe change the setting. Also will try your export idea.
Appreciate your help! If I figure it out I will let you know.
Is there a way to pull a report for both open and closed POs by part number?