Excel Add-In for Zoho Books

Build 24.0.9060

AccountDetailsBaseCurrencyAdjustment

Retrieves details of Base Currency Adjustment.

Table Specific Information

Select

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

  • CurrencyId supports the '=' comparison.
  • AdjustmentDate supports the '=' comparison.
  • ExchangeRate supports the '=' comparison.
  • Notes supports the '=' comparison.

NOTE: CurrencyId, AdjustmentDate, ExchangeRate, Notes are required to query AccountDetailsBaseCurrencyAdjustment.

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

For example:

    SELECT * FROM AccountDetailsBaseCurrencyAdjustment WHERE AdjustmentDate = '2023-03-16' AND CurrencyId = 3255827000000000097 AND ExchangeRate = '80.6719' AND Notes = 'adjustment'
	

Columns

Name Type References SupportedOperators Description
Accounts String Accounts.
CurrencyCode String The Currency Code.
AdjustmentDate Date = The Adjustment Date.
CurrencyId String

Currencies.CurrencyId

= The Currency Id of the customer's currency.
ExchangeRate Decimal = The Exchange rate of the currency.
Notes String = Notes for base currency adjustment.

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