-
Module 1: SALES ORDER MANAGEMENT
-
Module 2: SALES PRICES AND DISCOUNTS
-
Module 3: CUSTOMER SERVICE FEATURES
-
Module 4: PURCHASE ORDER MANAGEMENT
-
Module 5: REQUISITION MANAGEMENT
-
Module 6: ITEM CHARGES
-
Module 7: ORDER PROMISING
- Lesson 1: Sales Order Promising Key Concepts
- Lesson 2: Sales Order Promising Definitions and Calculations
- Lesson 3: Date Calculation Setup for Sales Orders
- Lesson 4: Promising Sales Order Delivery
- Lesson 5: Purchase Order Promising Definitions and Calculations
- Lesson 6: Date Calculation Setup for Purchase Orders
- Lesson 7: Estimating Purchase Order Receipts
- Lesson 8: Estimate a Transfer Order Receipt & Calendars
-
Module 8: RETURNS MANAGEMENT
-
Module 9: ASSEMBLY MANAGEMENT
-
Module 10: ANALYSIS AND REPORTING
Lesson 2 : Analysis by Dimensions
Analysis by Dimensions
Analysis by Dimensions : To analyze information by using multiple dimensions, companies can use the Analysis by Dimensions page. You can use this page to view amounts that are derived from analysis views.
With analysis by dimensions, you can do the following:
- Combine dimensions
- Filter entries
- Explore data from different perspectives
- View net change or balance at date numbers
- Select time periods
You cannot print this information directly. You can instead export it to Microsoft Excel and use all the Excel tools to create presentations and print data.
To learn more about analysis views, refer to the “Analysis Views and Reports” lesson in this training material.
Analyze Item Sales by Area
As the sales manager at CRONUS, you must analyze item sales by area for the year 2014. The analysis includes item numbers 1896-S to 766BC-C.
After you review the sales amounts of item sales by area, do the following:
- View the analysis as the cost of goods sold (COGS) amount and quantity.
- Compare the sales amounts for Peter Saddow with those for John Roberts.
- Export the sales amounts by John Roberts to an Excel workbook.
High Level Steps
- Open the Sales Analysis View Card page and browse through the existing analysis views to check whether one is set up with both the AREA and SALESPERSON dimensions. If this is the case, update it.
- Set the filters for the DEFAULT analysis view to analyze the year’s item sales by area for item numbers 1896-S through 766BC-C. Also, show column names, and then review the analysis view matrix.
- View the same item sales by area by COGS amount, and then by quantity.
- View the item sales by area by sales amount for salesperson Peter Saddow, and then for salesperson John Roberts. Export the data for John Roberts to Excel. Detailed Steps
- Open the Sales Analysis View Card page and browse through the existing analysis views to check whether one is set up with both the AREA and SALESPERSON dimensions. If this is the case, update it.
- In the Search box, enter “sales analysis view card”, and then select the related link.
- Browse through the existing analysis views to check whether one is set up with both the AREA and SALESPERSON dimensions. The DEFAULT analysis view contains these dimensions.
- Select the line for the DEFAULT analysis view.
- On the Home tab, click Update.