Payables Analysis

Payables analysis enables overview of all financial analyses regarding vendors. Users can easily analyze payables, 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 on before due and overdue payables in various intervals.

Extending functionality of Microsoft Dynamics NAV

Main advantages:

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

Sample scenarios

Front-end tool used: Microsoft Office Excel 2007.