Skip to main content
Solved

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

  • Jun 18, 2025 7:23 AM UTC
  • 2 replies
  • 97 views
  • Translate All
Varsity I
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:

 

 

View original

    2 replies

    Varsity I
    Forum|alt.badge.img
    • johnh3
    • Author
    • Varsity I
    • Answer
    • Jun 18, 2025 7:26 AM UTC

    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:

     

     

    Translate
      Chris Hackett
      Community Manager
      Forum|alt.badge.img
      • Chris Hackett
      • Acumatica Community Manager
      • Jun 19, 2025 12:59 AM UTC

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

      Translate
      Chris ~ Let us know how we're doing: https://forms.office.com/r/xmJUdZ1QE5 - A member helped you, please *Like* their post. A member provided an answer to your question, please mark it as *Best Answer*.
        Terms & ConditionsAccessibility statement
        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