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
Solved
Add Field Unapplied Balance on AP302000 to Generic AP3020PL
Best answer by Christine
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
+16Hi
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.
Translate
Thanks,
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.
Translate
+16Hi
I don't see an option to get the balance of the document, Wait for others to respond,
Good Luck!
Translate
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
Translate
Thank you for sharing your solution with the community
Translate
+1Just 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.
Translate
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
Translate
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.