Skip to main content
Answer

Purchasing Report - Most purchased material

  • June 20, 2023
  • 3 replies
  • 39 views

Does anyone know of a report that shows how much of something we have ordered over a large period of time? 

Looking to see what are most used material is and average cost we are spending on it. 

**Not sure if this makes a difference, but most of our orders are drop ships, so this wouldn’t be reflected through our inventory. 

 

Best answer by Kandy Beatty

HI @hvanorstrand 

There is a Purchased Products Per Year G in Acumatica, you could use that.

 

Here is the XML for that:

3 replies

Kandy Beatty
Captain II
Forum|alt.badge.img+17
  • Captain II
  • Answer
  • June 20, 2023

HI @hvanorstrand 

There is a Purchased Products Per Year G in Acumatica, you could use that.

 

Here is the XML for that:


  • Author
  • Freshman I
  • June 20, 2023

This would be perfect! Where are you finding that report?

 


Kandy Beatty
Captain II
Forum|alt.badge.img+17
  • Captain II
  • June 20, 2023

This would be perfect! Where are you finding that report?

 

It’s under the Purchasing Manger Dashboard. Top Products is the name of the chart.