Skip to main content

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

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.


Reply