Basic Assignments
 
Options & Settings
 
Main Time Information
Color Code: Green
Assigned To: Cory Warden
Created By: Cory Warden
Created Date/Time: 1/29/2020 10:52 am
 
Action Status: Blank (new)
Show On The Web: Yes - (public)
Priority: 0
Finished/Done: No - (open)
Finished/Done By: ...
Budgeted/Estimated Value: 0.00  
Actual/Real Value: 0.00   [donate]
Invoice/Quote Status: Blank (n/a)
General Amount: $0.00
 
Time Id: 1629
Template/Type: Community Funded Projects
Title/Caption: Sales Report, etc multi corp multi location options
Start Date: 1/29/2020
End Date: Unknown... (open or blank)
Total Time: Unknown... (open or blank)
Target/Due Date: 1/29/2020
Main Status: ** Inactive **

Sorry, no photos available for this element of time.


Notes:

1/29/20: To accomplish this there are two routes: 

Sales report: Route 1) a) A scratch report in one corp, pulls one category (start with flower) and one location to start. Get that perfect and pulling all data. This report costs $1,000. 

Route 1) b) We set up an analytical system. ($350 activation fee, $187 corp monthly fee) Set up a table ($500) Build a report ($1,000) Build an internal api connection ($1,000).  This will connect to the one store. Analytical system takes 700 plus records and crunches it down into 20. Very fast report

Then we can start connecting the other corps for flower. If there is a normalization of data from corp to corp, then it could only cost $500 to add all the rest of the stores. If it is messy then it could be quite a bit more. Then we can start adding all categories and locations.

Route 2)= Set up a VPS environment (data warehouse) and the client hires a developer to manage this warehouse. They can work in any language, and they can write queries and run reports. Any report. This is $1,000/month to host. But this allows for all kinds of reports, as the report we are talking about in Route 1 is just one report for that cost.

PO Report:use same table as scratch report, 1 location, 1 category. Steve had questions about how this would run- could be deeper. Need to discuss further ($3,000)

Inventory on hand report: use same scratch table. Would need to discuss further. ($3,000)