Using an inventory ID in Results GI formula

  • 6 April 2023
  • 2 replies

Userlevel 5

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 6 April 2023, 23:35

View original

2 replies

Userlevel 3

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. 




Userlevel 3

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


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



About Acumatica ERP system
Acumatica Cloud ERP provides the best business management solution for transforming your company to thrive in the new digital economy. Built on a future-proof platform with open architecture for rapid integrations, scalability, and ease of use, Acumatica delivers unparalleled value to small and midmarket organizations. Connected Business. Delivered.
© 2008 — 2024  Acumatica, Inc. All rights reserved