Receivables Analysis

Receivables analysis enables overview of all financial analyses regarding customers. Users can easily analyze receivables, relation between debit/credit, balance and various rotation coefficients through different dimension attributes.

Balance is calculated daily from the first day of posting to Microsoft Dynamics NAV. It enables an overview of before due and overdue receivables in various intervals. Insight into receivables is enabled for specific document on chosen date.

Extending functionality of Microsoft Dynamics NAV

Main advantages:

• Advanced measures: average receivables, rotation in days, average open days for an invoice, average due days for specific group of invoices.
• Receivables balance through all customers through time dimension (trends of receivables).
• Calculations for every day in BI4Dynamics NAV data warehouse makes due/overdue receivables analysis very fast.
• Analyze specific dimensions over key performance indicators.

Sample scenarios

Front-end tool used: Microsoft Office Excel 2007.