Basic Assignments
 
Options & Settings
 
Main Time Information
Color Code: Green
Assigned To: Unassigned
Created By: Cory Warden
Created Date/Time: 2/23/2020 3:09 pm
 
Action Status: Blank (new)
Show On The Web: Yes - (public)
Priority: 6
Finished/Done: No - (open)
Finished/Done By: ...
Budgeted/Estimated Value: 1,400.00  
Actual/Real Value: 0.00   [donate]
Invoice/Quote Status: Blank (n/a)
General Amount: $0.00
 
Time Id: 1649
Template/Type: Community Funded Projects
Title/Caption: Enhancements to daily sales and profit report
Start Date: 2/23/2020
End Date: Unknown... (open or blank)
Total Time: Unknown... (open or blank)
Target/Due Date: 2/23/2020
Main Status: Active

Sorry, no photos available for this element of time.


Notes:

2/25/20: Dealing with database changes, secondary numbers and some math. Best to have it default date to date ie one week, one month, one year to date (2/20/19 to 2/20/20) and then have the ability to change the date to 2/18/19 (two days earlier to match the day of the week) if needed. This would be a setting as not everyone would want this. Won't hard core control it. It would be a corp wide page level setting. The two settings would be 1)Do you want to show comparison and 2) Do you want to match date to date or day/month to day/month

Adding the average sale line would be simple- just some simple math.

2/23/20:

1)Add a line that simply pulls the same day of the week the year before and show on todays report for comparison.  Then we could simply add Variance of +/- what % they were to last years sales.

2)While we're at it we could add an average sale line by simply dividing total sales by transactions.  

These 2 things would make that report complete and they are what a lot of people want to see.  Going against last years sales is a great practice for retail business so adding this line would be amazing...keep in mind that if today, Wednesday, 2/19/2020 is being compared to last year the date would NOT be 2/19/2019....Instead it would be the Wednesday that falls on the same week...in this case it would be 2/20/19.