Why is the GP and GP % different in Sales by Customers and Sales by Products?

This is caused by the following reason:

  • Sales by Customer uses Standard Cost Price to determine the GP$ and GP%
  • Sales by Product uses Average Cost to determine the GP$ and GP %

The Customer Sales Report shows sales for all "shipped and invoiced" orders whereas the Product Sales Report shows all sales for "shipped" orders.