Currently, monthly invoices and reports only displays the billing period but does not provide any differentiation for monthly and annual licenses. To show this differentiation, a unique ID for NCE SKUs has to be created in the Long and Short RDE reports. This process provides a walkthrough of how this can be done.


RDE Long Report

In the Long RDE report there are fields that can be used to identify the SKU and the billing period for NCE subscriptions. 

  1. Go to Column FB: Subscription_Name. 

  2. Then go to the below two Columns. These two fields identify the duration of the billing period for the SKU. 
    • Column FG: Subscription_Period
    • Column FH: Subscription_Period_Type 

  3. The above fields can all be combined to create a new unique identifier. Insert a column in the Long RDE report and set the first cell as the name of the column. Use something like “Unique_ID”. Use the following formula in the second cell and then copy it to all cells below.
    • =FB2&" "&FG2&" "&FH2
    • Example - This will present the following results which show the SKU name and billing period.
      Text Description automatically generated 

RDE Short Report

In the Short RDE report there are fields that can be used to identify the SKU and billing period for NCE subscriptions.

  1. Go to Column F: Subscription Name.
    Graphical user interface, text, application Description automatically generated 


  2. Then go to Column U: Billing Period and Column V: Billing Period Type.
    Table 
Description automatically generated


  3. The above three fields can be combined to create a new unique identifier. Insert a column in the Short RDE report and set the first cell as the name of the column. Use something like “Unique ID”. Use the following formula in the second cell and then copy it to all cells below. 
    • =F2&" "&U2&" "&V2
    • Example - This will present the following results which show the SKU name and billing period.
      Text 
Description automatically generated