To access the Inventory File dashboard first locate the item the Dashboard button (outlined in red below) will have a drop down menu where you can select the dashboard you would like to open.

 

The Inventory Maintenance dashboards menu has six different dashboards.

▪Sales

▪Purchases

▪Returns

▪Short Ships

▪Compare Sales by Years

▪Backorders

▪Lot History

 

Item Short Ships

 

 

Inventory Returns

Inventory Compare Sales by Years

The Sales diff. % column will show you the growth percent in green with an up arrow or the shrinkage in red with a down arrow so you can quickly see the sales comparisons.

 

Quantity Diff., Quantity Diff. %, Weight Diff., and Weight Diff. % columns have been added. 

 

Formulas when examining 2015

•Quantity (2015) - Quantity (2014) = Quantity Diff. (2015) or using the chart data below: 368 - 152 = 216.

•[(Quantity Diff. (2015) X 100) / Quantity (2014)] = Quantity Diff. % (2015) or using the chart data below: [(216 X 100) / 152] = 142.11.

•[[(Ext. Price (2015) - Ext. Price (2014)) X 100] / Ext. Price (2014)] = Sales Diff. % (2015) or using the chart data below: [[(9480.07 - 3841.11) X 100] / 3841.11] = 146.81.

 

 

•Column to be added soon: Sales Diff. $. Formula: Ext Price (2015) - Ext Price (2014) = Sales Diff $ (2015).

 

Inventory Compare Sales by Years

Inventory Sales

 

Inventory Purchases