Skip to main content
Solved

Email Accounts (SM204002) - How to Retrieve Email Account ID - Number

  • June 18, 2025
  • 2 replies
  • 30 views

Forum|alt.badge.img

Hi there,

I’m trying to create an import scenario for SM204002.

I cannot obtain the number associated with the Email Account ID for the import to work. “EmailAccountID” is the key field, however, it is stored as an integer. 

My attempt at creating a GI to pull this information only reveals the Account Name.

 

To illustrate, in the second screenshot below, looks Acumatica requires the integer, rather than the name displayed.

 

 

Yet when a GI is created, no integer is provided, only the Account Name
 

 

How do I go about obtaining the integer key field for my import EmailAccountID?

Best answer by johnh3

Nevermind, I figured out another solution, instead of trying to obtain the integer key, I’ve changed the import scenario to perform a look up using the Account Name instead:

 

 

2 replies

Forum|alt.badge.img
  • Author
  • Jr Varsity III
  • Answer
  • June 18, 2025

Nevermind, I figured out another solution, instead of trying to obtain the integer key, I’ve changed the import scenario to perform a look up using the Account Name instead:

 

 


Chris Hackett
Community Manager
Forum|alt.badge.img
  • Acumatica Community Manager
  • June 19, 2025

Thank you for sharing your solution with the community ​@johnh3!