Show the Vendor Purchase Price and Vendor Price Currency in Suiteanalytics Item Workbook

Scenario

User wants to show the Vendor Purchase Price and Vendor Price Currency in the SuiteAnalytics Item Workbook

Solution

1. Navigate to Analytics tab 
2. Click New Workbook
3. Click New Dataset
4. Select Item
5. Note: Click and Drag each field to add criteria
• Search: Enter Vendor
• Select Item: Vendor Name/Code
• Search: Enter Vendor Price
• Select Vendors: Price (Entered) 
• Search: Enter Vendor Price
• Select Vendors: Currency
• Click Save  
• Enter Item Dataset Name
• Click Save
6. Click Apply to Workbook
7. Click Table
   Note: Click and Drag each field to workbook
   
• Select Currency
• Select Item Name/Number
• Select Price (Entered)
• Select Vendor Currency
8. Click Save
• Enter Workbook Name
• Click Save