Skip to main content
Answer

Reporting showing Sales by customer by month with GL account

  • March 30, 2023
  • 3 replies
  • 254 views

jbuddecke71
Varsity I
Forum|alt.badge.img

Is there a standard report or inquiry that will show Sales by customer by month by GL account?

Best answer by Kandy Beatty

HI @jbuddecke71 

There is nothing out of the box for Sales Orders. 

Have you looked at the AR Balance by GL Account? It will show invoices though. You could create a new report based off this one. 

 

Or the Sales Order Details by Customer, you would need to add the GL accounts to:

 

3 replies

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

HI @jbuddecke71 

There is nothing out of the box for Sales Orders. 

Have you looked at the AR Balance by GL Account? It will show invoices though. You could create a new report based off this one. 

 

Or the Sales Order Details by Customer, you would need to add the GL accounts to:

 


jbuddecke71
Varsity I
Forum|alt.badge.img
  • Author
  • Varsity I
  • March 31, 2023

Thanks Kandy. I considered that one but I believe it only shows open items. I think the client wants a different format too. I will probably create something new.


  • November 6, 2024

Hello- did you ever create this report? I am looking for something similar.