SI.TAXRATE
Created by Damien Zwillinger, Modified on Wed, 30 Aug, 2023 at 2:56 AM by Damien Zwillinger
Applies to:
- Velixo NX
- Sage intacct
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, Range)
Parameters
The SI. TAXRATE function uses the following parameters:
Parameter | Required/Optional | Description |
ConnectionName | Required | The name of the connection as configured in the Connection Manager |
Range | Required | One or more Tax Detail IDs for which the Tax Rate is to be returned. |
Examples
Assuming the following configuration within Sage Intacct:
Example 1
=SI.TAXRATE("Sage",A3)Description
Returns the Percent field defined for the Tax Detail ID defined in cell A2.
Result
Example 2
=SI.TAXRATE("Sage","Bad Debts")Description
Returns the Percent field defined for the Bad Debts Tax Detail ID.
Result
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
Was this article helpful?
That’s Great!
Thank you for your feedback
Sorry! We couldn't be helpful
Thank you for your feedback
Feedback sent
We appreciate your effort and will try to fix the article