Knowledge Center

Knowledge Center > Finance > Mass Updater > Update Accounting Codes

Update Accounting Codes

The Update Accounting Codes mass action allows you to mass update accounting codes on transaction objects, such as invoice items. This reference describes the columns supported in the upload file and the columns added to the response file. See Mass Updater for more information.

Note that you cannot update the accounting code of a taxation item.

Upload File Columns 

The following table describes the columns supported in the upload file.

The Credit Memo Item and Debit Memo Item transaction types are only available if you enable the Advanced AR Settlement feature.

The Unapplied Payment Accounting Code and On-Account Accounting Code columns are only available if you enable the Advanced AR Settlement feature.

The Advanced AR Settlement feature is in Limited Availability. This feature includes Unapplied Payments, Credit and Debit Memo, and Invoice Item Settlement. If you wish to have access to the feature, submit a request at Zuora Global Support

Column Required? Description

Group ID

Optional

ID of the group that the record belongs to. If a record with a Group ID fails, any subsequent records in that group will not be processed.

Type: string

Character limit: 255

Object Key

Required

ID or transaction number of the object whose accounting code you want to update.

The specified transaction must not be in a closed accounting period or included in a summary journal entry, otherwise, you will receive an error.

Type: string

Character limit: 32

Object Type

Required

Type of transaction object whose accounting code you want to update. Valid values are:

  • Credit Balance Adjustment
  • Invoice Adjustment (Deprecated on Production)
  • Invoice Item
  • Invoice Item Adjustment
  • Taxation Item
  • Payment
  • Product Rate Plan Charge
  • Refund
  • Revenue Schedule
  • Credit Memo Item
  • Debit Memo Item

Type: enum

Deferred Revenue Accounting Code

Optional

Deferred revenue accounting code that you want to associate with the object.

Applicable if the Object Type is one of the following:

  • Invoice Adjustment (Deprecated on Production)
  • Invoice Item
  • Invoice Item Adjustment
  • Product Rate Plan Charge
  • Revenue Schedule
  • Credit Memo Item
  • Debit Memo Item

The accounting code must be active in your Zuora chart of accounts.

If you don't want to update the accounting code, leave this field blank.

Type: string

Character limit: 100

Recognized Revenue Accounting Code

Optional

Recognized revenue accounting code that you want to associate with the object.

Applicable if the Object Type is one of the following:

  • Invoice Item
  • Invoice Item Adjustment
  • Product Rate Plan Charge
  • Revenue Schedule
  • Credit Memo Item
  • Debit Memo Item

The accounting code must be active in your Zuora chart of accounts.

If you don't want to update the accounting code, leave this field blank.

Type: string

Character limit: 100

Sales Tax Payable Accounting Code

Optional

Sales tax payable accounting code that you want to associate with the object.

Applicable if the Object Type is one of the following:

  • Taxation Item
  • Invoice Item Adjustment

The accounting code must be active in your Zuora chart of accounts.

If you don't want to update the accounting code, leave this field blank.

Type: string

Character limit: 100

Bank Account Accounting Code    

Optional

Bank account accounting code that you want to associate with the object.

Applicable if the Object Type is one of the following:

  • Payment
  • Refund
  • Credit Balance Adjustment

The accounting code must be active in your Zuora chart of accounts.

If you don't want to update the accounting code, leave this field blank.

Type: string

Character limit: 100

Cash on Account Accounting Code

Optional

Cash on account accounting code that you want to associate with the object.

Applicable if the Object Type is Credit Balance Adjustment.

The accounting code must be active in your Zuora chart of accounts.

If you don't want to update the accounting code, leave this field blank.

Type: string

Character limit: 100

Unapplied Payment Accounting Code Optional

Unapplied payment accounting code that you want to associate with the object.

Applicable if the Object Type is one of the following:

  • Payment
  • Refund

The accounting code must be active in your Zuora chart of accounts.

If you don't want to update the accounting code, leave this field blank.

Type: string

Character limit: 100

On-Account Accounting Code Optional

Bank account accounting code that you want to associate with the object.

Applicable if the Object Type is one of the following:

  • Credit Memo Item
  • Refund

The accounting code must be active in your Zuora chart of accounts.

If you don't want to update the accounting code, leave this field blank.

Type: string

Character limit: 100

Response File Columns

The following table describes the columns added to the response file.

Column Description

Success

  • Returns Y if the record was successful.
  • Returns N if the record failed.
  • Remains blank if the record was not processed.

Error Message

Displays a brief description of the error if the record failed.

 

Last modified

Tags

Classifications

(not set)