Dashboard profit calculation

Summary:

Dashboard profit calculation.

How Profit is calculated in Dashboard

Solution:

The following calculation is used to calculate profit in Dashboard.  Run the following script in SQL to get the current profit figure:

Select sum (EXT_PRC - EXT_COST) from VI_DM_LIVE_FEED_LIN

Note: This total will include everything done for the day: holds, orders, quotes, layaways, etc.