Skip to main content
Solved

Customer Purchase History


dougmcbride79
Semi-Pro I
Forum|alt.badge.img

Is there are report or GI in Acumatica where one can see a customers purchase history by item?

Best answer by Kandy Beatty

Here is what the Pivot Table looks like as well

 

View original
Did this topic help you find an answer to your question?

7 replies

Kandy Beatty
Captain II
Forum|alt.badge.img+16
  • Captain II
  • 2183 replies
  • January 9, 2024

Hi @dougmcbride79 

There is not one out of the box, but here is one that is I have used for Invoiced Items that you could use if you would like.

 

I made it into a Pivot Table (these are WAY under used in my opinion in Acumatica) as well!

 

 


Kandy Beatty
Captain II
Forum|alt.badge.img+16
  • Captain II
  • 2183 replies
  • Answer
  • January 9, 2024

Here is what the Pivot Table looks like as well

 


dougmcbride79
Semi-Pro I
Forum|alt.badge.img
  • Author
  • Semi-Pro I
  • 194 replies
  • January 9, 2024

Thank you so much.  Very kind of you.  


Laura02
Captain II
Forum|alt.badge.img+19
  • Captain II
  • 3135 replies
  • January 10, 2024

Hello @dougmcbride79 ,

Did you consider the Sales Profitability Analysis screen? It shows sales order history by customer and item.

Laura


dougmcbride79
Semi-Pro I
Forum|alt.badge.img
  • Author
  • Semi-Pro I
  • 194 replies
  • January 10, 2024

Thank you so much.  


dougmcbride79
Semi-Pro I
Forum|alt.badge.img
  • Author
  • Semi-Pro I
  • 194 replies
  • January 13, 2024

Kandy Beatty: Thank you again.  We have installed your pivot table.  WOW. So helpful.  Our sales team began using it for a long standing issue we had.  Thank you again.  Doug


Kandy Beatty
Captain II
Forum|alt.badge.img+16
  • Captain II
  • 2183 replies
  • January 13, 2024
dougmcbride79 wrote:

Kandy Beatty: Thank you again.  We have installed your pivot table.  WOW. So helpful.  Our sales team began using it for a long standing issue we had.  Thank you again.  Doug

Glad to have helped @dougmcbride79. Again, I think Pivot tables are so under used in Acumatica. I’ve started showing them more recently and the feedback is that most people didn’t even know they existed. 


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings