Report Inconsistencies?

Report vs. Report

FEEL FREE TO ADD TO THIS, MORE REPORT COMPARISON EXPLANTIONS WILL ALWAYS BE USEFUL

Detailed sold item listing vs Gross Profit by Date

So some customers might be comparing reports, and they would say things such as These totals do not match (ie. between Detailed sold item listing and Gross Profit reports.

The reason for this is because the gross profit reports only counts invoices, while Detailed sold item listing counts every transaction type ( Special orders, Layaways, Quotes etc).

 

The total in the Detailed sold item listing counts every sold item in every transaction.

 

The difference between these reports without any queries, is that the one above counts all transaction types, and below it counts only invoices.

In the image underneath, the Detailed item sold listing has the above query. The items sold and the net sales both match as well now.