SI.TAXRATE | Velixo

Overview

The SI.TAXRATE function returns the Percent field values of one or more corresponding Detail IDs defined in the Tax details form in Sage Intacct.

Syntax

=SI.TAXRATE(
    ConnectionName, 
    TaxDetailID
)

Arguments

The SI. TAXRATE function uses the following arguments:

Argument

Required/Optional

Description

ConnectionName

Optional

Provide one of the following values:

Connection name as defined in Connection Manager.
Velixo range expression defining a set of connection names.
An array of settings as described in the Multiple connections per formula article. We recommend using the VX.SETTINGS function to construct the array.

Omit the argument to return results for all compatible connections with default aggregation settings.

TaxDetailID

Required

One or more Tax Detail IDs for which the Tax Rate is to be returned.

Examples

Assuming the following configuration within Sage Intacct:

https://s3.ca-central-1.amazonaws.com/cdn.velixo.com/helpdesk/ztdof0y_5IcgNAUuxVFiiebBX8DoT0aszw.png

Example 1

=SI.TAXRATE(
    "Sage",
    A3
)

Description
Returns the Percent field defined for the Tax Detail ID defined in cell A2.

Result

https://s3.ca-central-1.amazonaws.com/cdn.velixo.com/helpdesk/TGBoAefbtl8_Nsk2Rk5r2ecLzHCsAWpLFA.png

Example 2

=SI.TAXRATE(
    "Sage",
    "Bad Debts"
)

Description
Returns the Percent field defined for the Bad Debts Tax Detail ID.

Result

https://s3.ca-central-1.amazonaws.com/cdn.velixo.com/helpdesk/-EeCQGF6BU7DR4hz7XGGA0knDlzAaAiqrw.png

Example 3

=SI.TAXRATE(
    "Sage",
    A3#
)

Description
Returns the Percent field defined for the Tax Detail IDs displayed by the array function in cell A3.

Result

https://s3.ca-central-1.amazonaws.com/cdn.velixo.com/helpdesk/OnHbAruhcq4ajABTLUCOFOUpyR2_fHPltw.png