Using Hierarchy Versions in Workbooks and Reports
If you use multiple merchandise hierarchy versions, each version contains a complete hierarchy definition for a specific time period. Although typically you only need one hierarchy version, a benefit of using multiple hierarchy versions is that you can update your merchandise hierarchy as required to reflect the items available at any time.
For example an enterprise that sells fashion wear could have two product categories: Core, and Fashion. During the spring/summer, some items could be classified in the Core category, then during the fall/winter classified as Fashion. To preserve the historical classification of these items for workbooks and reporting, you can create a hierarchy version for the Spring/Summer period and another one for the Fall/Winter period.
Only one hierarchy version is active at any time. If you create multiple versions, the current version is the only active version, superseded versions are inactive but available for workbooks and reporting purposes. You can also have several versions scheduled for the future.
For more information, see the Creating a Hierarchy Version topic.
Workbooks and reports that incorporate multiple merchandise hierarchy version data use custom merchandise hierarchy fields that have been added to the transaction record rather than the item record. They are therefore, also known as transaction-based workbooks or reports.
Only use transaction–based workbooks and reports when you have multiple versions and you need to preserve the historical classification of items in Purchase and Sales reports.
For all other merchandise hierarchy reports, see Creating Merchandise Hierarchy Reports.
Merchandise Hierarchy Transaction-Based Workbooks
You can create workbooks that include merchandise hierarchy historical version data using SuiteAnalytics Workbook.
To create a workbook that includes historical version data you must use custom fields from the Transaction Line record, rather than the Item record. This is the only difference when defining a workbook to show historical version data as opposed to current version data. You select the correct custom fields to use during the process for selecting the Datset for your workbook.
For more information, see Add Custom Fields to the Dataset in Merchandise Hierarchy Workbooks.
Merchandise Hierarchy Transaction-Based Reports
You can create custom reports that include merchandise hierarchy historical version data using Report Builder. However, not all types of reports can display historical version data.
You can customize only the following types of standard NetSuite reports to display historical item classifications:
-
Purchase reports – for example, Purchase by Item, Purchase by vendor, etc.
-
Sales reports – for example, Sales by Item, Sales by Customer, etc.
Locating Custom Merchandise Hierarchy Fields for Historical Reports Only
Custom merchandise hierarchy fields are located in the Add Fields list in the Report Builder.
The type of report you want to customize determines the location of the internal custom fields you need to add.
Do not use the internal custom fields described in this section when you have only one hierarchy version defined in your system. For more information, see Locating Custom Merchandise Hierarchy Fields for Reports.
To locate the internal custom fields needed to create historical merchandise hierarchy reports when you have multiple versions, refer to the following table:
Report Type |
Report |
Custom Merchandise Hierarchy Fields Location |
Notes |
---|---|---|---|
Purchases |
Purchase by Vendor |
Purchases |
Select fields with the suffix (Custom Column) |
Purchase by Item |
Purchases |
Select fields with the suffix (Custom Column) |
|
Purchase Order History |
Purchase Order Transactions |
Select fields with the suffix (Custom Column) |
|
Sales |
Sales by Customer |
Sales |
Select fields with the suffix (Custom Column) |
Sales by Item |
Sales |
Select fields with the suffix (Custom Column) |
|
Sales by Sales Rep |
Sales |
Select fields with the suffix (Custom Column) |
|
Sales by Sales Team |
Sales Team Sales |
Select fields with the suffix (Custom Column) |
|
Sales by Partner |
Sales |
Select fields with the suffix (Custom Column) |
|
Sales by Historical Team |
Historical Revenue |
Select fields with the suffix (Custom Column) |
|
Sales by Historical Team (Transaction Date) |
Sales |
Select fields with the suffix (Custom Column) |
|
Sales by Promotion |
Sales |
Select fields with the suffix (Custom Column) |
|
New Customer Sales |
Sales |
Select fields with the suffix (Custom Column) |
Related Topics
- Merchandise Hierarchy Overview
- Configuring Merchandise Hierarchy
- The Hierarchy Manager
- Creating a Merchandise Hierarchy
- Creating a Merchandise Hierarchy by CSV
- Exporting Merchandise Hierarchies
- Using Merchandise Hierarchy to Analyze Sales and Item Performance
- Creating Saved Searches Based on a Merchandise Hierarchy