Using Hierarchy Versions in Transaction 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 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 reporting purposes. You can also have several versions scheduled for the future.

For more information, see the Creating a Hierarchy Version topic.

When you have multiple hierarchy versions that must be incorporated in the same historical report, you must follow the steps described in this section to create the reports.

These reports are also known as transaction-based reports because they use custom merchandise hierarchy fields that have been added to transactions.

Important

Only use transaction–based 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.


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.

Note

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)