Solved

Purchasing Report - Most purchased material

  • 20 June 2023
  • 3 replies
  • 33 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. 

 

icon

Best answer by Kandy Beatty 20 June 2023, 21:17

View original

3 replies

Userlevel 7
Badge +16

HI @hvanorstrand 

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

 

Here is the XML for that:

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

 

Userlevel 7
Badge +16

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. 

Reply


About Acumatica ERP system
Acumatica Cloud ERP provides the best business management solution for transforming your company to thrive in the new digital economy. Built on a future-proof platform with open architecture for rapid integrations, scalability, and ease of use, Acumatica delivers unparalleled value to small and midmarket organizations. Connected Business. Delivered.
© 2008 — 2024  Acumatica, Inc. All rights reserved