Excel Add-In for Zoho Books

Build 24.0.9111

VendorCreditBills

Retrieves list of bills to which the vendor credit is applied.

Table Specific Information

Select

The add-in uses the Zoho Books API to process WHERE clause conditions built with the following column and operator:

  • VendorCreditId supports the '=' comparison.

The rest of the filter is executed client-side in the add-in.

For example:

    SELECT * FROM VendorCreditBills WHERE VendorCreditId = '1894545000000083308'

Columns

Name Type References SupportedOperators Description
VendorCreditBillId [KEY] String Bill Id of vendor credit.
VendorCreditId String

VendorCredits.VendorCreditId

Id of a vendor credit.
VendorCreditNumber String Number of vendor credit.
Amount Decimal Amount of the vendor credited bills.
BillId String

Bills.BillId

Id of a bill.
BillNumber String Number of a bill.
Date Date Date of a vendor credit.

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