Skip to main content
Solved

Field Customer Details


Forum|alt.badge.img
  • Jr Varsity III
  • 51 replies

in the customer detail screen seen from the DAC the data is taken from ARDocumentResult.
The question is how to retrieve the value in the currency balance field using the report designer?
because when in the report the data issued is the number 0 while on the screen it is not the number 0.
example: ics21005506

Best answer by Laura02

Hi @abdi , Try looking at other reports that show the customer’s balance. Maybe you can see the answer for how to calculate ‘currency balance’ in one of the AR Aging reports or  AR Balance by Customer.

View original
Did this topic help you find an answer to your question?

3 replies

Laura02
Captain II
Forum|alt.badge.img+19
  • Captain II
  • 3135 replies
  • Answer
  • July 12, 2022

Hi @abdi , Try looking at other reports that show the customer’s balance. Maybe you can see the answer for how to calculate ‘currency balance’ in one of the AR Aging reports or  AR Balance by Customer.


Forum|alt.badge.img
  • Author
  • Jr Varsity III
  • 51 replies
  • July 13, 2022

Hi @laura01 AR Aging report is data that is the result of the data I want, but when I try to check the report I try to find the AgeDate param in the filter not found


Laura02
Captain II
Forum|alt.badge.img+19
  • Captain II
  • 3135 replies
  • July 13, 2022

Hello, There is another post of the same question today.  Check this out; I hope it helps you move forward:

https://community.acumatica.com/distribution-6/what-table-is-best-to-use-for-customer-balance-10541

 

Laura


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings