Skip to main content
Solved

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

  • February 5, 2022
  • 4 replies
  • 73 views

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;

 

4 replies

praveenpo
Semi-Pro III
Forum|alt.badge.img+3
  • Semi-Pro III
  • February 7, 2022

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.

 

 


Naveen Boga
Captain II
Forum|alt.badge.img+19
  • Captain II
  • Answer
  • February 7, 2022

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;

 


Forum|alt.badge.img+2
  • Author
  • Varsity I
  • February 7, 2022

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


Forum|alt.badge.img+2
  • Author
  • Varsity I
  • February 7, 2022

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