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.

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.

Hi @chidao 

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

Good Luck!

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

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

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.

In 2023 R2, successfully added ‘Unapplied Balance’ to AR3020PL

Table:  PX.Objects.AR.ARRegister

Relations:
Table Relation
ARPayment LEFT ARRegister 

Data Field links for Active Relation 
refNbr Equals refNbr 
docType Equals docType
 

Results Grid: 
ARRegister- CuryDocUnpaidBAL