POS
Labor Sales:Customer has accepted the variances within the core application (Labor) and does not hinder performance of Labor Analytics Dashboards.POS Sales:Customer has confidence in these numbers and are quite satisfied with the result from POS Inventory Sales:Providing an additional work-around will further perpetuate the issues and introduce more risk.Customer expressed that re-config of every item and modifier not feasible.Current work-around: Food Recipe Filler - negative sales / item modifierThis workaround has caused the unfortunate byproduct of negative value, skewing core application sales/costs.Downstream this is effecting Inventory Analytics DashboardsPOS Sales are correct within AnalyticsInventory Sales are not correct within AnalyticsLabor Sales have expected variances within AnalyticsBy addressing the configuration within core applications you will resolve the variance within sales $Using another sales feed is not advised.
Inventory
Follow-up w/RMEWith regards to item visibility between brands
Labor
POS
POS Dashboard
Inventory Dashboards
Inventory Dashboard Sales VarianceDuring initial config, sales filters are applied with customer direction to align the core application with desired result in Analytics. Ex. comps, discounts, etc.Adjust Net Sales Metric within Analytics to more closely align with POS/Labor.Analytics Inventory feeds have been configured to aggregate Net Sales before posting.Remove all filters from core application feedRe-map necessary sales filters with Customers guidance(Analytics Team) address the sales variance by remapping inventory net sales within Analytics to match Inventory. (Inventory team) will be responsible for making the necessary adjustments to align with POS Sales.
Labor Dashboard
Inventory Sales
Labor Sales
POS Sales
Plate IQ
API Call
Fourth API CallShari's to provide Fourth with API credentials to Plate IQDaily exportImport received and sent to both storage and Shari's KBC Environment for further transformation.Plate IQ Integration transforms data to the table format needed to be consumed into Analytics.Shari's KBC environment exports transformed tables to Analytics Flash P&L Dashboard.GL codes mapped 1 to 1All changes made in core app will be reflected on following sync
Plate IQ
Plate IQ integrationReceive import from Plate IQ Compare to Units table within AnalyticsConcatenate GUID w/GL codes Remap Data by GUID Export to Analytics Flash P&L
Plate IQ
Plate IQShari's AP Platform Flash P&LGross ProfitContribution MarginGL ExportsEnterprise Reporting
Flash P&L Dashboard
Flash P&L Dashboard Updates Daily via API Drill Down enabled from High level KPI to GL Transaction by location & date.Inventory figures will only present the day after inventory period has been posted and closed.
SYNC TIMES
Core Application Sync TimesPOS 9:30am est / 4:30 pdtLabor 9:30am est / 4:30 pdtLabor 11:30 am est / 6:30am pdtInventory 1:00pm est / 8am pdtAdjust sync times to 9am est