Cost upload

Knowledge Center > Zuora RevPro > Cost processing > Cost upload

Cost upload

Table of contents

The recommended way to upload standard costs to RevPro is to upload the cost as an amount on the corresponding sales order line. For other costs, it is recommended to either upload the cost on separate cost lines or to configure RevPro to calculate the costs based on defined formulas.

RevPro can process cost updates if there are multiple cost uploads. For example, if you have a 3-month revenue contract. You might choose to upload an initial cost in the first month of the revenue contract and then upload a revised cost at the end of the 3-month revenue contract. Alternatively, you might simply choose to upload the costs after the cost data is already known and available to be uploaded to RevPro.

If there are multiple cost uploads, the most recently uploaded costs will be used and a history of the cost changes is logged in RevPro.

Procedure

Complete the following steps to upload costs to RevPro:

  1. Navigate to File Upload > Transaction/Cost.

  2. Click add-icon.png to add a template. The New Transaction Upload Template window is displayed.

  3. In the Template Definition tab, select the appropriate RC grouping rule for the transactions that are to be uploaded and provide a unique name for the template.

  4. In the File Type field, select CSV or Text for the upload file type.

  5. If you select Text in the previous step, enter the separator between items in the Field Separator field.

  6. In the Start Row field, enter the number of the row from which the actual data is inserted in the upload file. For example, if the first row is the heading row, enter 2 to indicate that the actual data start from the second row.

  7. (Optional): Select the date format for the upload file in the Date Format field and specify whether review in the required by using the Is Review Required toggle switch.

  8. Click save-icon.png. The upload template is created.

  9. Click the Field Mapping tab to ensure the required cost related fields are present in the list.
    The following fields are related to costs but no all of them are required. You should choose the ones that suit your business needs.

    • Cost Amount

    • Cost Currency

    • Cost Type ID

    • Cost Type Name

    • Cost Func Fx Rate

    • Cost Global Fx Rate

    • Cost Def Segments

    • Cost Rev Segments

  10. Save your changes and close the window.

  11. To freeze the template for further changes, on the template page, click the template line and then click Freeze icon freeze-icon.png.

  12. To download the template file, click the Download Template icon download-template-icon.png.

  13. Fill in your data in the downloaded file and save the changes.

    To upload other costs as separate cost lines (Line Type being CST), the following fields are the minimum requirements:

    • Sales Order Line ID

    • Sales Order Date

    • Cost Amount

    • Cost Currency

    • Cost Type ID

    • Currency

    • Functional Currency

  14. Click the Upload icon upload-icon.png to upload the modified file.

  15. In the File Upload window, select the local file and click Upload. A message is displayed indicating the upload is successful.
     

Last modified

Tags

This page has no custom tags.

Classifications

(not set)