SI.UDDVALUEID

Created by Velixo Team, Modified on Mon, 26 May at 7:19 AM by Velixo Team

Applies to:

TABLE OF CONTENTS

Overview

The SI.UDDVALUEID function returns the value ID for a user-defined dimension (UDD) - a parameter used by the SI.QUERY or SI.WRITEBACK… functions when working with UDDs.

You can find the UDD value in Sage Intacct as well, but the SI.UDDVALUEID function is much more convenient.

=SI.UDDVALUEID(ConnectionName, DimensionName, DimensionValue)

The SI.UDDVALUEID function uses the following parameters:

Parameter	Required/ Optional	Description
ConnectionName	Required	The name of the connection as configured in the Connection Manager
DimensionName	Required	The integration name of the user-defined dimension ID for which you want to retrieve IDs.
DimensionValue	Required	The UDD value or range, as you see it in the Sage Intacct interface. This is a string for filtering user-defined dimension values. The DimensionValue string supports Velixo filtering techniques. The parameter is case-insensitive.

The function returns a spill range with UDD IDs, which you can use in SI.QUERY or SI.WRITEBACK… functions.

Say, you want to get IDs for the values of your UDD named SITE.

First, you can leverage the SI.EXPANDUDDVALUERANGE function to get all UDD values.

Then, get the UDD value IDs using SI.UDDVALUEID.

Note: using the “#” symbol (“A3#”) makes the function return values for cells A3 and below.