Question

Create a new field in Generic Inquiry of Payment and Check

  • 11 November 2022
  • 4 replies
  • 199 views

Userlevel 3
Badge

Hi,

I want to create a new field in Generic Inquiry of Payment and Check. This new field is the sum of all rows in Grid Documents to apply as following:

 

Do you know which field is used to grouping in this case? and in the similar case, how could we know which field is used?

 

 

Any help would be appreciate.

Thanks,


4 replies

Userlevel 3
Badge

Sorry for the title. I can’t update the title after Save :(

Userlevel 7
Badge +11

Hi @mrthanhkhoi 

You can find the field using the inspect element on the screen.

In your case, you are searching for the field,  APAdjust.CuryAdjgAmt (Amount paid). 

 

 

Userlevel 7
Badge +19

Hi @mrthanhkhoi  As you wanted to get the Total Amount paid value, you should not Group By with the Amount  Paid field. Please find the details below to achieve the requirement.

 

  1.  Make the join between ARPayment and ARRegister
  2. Group By with the Ref Nbr 
  3. Sum the Amount Paid value.

Attached screenshots.

 

 

 

Attached Generic Inquiry for reference → Please import this Generic Inquiry into your instance and verify.

 

Userlevel 3
Badge

Hi @Naveen Boga , @jinin 

Thank you very much for your help. 

I am able to create new field which is sum of all APAdjust.CuryAdjgAmt (related APPayment).

The final goal is creating a calculated field with fomular: APPayment.CuryOrigDocAmt-Sum(APAdjust.CuryAdjgAmt).

I tried with it, but I get the error as following:

 

 

I made research on the internet and there is a guy said that I should create a “temp” column to store sum all APAdjust.CuryAdjgAmt then create another to do the Subtraction. But I can’t find the “temp” column in list field after I create it.

 

Do you have any idea?

 

 

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