Skip to main content
Solved

Reporting showing Sales by customer by month with GL account

  • March 30, 2023
  • 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

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

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