Inventory Reports

All of these reports work along with the counts and invoices sections under the Product button.

Theoretical On Hand: It will prompt for a date to start.  The report will be broken down by Sales Groups. It will list the item number and description, cost (entered in the invoice or edit Product Items section), price (the price entered into price level 0), on hand (this will take the last count numbers, add invoices and subtract each sale), ext cost (on hand multiplied by cost), and ext price (on hand multiplied by price). 

Quantity Variance: It will prompt for a start and end date first. These dates are the dates that have counts entered. The report will be broken down into Sales Groups. It will list item number, description, starting (counts from first date chosen), purchase (all invoices between the two chosen dates), sold (number sold during the two chosen dates), ending (counts from the second date chosen), theoretical (this is the starting Product Items purchases minus sold), variance (this is theoretical minus ending).

Dollar Variance: It will prompt for a start and end date first. These dates are the dates that have counts entered. The report will be broken down into Sales Groups. It will list item number, description, starting ($ value of counts from first date chosen), purchase ($ value of all invoices between the two chosen dates), sales cost ($ value of cost sold during the two chosen dates), ending ($ value of counts from the second date chosen), theoretical (this is the starting $ value Product Items purchases $ value minus costs sold $ value), variance (this is theoretical minus ending).

Ending Counts: This will for a date. These dates are the dates that have counts entered. This report will show the item number, description, cost (cost of the item), on hand (how many were added to the counts for the specific day chosen), total (cost value of on hand amounts).

Cost Of Goods Sold: This will prompt for a start and end date. These dates are the dates that have counts entered. This report will be broken into Sales Groups. It will show the item number, description, start (this includes the first dates counts and their cost values), purchase ( this includes all purchases between the chosen dates and their cost value), end (this includes the second dates counts and their cost values), usage ( this is starts Product Items purchases minus ending for both counts and cost values), and percent of cost.