Skip to Content

Query Help Customer Sales/Invoice

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%
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

0 Answers