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).

 Detailed_sold_item_listing_by_date.PNG

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

 Detailed_sold_item_listing_by_date_2.PNG

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

gross_profit_by_date.PNG

 

 

query.PNG

 

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.

 

Detailed_sold_item_listing_by_date_3.PNG

 

 

Have more questions? Submit a request

0 Comments

Please sign in to leave a comment.
Powered by Zendesk