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
Already have an account? Login
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.
Sorry, we're still checking this file's contents to make sure it's safe to download. Please try again in a few minutes.
Sorry, our virus scanner detected that this file isn't safe to download.