Skip to main content

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 ?

 

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 @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 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

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


Terms & ConditionsCookie settings
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