Medusa Beverages Private Limited— AR Intelligence Dashboard

🔍 Filters — Applied to all KPIs, Charts and Tables

Financial Year (Apr–Mar)

From Date

To Date

State

Salesperson

Posting Group

Customer Type

Branch Code

Customer Search

Loading data from Business Central Cloud…

Total Customers

—

Master count

Cases Sold

—

ILE · entryType=Sale

Non Repeat
Customers

—

1 invoice · current FY

Repeat Customers

—

2+ invoices · current FY

Net Revenue

—

G/L 11100–11299

Gross Revenue

—

G/L 11100–11299 + 12000–12999

Spent Grain Revenue

—

G/L 11121

Beer Business Net
Revenue

—

G/L 11105–11115

Beer Business Gross
Revenue

—

G/L 11105–11115 + matched 12000–12999

Total Outstanding

—

Above 90 Days CRITICAL

—

— % of Total

61–90 Days WATCH

—

Below 61 Days SAFE

—

Above 180 Days

—

Write-off risk

Total Vendor Payable

—

VLE · Open=true · Remaining Amt LCY

Till Today — Overdue

—

🔒 DueDate < Today

Aging Overview(Sales)

Customer Analysis

Ageing Analysis

By Salesperson

By State

Aging Overview(Inventory)

COP Analysis

Collection Analysis

Vendor Analysis

Inventory Analysis

Inventory (Purchase)

Ageing Distribution (₹ Lakhs) — Net including credits

Matches BC Aged AR Report · 1–30D, 31–60D, 61–90D, 91–120D, 121–150D, 151–180D, >180D · Click any segment to drill

👆 Click a chart segment or legend row to drill into that ageing bucket

Outstanding by Salesperson (Top 10) — ₹ Lakhs

SUM(Remaining_Amt_LCY) · Open=true · grouped by SalespersonCode

Outstanding by State (Top 10) — ₹ Lakhs

SUM(Remaining_Amt_LCY) · Open=true · grouped by StateDes

Top 10 Customers — Outstanding — ₹ Lakhs

SUM(Remaining_Amt_LCY) · Open=true · Red=>30% overdue 90d · Amber=>10%

📈 Key Metrics & Risk Insights

💰

Collections

—

BLE · documentNo starts with BR-

⚡

Top 10 Concentration Risk

—

🔴

Write-off Risk (>180 Days)

—

📍

Geographic Concentration

—

⚡

Salesperson Portfolio Risk

—

🚨

Critical Action Items

—

Ageing Logic (matches BC): Open=true · 1–30D: PostingDate > (ToDate−30) i.e. days<30 · 31–60D: days in [30,59] · 61–90D: days in [60,89] · 91–120D: days in [90,119] · 121–150D: days in [120,149] · 151–180D: days in [150,179] · >180D: days≥180.

Filtered: —

Customer Outstanding (All)

Showing —

Filtered: — | Grand Total: —

Rank	Customer	State	Marketing	Total O/S (₹L)	1–30D	31–60D	61–90D	91–120D	121–150D	151–180D	>180D	Risk	Detail
Loading…

BC Match: Open=true · Bucket by PostingDate vs ToDate. 1–30D: days < 30. 31–60D: 30 ≤ days < 60. 61–90D: 60 ≤ days < 90. 91–120D: 90 ≤ days < 120. 121–150D: 120 ≤ days < 150. 151–180D: 150 ≤ days < 180. >180D: days ≥ 180.

Filtered: —

Ageing Bucket Summary

Buckets match BC Aged AR Report. Negatives = credit memos. Click any row to drill.

Grand Total: —

Ageing Bucket	No. of Customers	No. of Open Entries	SUM Remaining (₹L)	% of Total O/S	Status	Drill-Down

Filter Logic: SUM(Remaining_Amt_LCY) · Open=true · grouped by SalespersonCode. Click salesperson row to see ALL their open entries.

Filtered: —

Outstanding by Salesperson — ₹ Lakhs (Stacked)

SUM(Remaining_Amt_LCY) · Open=true

Rank	Salesperson Code	Total O/S (₹L)	1–30D	31–60D	61–90D	91–120D	121–150D	151–180D	>180D	% of Total	Risk	Drill

Note: State grouping based on StateDes field. Negatives (credit memos) preserved.

Filtered: —

Outstanding by State (Top 12) — ₹ Lakhs

SUM(Remaining_Amt_LCY) · Open=true · grouped by StateDes

Rank	State	Total O/S (₹L)	1–30D	31–60D	61–90D	91–120D	121–150D	151–180D	>180D	Customers	% of Total	Drill

Collection Overview: ILE API · remainingQuantity grouped by ItemCategoryCode (FG / RM / PM) · Bucketed by postingDate age · All FY by default · Click any donut segment to drill down.

All FY Data

FG — Finished Goods

remainingQuantity by age bucket · Click segment to drill

Total Qty

—

Entries

—

RM — Raw Materials

remainingQuantity by age bucket · Click segment to drill

Total Qty

—

Entries

—

PM — Packaging Materials

remainingQuantity by age bucket · Click segment to drill

Total Qty

—

Entries

—

Monthly Purchase — Quantity Trend

ILE · entryType=Purchase · SUM(quantity) grouped by Month · All categories

Item Category

Branch

Total: —

Click a donut segment to start drill-down

Monthly Sales / Cost / GP — Stacked Bar Chart

ILE API · entryType = Sale · salesAmountActual & costAmountActual · GP = Sales − Cost

Branch Code

Financial Year

Total Sales

—

Total Cost

—

Gross Profit

—

Month	Sales (₹)	Cost (₹)	GP (₹)

WIP (Closing Stock)

—

ILE · Output · itemNo starts WIP · All FY

👆 Click to drill down

WIP Items

—

Distinct item numbers

WIP Branches

—

Distinct location codes

Excise Groups

—

Distinct excise groups

Grouping COP: ILE (entryType=Output) × Item Master API · L1→Excise Group → L2→Branch → L3→Item → L4→Chart (CostperUnit) Click tab to load…

All Excise Groups

Product — Summary

Click any row to drill down into Branches

Blended COP: —

Click "Grouping COP" tab to load…

Collection Trend: BLE API · Only records where documentNo starts with BR- or BP- · Internal filters override global filters · Default = ALL financial years combined.

All FY Data

All Branches

Branch-wise Collection Summary

Click any branch row to drill into descriptions

Total: — | Rows: —

Click "Collection Trend" tab to load data…

Inventory Intelligence: ileAPI · ALL entry types (Sale, Purchase, Positive Adjmt., Negative Adjmt., Transfer, Consumption, Output…) · No entryType filter applied · L1: ItemCategoryCode → L2: Branch → L3: Description → L4: Raw Entries · SUM(quantity) at every level

Total Inventory Qty

—

ILE · All entry types

Current Level Total

—

All Categories

Inventory — By Item Category

Click a row to drill down

Rows: —

Click the Inventory tab to load data…

Inventory Purchase Intelligence: ileAPI · entryType = Purchase ONLY · L1: ItemCategoryCode → L2: Branch → L3: ItemNo → L4: COP Fluctuation Chart · COP = SUM(costAmountActual) / SUM(quantity)

Total Purchase Qty

—

ILE · Purchase entry type

Total Purchase Cost

—

SUM(costAmountActual)

Blended COP

—

costAmountActual / quantity

Current Level Rows

—

All Categories

Purchase Inventory — By Item Category

Click a row to drill down

Click the Inventory (Purchase) tab to load data…

Ageing Logic: Open=true · 1–30D: PostingDate > (ToDate−30) · 31–60D: days in [30,59] · 61–90D: days in [60,89] · 91–120D: days in [90,119] · 121–150D: days in [120,149] · 151–180D: days in [150,179] · >180D: days≥180.

Filtered: —

Vendor Outstanding (All)

Showing —

Filtered: — | Grand Total: —

Rank	Vendor	State	Purchaser	Total O/S (₹L)	1–30D	31–60D	61–90D	91–120D	121–150D	151–180D	>180D	Risk	Detail
Loading…

Ageing Bucket Detail

View:

#	Cust No	Customer Name	State	Marketing	Entries	Total Amount (₹)	Total Remaining (₹)	Max Days	Action

Rows/page:

#	Cust No	Customer Name	State	Marketing	Entries	Total Amount (₹)	Total Remaining (₹)	Max Days	Action

Medusa Beverages Private Limited — AR Intelligence Dashboard

Customer Detail

Vendor Detail

Customers

Ageing Bucket Detail

Revenue Drill-Down

Cases Sold — Drill Down