Skip to main content
Answer

How to get Balance field value from CustomerBalanceSummary DAC

  • July 25, 2022
  • 4 replies
  • 177 views
C
Varsity I
Forum|alt.badge.img+1

Hi,

I want to show the value of Balance field which is in CustomerBalanceSummary DAC in Payments and Applications screen(AR302000). As usual, I was unable to use selector to get the Balance field value from the CustomerBalanceSummary DAC.

Any idea on this? 

 

Thanks.

Best answer by MoulaliShaik79

Hi @charithalakshan49,

  Please go through the below link, (I presume) this may help you.

https://help-2021r2.acumatica.com/(W(18))/Help?ScreenId=ShowWiki&pageid=6ed489c0-36a3-9790-7bcd-5072e718a728

 

 

Thanks,

Moulali Shaik.

4 replies

M
Semi-Pro II
Forum|alt.badge.img+1

Hi @charithalakshan49,

  Please go through the below link, (I presume) this may help you.

https://help-2021r2.acumatica.com/(W(18))/Help?ScreenId=ShowWiki&pageid=6ed489c0-36a3-9790-7bcd-5072e718a728

 

 

Thanks,

Moulali Shaik.

Moulali Shaik.
Chris Hackett
C
C
Varsity I
Forum|alt.badge.img+1

@Naveen Boga  Any idea on this?

anahizentella94
Jr Varsity III
Forum|alt.badge.img

Hi @charithalakshan49 

I did the following to obtain the Customer Balance Summary

 CustomerMaint graphCust = PXGraph.CreateInstance<CustomerMaint>();
               graphCust.BAccount.Current = cust;

                CustomerBalanceSummary bal = graphCust.CustomerBalance.Select();

With this you create an instance of CustomerMaint and you have in the bal variable all the information that is on the Customer screen.

Chris Hackett
Chris Hardgrove
Jr Varsity I

A less expensive way (avoid graph instantiation) is to sum the field ARBalances.CurrentBal.  Each row in the table carries the balance by branch and location.  So be sure to make the appropriate grouping, if needed.

Chris Hackett
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