Skip to main content
Solved

Reporting showing Sales by customer by month with GL account

  • Mar 30, 2023 5:33 PM UTC
  • 3 replies
  • 321 views
  • Translate All

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:

 

View original

3 replies

Kandy Beatty
Captain II
Forum|alt.badge.img+18
  • Captain II
  • Answer
  • Mar 30, 2023 6:24 PM UTC

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:

 

Translate

jbuddecke71
Varsity I
Forum|alt.badge.img
  • Author
  • Varsity I
  • Mar 31, 2023 12:58 PM UTC

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.

Translate

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

Translate