Skip to Content
0

Query Help Customer Sales/Invoice

Nov 30, 2016 at 04:32 PM

31

avatar image

Hello, i'm new to this forum but wondering if someone is able to help me or has possibly done this before? I searched the forum but couldn't find anything similar to this.

I am after a query that can display the following if possible.

List all Customers.

  • Current month total sales/invoice including GP%
  • Last Months total sales/invoice including GP%
  • Last 12 months total sales/invoice including GP%
  • 3 month average of sales/invoice including GP%
  • 6 month average of sales/invoice including GP%
10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

0 Answers