Good day,
I have the attached GI created. I am unable to show for “on-hold” check/payments the unapplied amount for these transactions. I check that correct column/field is curyUnappliedBal based on the inspection tool.
Any ideas why the unapplied balance field is empty. I have a number records on-hold that have an unapplied balance.
Please advise on if this my issue or an ACM issue.
Thank you
Evan
Best answer by RoyceLithgo
https://help.acumatica.com/dacBrowser/PX.Objects.AP/APPayment
Scroll down to CuryUnappliedBal - 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.
See if you can find an existing report that displays the value you are looking for and see how it is calculated in that report.
I am having a similar issue. Were you able to find a resolution for showing the unapplied payment balance in an GI?
https://help.acumatica.com/dacBrowser/PX.Objects.AP/APPayment
Scroll down to CuryUnappliedBal - 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.
See if you can find an existing report that displays the value you are looking for and see how it is calculated in that report.
Thank you. We will try to find another report to use as a guide.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
