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 |
|---|---|---|
|
|
The inquiry has required parameters, but |
Add a row with a value for each parameter the message lists. |
|
|
A required parameter, or the |
Enter a value in the second column of that row. |
|
|
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. |
|
|
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 |
|
|
The range has no |
Add a row with |
|
|
The range doesn't have exactly two columns. |
Select a range with keys in the first column and values in the second. |
|
|
A key appears more than once. Keys are compared without regard to case, so |
Remove the extra row. |
|
|
A key contains a space or a punctuation character other than the underscore ( |
Use the parameter's Name, which contains no spaces. |
|
|
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. |
|
|
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. |
|
|
Your Acumatica version is earlier than 2024R2. Inquiry parameters require 2024R2 or later. |
Enter only the inquiry name in |
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.