Acumatica Business Central Sage Intacct STACK Takeoff & Estimate Velixo Classic
Acumatica Business Central Sage Intacct STACK Takeoff & Estimate Velixo Classic

Errors when passing parameters to a generic inquiry

Symptom

A GI, GILOOKUP, or GILOOKUPF formula that passes inquiry parameters in the Name argument returns #VALUE! instead of data. To see the error message, hover over the cell, or select the cell and click the warning icon next to it.

Causes and resolutions

Find the message you see in the Error column. In the messages, <inquiry>, <key>, <parameters>, <value>, and <n> stand for the values from your formula.

Error

Cause

Resolution

Error! Generic inquiry '<inquiry>' requires these parameters: '<parameters>'. Pass a two-column range as the "Name" argument, with giName and the inquiry name in the first row, and one row for each parameter with its name and its value

The inquiry has required parameters, but Name contains only the inquiry name or only the giName row.

Add a row with a value for each parameter the message lists.

Error! Provide a value for the '<key>' key in the "Name" parameter

A required parameter, or the giName row, has no value.

Enter a value in the second column of that row.

Error! The generic inquiry has no parameter named '<key>'. Its parameters are: '<parameters>'

The key doesn't match a parameter name. Common causes are a typo, using the Display Name instead of the Name, or a header row in the range.

Use a name from the list in the message, or remove the header row.

Error! Generic inquiry '<inquiry>' does not seem to have any parameters available. Check spelling and ensure that parameters are specified and active for this inquiry

The range contains parameter keys, but the inquiry has no active parameters.

Check the inquiry name and the Parameters tab of the inquiry in Acumatica. If the inquiry has no parameters, enter only its name in Name.

Error! The Name argument must contain the key 'giName', whose value is the generic inquiry name

The range has no giName row.

Add a row with giName in the first column and the inquiry name in the second.

Error! The Name argument's data range should contain two columns: the first listing giName and the parameter names, and the second containing their values. The range specified contained <n> column(s)

The range doesn't have exactly two columns.

Select a range with keys in the first column and values in the second.

Error! Duplicate keys detected in the "Name" parameter. All specified keys must be unique

A key appears more than once. Keys are compared without regard to case, so Warehouse and warehouse are duplicates.

Remove the extra row.

Error! The parameter name '<key>' in the Name argument contains a space or a punctuation character

A key contains a space or a punctuation character other than the underscore (_).

Use the parameter's Name, which contains no spaces.

Can't convert '<value>' to a number

Cannot recognize the value '<value>' as a GUID

Cannot recognize the value '<value>' as a date/time value

The date-time string '<value>' does not conform to any of the following date/time formats: …

'<key>' has invalid value '<value>': The value should match one of the following values: TRUE, FALSE, 1, 0

A value doesn't match the parameter's data type.

Enter a value of the right type. For accepted formats, see Parameter values in the GI article.

The ERP system rejected one of the parameter values passed to inquiry '<inquiry>': <parameters and values>. The value may not exist in the ERP system. Error from the ERP system: <message>

Acumatica rejected a value, for example, a project ID that doesn't exist.

Check that the value exists in Acumatica and that your user has access to it.

Query is not supported for ERP versions earlier than 2024R2

Your Acumatica version is earlier than 2024R2. Inquiry parameters require 2024R2 or later.

Enter only the inquiry name in Name, and remove the parameters from the inquiry or make them optional.

If a formula returns #N/A with Function returned zero rows, the parameters were accepted, but no records match them.

If GIFILTER returns #CALC! with Array cannot be lifted over to call a function on individual array members, you passed the two-column range to GIFILTER. Enter the inquiry name as text in GIFILTER instead.