Question

Create a new field in Generic Inquiry of Payment and Check

  • 11 November 2022
  • 4 replies
  • 179 views
M
Rank
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

M
Rank
Userlevel 3
Badge

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

J
Rank
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). 

 

 

Jini N
Naveen Boga
Rank
Userlevel 7
Badge +17

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.

 

1 Attachment
Naveen B
M
Rank
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


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