Skip to main content
Solved

Add Field Unapplied Balance on AP302000 to Generic AP3020PL

  • 7 November 2022
  • 6 replies
  • 106 views

HI All,

I want to add a field Unapplied Balance as orange highlight on AP302000 to Generic AP3020PL

As image, I have added the Data Field AP Cury Upplied Bal

The Generic doesn't show it right.

Do you have any idea about this

Best regards,

Yên Chi

Best answer by chidao

Instead of using APPayment.CuryUnappliedBal, join APRegisterReport with APPayement and using field APPayment.CuryDocBal, schema field is APRegisterReport.DocBal

It will show the amount of unapplied

 

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

6 replies

Manikanta Dhulipudi
Captain II
Forum|alt.badge.img+13

Hi @chidao 

the field doesn't exist in the DB, meaning you wont be able to query it in a GI. It’s probably a calculated field.


  • Author
  • 113 replies
  • November 7, 2022

Thanks, @manikantad18 

do you know the right method to calculate this field?

I use this one, but it does not work for the transaction that has been Voided because it will calculate the voided amount also.

 


Manikanta Dhulipudi
Captain II
Forum|alt.badge.img+13

Hi @chidao 

I don't see an option to get the balance of the document, Wait for others to respond,

 

Good Luck!


  • Author
  • 113 replies
  • Answer
  • November 22, 2022

Instead of using APPayment.CuryUnappliedBal, join APRegisterReport with APPayement and using field APPayment.CuryDocBal, schema field is APRegisterReport.DocBal

It will show the amount of unapplied

 


Chris Hackett
Community Manager
Forum|alt.badge.img
  • Acumatica Community Manager
  • 2657 replies
  • November 22, 2022

Thank you for sharing your solution with the community @chidao !


Forum|alt.badge.img+1
  • Semi-Pro II
  • 228 replies
  • October 18, 2023

Just wanted to add that I had a similar need for ARPayment.CuryUnappliedBal and I was able to use the same method to obtain the unapplied balance in a GI, I just used the ARRegisterReport table instead of AP.


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