Skip to main content
Solved

Using an inventory ID in Results GI formula


Forum|alt.badge.img

Can you use a field (such as inventory ID) with a formula of the Results grid?

 

Attempting to add the following formula to a GI:

 

=IIf( [POLine.InventoryID]='Solid Surface', [SOLine.CuryUnitCost]+[POOrder.CuryVatTaxableTotal], [SOLine.CuryUnitCost]) 
 

Essentially saying if the inventory ID is Solid Surface, include the PO cost to the calculation, any other lines on POs, do not include.

It passes the validation but get the following error when loading the GI:

 

 

Are you able to use field within a GI like this?

Best answer by smilner3

This can be done. I think you should be joining in the Inventory DAC and looking at the InventoryCD field that is the user visible ID for your IIF condition. The InventoryID is an internal integer ID used in the Acumatica database. You can see the POLINE.InventoryID field is actually the integer value stored that’s why you’re getting an error when evaluating it to a string. 

 

 

 

View original
Did this topic help you find an answer to your question?

2 replies

smilner3
Varsity I
Forum|alt.badge.img
  • Varsity I
  • 28 replies
  • Answer
  • April 6, 2023

This can be done. I think you should be joining in the Inventory DAC and looking at the InventoryCD field that is the user visible ID for your IIF condition. The InventoryID is an internal integer ID used in the Acumatica database. You can see the POLINE.InventoryID field is actually the integer value stored that’s why you’re getting an error when evaluating it to a string. 

 

 

 


smilner3
Varsity I
Forum|alt.badge.img
  • Varsity I
  • 28 replies
  • April 6, 2023

Here is an example of joining in the Inventory Item Table.

 

And here is an example using the POLINE.INVENTORYID in a result formula.

 


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings