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.
Article ID: 268
Created: August 11, 2014
Last Updated: August 11, 2014
Online URL: https://counterpoint.knowledgebase.co/article.php?id=268