Skip to main content
Solved

Get AP Account value from Financial Details tab for Checks and Application item

  • Feb 5, 2022 9:37 PM UTC
  • 4 replies
  • 107 views
  • Translate All
Varsity I
Forum|alt.badge.img+2

Hi, 

I am trying to get this value 

Unfortunately only it’s ID available - 1173 instead of value 20000

How I should form my request in order to get it’s value ?

 

Best answer by Naveen Boga

Hi @Ivan  Use below BQL to fetch the AccountCD value.

 

Hope this helps!

Account objAccount = PXSelect <Account,Where<Account.accountID,Equal<Required<Account.accountID>>>>.Select(Base, Base.Document.Current.APAccountID);


string AccountCDValue = objAccount.AccountCD;

 

View original

4 replies

praveenpo
Semi-Pro III
Forum|alt.badge.img+3
  • praveenpo
  • Semi-Pro III
  • Feb 7, 2022 4:39 AM UTC

Hi Ivan,

AP Account field holds the ID values in DB and will show CD on the UI.
Use BQL to Account table to get the AccountCD  using Account ID.

 

 

Translate
Praveen
    Naveen Boga
    Captain II
    Forum|alt.badge.img+20
    • Naveen Boga
    • Captain II
    • Answer
    • Feb 7, 2022 5:15 AM UTC

    Hi @Ivan  Use below BQL to fetch the AccountCD value.

     

    Hope this helps!

    Account objAccount = PXSelect <Account,Where<Account.accountID,Equal<Required<Account.accountID>>>>.Select(Base, Base.Document.Current.APAccountID);


    string AccountCDValue = objAccount.AccountCD;

     

    Translate
    Naveen B - Acumatica MVP 🏆 | Acumatica Developer 🚀 ⏩ https://www.linkedin.com/in/naveenb-acumatica-mvp/
      Varsity I
      Forum|alt.badge.img+2
      • Ivan
      • Author
      • Varsity I
      • Feb 7, 2022 12:30 PM UTC

      Hi Ivan,

      AP Account field holds the ID values in DB and will show CD on the UI.
      Use BQL to Account table to get the AccountCD  using Account ID.

       

       

      Hi @praveenpo  . Thanks

      Translate
      Varsity I
      Forum|alt.badge.img+2
      • Ivan
      • Author
      • Varsity I
      • Feb 7, 2022 12:30 PM UTC

      Hi @Ivan  Use below BQL to fetch the AccountCD value.

       

      Hope this helps!

      Account objAccount = PXSelect <Account,Where<Account.accountID,Equal<Required<Account.accountID>>>>.Select(Base, Base.Document.Current.APAccountID);


      string AccountCDValue = objAccount.AccountCD;

       

      Hi @Naveen B . Thanks 

      Translate
      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