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
View original
+12
Hi
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,
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.
+12
Hi
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
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.
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.
