Excel Add-In for Zoho Inventory

Build 24.0.9060

CreditNoteRefund

Read, Insert,Update and Delete Refunds of CreditNotes.

Table Specific Information

Select

The add-in will use the Zoho Inventory API to process WHERE clause conditions built with the following column and operator. The rest of the filter is executed client-side within the add-in.

  • CreditNoteId supports the '=' comparison.

For example, the following queries are processed server side:

SELECT * FROM CreditNoteRefund WHERE CreditNoteId = '3350895000000089001'

Columns

Name Type ReadOnly References Description
AmountBcy Integer False

Refund Amount in Base Currency

AmountFcy Integer False

Refund Amount in Foreign Currency

CreditNoteId [KEY] String False

CreditNotes.Id

CreditNote Id

CreditNoteNumber String False

CreditNote Number

CreditNoteRefundId [KEY] String False

CreditNote RefundId

CustomerName String False

Customer Name

Date Date False

The date on which the credit note was raised. Format [yyyy-mm-dd]

Description String False

A brief description about the item.

ReferenceNumber String False

Reference number generated for the payment. A string of your choice can also be used as the reference number. Max-Length [100]

RefundMode String False

The method of refund.

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9060