Skip to main content
Solved

Outstanding checks report


Forum|alt.badge.img

Where is the outstanding checks report? I can’t find in Acumatica. 

Best answer by iqraharrison

Hi Enriquey,

in the past i updated the check register inquiry to include a “Cleared” column which updates as reconciliation statements are saved (doesn’t have to be upon release of the statement).

you can do this by going to the check register and clicking edit generic inquiry on the top right:

from there you can go to the results grid tab and add the following row (no need to add anything to the tables/relation as the APPayment table is already included in this inquiry)

at this point you can either either add the following condition (this will prevent the GI to include cleared checks or you can filter it out on the inquiry itself).  if you go with the first option, my recommendation would be to copy the Check Register inquiry and create a new one with the same details.

Hope this helps!

View original
Did this topic help you find an answer to your question?

2 replies

Forum|alt.badge.img
  • Varsity I
  • 14 replies
  • February 28, 2023

I haven’t been able to find an outstanding checks report, so I have used the reconciliation statements. After the header information, this report lists an unreconciled disbursements.

 


iqraharrison
Captain II
Forum|alt.badge.img+8
  • Captain II
  • 523 replies
  • Answer
  • February 28, 2023

Hi Enriquey,

in the past i updated the check register inquiry to include a “Cleared” column which updates as reconciliation statements are saved (doesn’t have to be upon release of the statement).

you can do this by going to the check register and clicking edit generic inquiry on the top right:

from there you can go to the results grid tab and add the following row (no need to add anything to the tables/relation as the APPayment table is already included in this inquiry)

at this point you can either either add the following condition (this will prevent the GI to include cleared checks or you can filter it out on the inquiry itself).  if you go with the first option, my recommendation would be to copy the Check Register inquiry and create a new one with the same details.

Hope this helps!


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings