Knowledge Center

Knowledge Center > Zuora RevPro > Bundle Classification

Bundle Classification

The Bundle functionality enables you to upload a bundle definition to RevPro so that RevPro may perform revenue bundle explosion that can be splitting or expanding. Few product items with different item numbers are grouped together under a parent Bundle. The Selling Price split value is provided for the child lines and the sum of them is the Bundle value. In addition to the Selling Price, Cost Price and List Price of the child lines are also captured. There is a from and to date from which the bundle is valid. Each and every child line present under the Bundle will have the Parent Item Number details and also the unique segment details.

Value can be split based on Percentage, Price, Same. If same then only one child line item will be there. Parents list price value is same the as child’s list price value. Selling price will be different and it can be split based on Percentage or Price. The difference in the amount of the child lines is assigned to the parent line.

If we update the existing bundle, the old will be moved to history and the new bundle will be considered. If the start date and end date is not provided for the child item, then it follows Parent start and end date. If a valid start and end date are present for the child item, then it is considered for the child item even though the parents dates are different.

If parent item quantity is 2 and if the child line item quantity is 3, then the actual quantity of the line item is multiplied with the parent quantity and child line item quantity is 6.

Reclassification of the bundle is also one major area that is covered in this document. It happens when you want to reassign the child’s Deferred Segment and Revenue segments amount to the Parent.

Here is an example. Follow the steps below:

  1. Collect a bundle with P-10%, C1-40, C2-50% respectively based upon the split type PCT.
  2. Collect 3 SO and INV lines (1-bundle, 2-normal lines) with Unit Sell Price and Unit List Price. Unit Sell Price and Unit List Price got calculated based on the given amount.
  3. Bundle upload file is RPRO_BNDL_CFG_G.

ID

PARENT_ID

VALID_FROM

VALID_TO

UPLOAD_ID

PARENT_

ITEM_NUM

LP_

SPLIT_VAL

QTY

ITEM_NUM

10322

10320

########

########

10689

HW-DBF-009

40

1

HW-DBF-011

10321

10320

########

########

10689

HW-DBF-009

50

1

HW-DBF-010

10320

 

########

########

10689

 

PCT_OF_LP

 

HW-DBF-009

 

Line Type

Customer Name

Sales Order Num

Sales Order Line Num

Sales Order Date

INV_NUM

Line Item Num

Ordered Qty

Ext Sell Price

SO

SPLENDER

SO-18205

1

########

 

HW-DBF-009

2

1000

SO

SPLENDER

SO-18205

2

########

 

HW-THG-002

2

1800

SO

SPLENDER

SO-18205

3

########

 

HW-THG-003

2

3700

INV

SPLENDER

SO-18205

1

########

INV-18205

HW-DBF-009

2

1000

INV

SPLENDER

SO-18205

2

########

INV-18205

HW-THG-002

2

1800

INV

SPLENDER

SO-18205

3

########

INV-18205

HW-THG-003

2

3700

                 

ID

RC_ID

TYPE

RC_POB_ID

EXT_SLL_PRC

EXT_FV_PRC

ALCTBL_XT_PRC

ALCTD_XT_PRC

BLD_REC_AMT

22231

12538

SO

18395

########

28.8

100

82.63

100

22232

12538

SO

18396

########

793.5

1800

2276.65

1800

22233

12538

SO

18397

3700

1140.8

3700

3273.1

3700

22237

12538

SO

18398

500

152

500

436.1

500

22238

12538

SO

18399

400

150.4

400

431.52

400

                 

ID

RC_ID

TYPE

EXT_SLL_PRC

DEF_AMT

REC_AMT

DOC_DATE

DOC_LINE_NUM

ITEM_NUM

22234

12538

INV

100

0

100

########

1

HW-DBF-009

22235

12538

INV

1800

0

1800

########

2

HW-THG-002

22236

12538

INV

3700

0

3700

########

3

HW-THG-003

22239

12538

INV

500

0

500

########

1

HW-DBF-010

22240

12538

INV

400

0

400

########

1

HW-DBF-011

               

ID

REL_ID

RC_ID

RC_VER

LINE_ID

POB_ID

INDICATORS

POST_PRD_ID

126409

 

12538

1

22231

18395

YNLYNNNNNNRNYNNNNNNN

200810

126410

 

12538

1

22232

18396

YNLYNNNNNNRNYNNNNNNN

200810

126411

 

12538

1

22233

18397

YNLYNNNNNNRNYNNNNNNN

200810

126412

 

12538

1

22237

18398

YNLYNNNNNNRNYNNNNNNN

200810

126413

 

12538

1

22238

18399

YNLYNNNNNNRNYNNNNNNN

200810

126414

17881

12538

1

22231

18395

NLRNNNNNNNRNNNNNNNNN

200810

126415

17882

12538

1

22232

18396

NLRNNNNNNNRNNNNNNNNN

200810

126416

17883

12538

1

22233

18397

NLRNNNNNNNRNNNNNNNNN

200810

126417

17884

12538

1

22237

18398

NLRNNNNNNNRNNNNNNNNN

200810

126418

17885

12538

1

22238

18399

NLRNNNNNNNRNNNNNNNNN

200810

126419

 

12538

1

22231

18395

NNWNNNNNNNANYNNNNNNN

200810

126420

 

12538

1

22232

18396

NNWNNNNNNNANYNNNNNNN

200810

126421

 

12538

1

22233

18397

NNWNNNNNNNANYNNNNNNN

200810

126422

 

12538

1

22237

18398

NNWNNNNNNNANYNNNNNNN

200810

126423

 

12538

1

22238

18399

NNWNNNNNNNANYNNNNNNN

200810

126424

 

12538

1

22231

18395

NWXNNNNNNNANNNNNNNNN

200810

126425

 

12538

1

22232

18396

NWXNNNNNNNANNNNNNNNN

200810

126426

 

12538

1

22233

18397

NWXNNNNNNNANNNNNNNNN

200810

126427

 

12538

1

22237

18398

NWXNNNNNNNANNNNNNNNN

200810

126428

 

12538

1

22238

18399

NWXNNNNNNNANNNNNNNNN

200810

Upload Bundles

The following steps list how to upload a bundle. You do not need to do any prerequisites for uploading a bundle.

  1. Navigate to File Upload > Bundle
  2. In the Bundle Upload screen, click New Template.
  3. Enter a valid Template Name for the Bundle and Description.
  4. Select the Enabled and Is Review Required check boxes, if required. If you select Review Required checkbox, RevPro ensures that there is a manual intervention before data collection.
  5. In the File Specifications pane, select the file type in which you want to upload the files. Start Row as 1 to mention that there is a heading row and the Date Format.
  6. Click the + button to create the template and click Save to save the details.

    Freeze buttons is displayed when you click Save. After entering the Field Mapping detail given in the below steps, you can Freeze the template so that the template freezes and no changes can be made in the template.

  7. Click the Field Mapping pane to view the Staging field names, their label and the type of the data that is entered in the fields. In the Field Mapping pane, you can select the field that can be set as the Bundle criteria.  
  8. From the Template Definition pane, select the newly added Bundle Template, right-click and select Download Template.
  9. Place the raw data in the template excel.
  10. In the Template Definition pane, select the newly added Bundle Template, right-click and select Upload and place the raw data updated excel to complete the upload process.

    Note: The newly uploaded file listed in the Uploaded Files pane with the status as Successfully Uploaded.

Reclassification of Bundles

RevPro has the ability to reclassify Initial Accounting Entries to Deferred Offset Account or Revenue Offset Account. In order to support the requirement, consider the following details within the product for reclassification. The following Offset Accounts are provided on the Transaction line for the INV ONLY transaction type:

  • Revenue Offset Account
  • Deferred Offset Account

Also, at SO level by the customer, these entries are created at the time of billing only. If both the accounts are populated, errors out the line on the staging table.

For each type, the triggering point for the reclassification is at the time of billing. An accounting type needs to be created based on the Offset type Balance Sheet or P & L account. The offset Account entry is created in transactional currency associated with the transaction line. 

Last modified

Tags

This page has no custom tags.

Classifications

(not set)