Solved

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

  • 5 February 2022
  • 4 replies
  • 56 views

Userlevel 4
Badge +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 ?

 

icon

Best answer by Naveen Boga 7 February 2022, 06:15

View original

4 replies

Userlevel 6
Badge +3

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.

 

 

Userlevel 7
Badge +17

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;

 

Userlevel 4
Badge +2

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

Userlevel 4
Badge +2

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 

Reply


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