Skip to main content
Solved

Purchasing Report - Most purchased material

  • June 20, 2023
  • 3 replies
  • 106 views
  • Translate All

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:

View original

3 replies

Kandy Beatty
Captain II
Forum|alt.badge.img+18

HI @hvanorstrand 

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

 

Here is the XML for that:

Translate

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

 

Translate

Kandy Beatty
Captain II
Forum|alt.badge.img+18

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. 

Translate