Sage 200 Evolution Predefined Views
Sales
| Data Model | View |
|---|---|
| Sales Transactions |
Sales Orders Sales Orders Overdue Deliveries Sales Invoices Credit Notes Sales Orders Picking List Sales by Item Group Sales Quotes Sales by Area Top 5 Sales Reps Sales by Group and Item Sales Dashboard KPIs Top 5 Customers by Sales Profit Net Sales vs Profit by Month |
Purchasing
| Data Model | View |
|---|---|
| Purchase Lines |
Purchase Order / GRV Master GRV Listing Purchase Order Listing Returns to Supplier Average Buy Price by Supplier Top 10 Purchase Item Status Top 5 Suppliers by Total Outstanding Top 5 Suppliers by Total Outstanding Purchasing Dashboard KPIs Outstanding Purchase Orders Invoice Total and Percent Processed by Vendor Item Group by Quantity Purchased |
| Requisitions | Requisitions |
Finance
| Data Model | View |
|---|---|
| AR Transactions |
AR Current Aging (Ledger Currency) AR Invoice Application (Ledger Currency) AR Current Aging (Transaction Currency) AR Invoice Application (Transaction Currency) AR Transaction Information |
| AP Transactions |
AP Current Aging (Ledger Currency) Supplier Payments (Ledger Currency) AP Current Aging (Transaction Currency) Supplier Payments (Transaction Currency) AP Transaction Information |
| Balance Sheet |
Balance Sheet Visual Balances |
| GL Balances |
GL Budget vs Actual by Period Trial Balance Income Statement |
| GL Transactions | GL Balances & Transactions |
Inventory
| Data Model | View |
|---|---|
| Inventory Balances |
Movement Details Movement Over Time by Warehouse / Item Inventory Balance & Valuation by Tr. Code Inventory Valuation Cumulative Inventory Valuation by Warehouse Inventory Cost Variance Report Inventory Management Report (Current Month) Detailed Inventory Item Listing / Valuation Cost Comparison by Period Inventory Balance & Valuation Over Time YTD/MTD KPIs Inventory and Sales KPIs Product-wise Inventory Value On-hand Inventory Quantity (by Warehouse) Key Performance Indicator View Product-Wise Inventory Value Detailed Inventory Item Listing / Valuation by Warehouse by Company |
Job Costing
| Data Model | View |
|---|---|
| Job Costing GL | Job Actuals |
| Job Costing Transactions |
Item Cost/Selling Price Analysis Job Costing Work in Progress Average Cost by Job Job Actual vs Estimated Cost Profit by Job |
View Example
