Invoice Information

The Invoice Information data model provides a detailed view of invoice level financial data. It includes measures like amount paid, amount invoice, balance due, check amount, discount amount, retention amount, taxable and non taxable amounts, freight, tax, average days to pay, and average days overdue. Use it to review invoice details by vendor and location, track payment behavior, and monitor outstanding balances.

How to use this data model

• Review invoice details by vendor to see how much was invoiced, paid, and what balance remains.
• Track payment timing using average days to pay and days overdue to understand how quickly vendors are being paid.
• Compare invoice and check amounts by city to spot discrepancies or patterns across locations.
• Monitor balance due distribution across vendors and cities to see where the largest outstanding amounts are.

Available views

View	Type	What it shows
Invoice AMT Balance Vendor City	Spline	Shows invoice amounts and balances broken down by vendor and city over time.
Invoice AMT By Vendor	Worksheet	Breaks down total invoice amounts by vendor with payment and balance details.
Balance Due By Vendor City	Pie	Shows how balance due is distributed across vendors and cities.
Balance AmtPaid By Vendor	Radar Spline	Compares amounts paid across vendors in a radar chart, making it easy to see relative payment levels.
AMT, Chk AMT By City Cie	Stacked Bar	Compares invoice amounts against check amounts by city and company.