Skip to main content
Solved

Retrieve value Customer from "Documents To Apply" tab in Payment

  • January 13, 2022
  • 3 replies
  • 112 views
I
Varsity I
Forum|alt.badge.img+2

Hi, 

I am trying to extract the value from customer in details, as it shown at screen its name is AdjdCustomerID

However, when I am getting this value in a code ,

 foreach (PXResult<AR.ARAdjust, AR.ARInvoice, PX.Objects.AR.Standalone.ARRegisterAlias, ARTran> gridRow in Base.Adjustments.Select())
                                {
                                    AR.ARAdjust _adjust = gridRow;
                               
                                    try { codeWordArtsyl = _adjust .AdjdCustomerID.ToString() + "VCARD"; }}

I am receiving codes (4096, 4078) instead of names ABCVENTURE, ARTCAGES as it is depicted at screenshot.

How to extract names of Customers from this tab ?

Best answer by Naveen Boga

Hi @Ivan  In ARAdjust table, system will store only the ID values ((4096, 4078)), but not the CD values(ABCVENTURE, ARTCAGES).

In order to fetch the CD values, make a another query to BAccount table fetch the data like below.

 

  foreach (PXResult<ARAdjust, ARInvoice, PX.Objects.AR.Standalone.ARRegisterAlias, ARTran> gridRow1 in Base.Adjustments.Select())
                {
                    ARAdjust _adjust = gridRow;

                    BAccount objBAccount = PXSelect<BAccount, Where<BAccount.bAccountID, Equal<Required<BAccount.bAccountID>>>>.Select(Base, _adjust.AdjdCustomerID);


                    try { codeWordArtsyl = objBAccount?.AcctCD.ToString() + "VCARD"; }}

 

3 replies

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

Hi @Ivan  In ARAdjust table, system will store only the ID values ((4096, 4078)), but not the CD values(ABCVENTURE, ARTCAGES).

In order to fetch the CD values, make a another query to BAccount table fetch the data like below.

 

  foreach (PXResult<ARAdjust, ARInvoice, PX.Objects.AR.Standalone.ARRegisterAlias, ARTran> gridRow1 in Base.Adjustments.Select())
                {
                    ARAdjust _adjust = gridRow;

                    BAccount objBAccount = PXSelect<BAccount, Where<BAccount.bAccountID, Equal<Required<BAccount.bAccountID>>>>.Select(Base, _adjust.AdjdCustomerID);


                    try { codeWordArtsyl = objBAccount?.AcctCD.ToString() + "VCARD"; }}

 

Naveen B - Acumatica MVP 🏆 | Independent Developer for Hire 🚀 ⏩ https://www.linkedin.com/in/boga-naveen-kumar-54079a66/
Chris Hackett
I
Varsity I
Forum|alt.badge.img+2
  • Ivan
  • Author
  • Varsity I
  • January 14, 2022

Hi @Ivan  In ARAdjust table, system will store only the ID values ((4096, 4078)), but not the CD values(ABCVENTURE, ARTCAGES).

In order to fetch the CD values, make a another query to BAccount table fetch the data like below.

 

  foreach (PXResult<ARAdjust, ARInvoice, PX.Objects.AR.Standalone.ARRegisterAlias, ARTran> gridRow1 in Base.Adjustments.Select())
                {
                    ARAdjust _adjust = gridRow;

                    BAccount objBAccount = PXSelect<BAccount, Where<BAccount.bAccountID, Equal<Required<BAccount.bAccountID>>>>.Select(Base, _adjust.AdjdCustomerID);


                    try { codeWordArtsyl = objBAccount?.AcctCD.ToString() + "VCARD"; }}

 

Thank you very much 

Naveen Boga
Captain II
Forum|alt.badge.img+19
  • Naveen Boga
  • Captain II
  • January 14, 2022

@Ivan Most Welcome :-) 

Naveen B - Acumatica MVP 🏆 | Independent Developer for Hire 🚀 ⏩ https://www.linkedin.com/in/boga-naveen-kumar-54079a66/
Terms & ConditionsCookie settingsAccessibility 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