Microsoft Dynamics GP
Analysis Cubes for Excel
Microsoft Dynamics GP Analysis Cubes for Excel
Improve your ability to analyse and report financial data, and share information across your organisation.
Microsoft Dynamics GP Analysis Cubes for Excel include Financial Series cubes such as General Ledger, Accounts Receivables, Accounts Payable, Receivables Ageing, and Bank Reconciliation, so you can begin analysing information immediately. Receive quick answers to common business concerns such as:
- Microsoft Dynamics GP Analysis Cubes for Excel - Sales analysis based on customers, sales territory, salesperson, or General Ledger account
- Microsoft Dynamics GP Analysis Cubes for Excel - Total purchases by vendor or account code
- Microsoft Dynamics GP Analysis Cubes for Excel - Financial Statements and reports such as profit and loss statements
Using the Excel Pivot Table Generator you can define how to “slice and dice” information from Microsoft Dynamics GP, and the information will be instantly created in Excel for analysis.
Microsoft Dynamics GP Analysis Cubes for Excel
Microsoft Dynamics GP Analysis Cubes Library contains Distribution Series cubes for Sale Order Processing, Purchase Order Processing and Inventory and it’s available as an additional module with Microsoft Dynamics GP Professional. The information you analyse will help you answer questions important to your business success, such as:
- Microsoft Dynamics GP Analysis Cubes for Excel - Which vendors are providing the best prices on a particular item?
- Microsoft Dynamics GP Analysis Cubes for Excel - What is our margin percentage by item, by customer, or by salesperson?
- Microsoft Dynamics GP Analysis Cubes for Excel - What customers are buying more from us this year more from us this year than last? Which ones are buying less?
- Microsoft Dynamics GP Analysis Cubes for Excel - What was our review for the week? Who was the top salesperson? Customer? Product?
