Hi, I am doing a GI to show the GL accounts for NonStock Items.
The NS Items are tied to a posting class. The posting class can use the default of Inventory Item (I) or Posting Class (P)
I am trying to get the GL account to be in one column.
My data field looks like this:
=iif ( [INPostClass.InvtAcctDefault]='I', [InventoryItem.InvtAcctID], [INPostClass.InvtAcctID])
The GI is returning 2037 instead of the GL#, 11302.
Is there a function or a way to get the 11302( The GL from the chart of accounts) to display?
Thank you,
Bill
Best answer by nhatnghetinh
View original