📋 Summary:
What it shows: Compares the actual sales data against the VIP Sales Control Table to validate inventory and sales quantities by SKU and distributor for each month. Specifically, it displays:
(1) Sales quantities for each product/SKU
(2) Distributor-specific sales information
(3) Flags for any discrepancies between actual and controlled sales quantities
(4) Detailed tracking of monthly sales control data
Who should use it:
• Inventory Management Teams
• Sales Operations Managers
• Finance and Accounting Departments
When to use it:
• Reconciling monthly sales and inventory reports
• Identifying potential inventory discrepancies
• Verifying distributor sales quantities
• Conducting monthly sales performance reviews
Tip: Pay special attention to the "Is Out Of Sync" column to quickly identify any mismatches between recorded and expected sales quantities.
This summary was generated by AI.
📁 Public Bookmarks Folder: VIP/Sales Control
📌 Quick Stats:
🔻 0 filter(s) applied
📊 8 dimension(s) displayed
📈 0 measure(s) displayed
📄 Report Page: Build Beyond Limits | Advanced Reporting
🔄 Filter Behavior: When you select this bookmark, your existing filters will be replaced with the bookmark's saved filters.
📝 Original Description
Check the actual Sales Table against the VIP Sales Control Table which provides us quantities by SKU and Distributor for each month.
🔻 Filters Applied
✅ No filters applied - this bookmark shows all available data.
📋 Columns Displayed
📊 Dimensions:
Control Date
Distributor Name — Distributor Name
Product Name — The name of the product as it appeared on the order (could be different from the actual product name)
Units Sold
Is Out Of Sync
ℹ️ Additional Details
📁 Public Bookmarks Folder: VIP/Sales Control
🔑 Bookmark ID:
7a083918-a42f-4914-a823-724c1b294455