Skip to main content
Solved

Is there a System Report which shows end of period Account Balance by subaccount with all UNPOSTED TRANSACTIONS included in reported balance?


Current procedure requires the manual selection by BRANCH to see the UNPOSTED BALANCE prior to release of activity that has been uploaded for each subaccount.  Is there a quicker way or system report that would return the end of period UNPOSTED BALANCE listed by SUBACCOUNT?  The Account by Subaccount only reflects the RELEASED BALANCE.

Best answer by HenryU

@BenjaminCrisman The account details screen does show the option to include the unreleased transactions.  The inefficiency we had is there are several subaccounts which are used for many different branches and to get the unreleased balance to verify to another proprietary system report, it required entering each subaccount manually to get the individual subaccount balance.  

I continued to play around in the system and think I solved the problem for now by combining the ACCOUNT by SUBACCOUNT to get the beginning balance and combining it with a GENERIC INQUIRY/PIVOT TABLE  that also allows for including unreleased activity in the report.  We then just have to add the debits and subtract the credits from the pivot table to get what the unreleased balance by subaccount would be.  

There may a different way but for now it works and takes less time so I count that as a win.  Hopefully this can help anyone else trying to do something similar.

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

BenjaminCrisman
Acumatica Employee
Forum|alt.badge.img+4

@HenryU Does the Account Details screen not contain what you’re looking for? It’s one of the only ones I saw which had the option for an ‘Include Unreleased’.


  • Freshman II
  • April 4, 2025

@BenjaminCrisman The account details screen does show the option to include the unreleased transactions.  The inefficiency we had is there are several subaccounts which are used for many different branches and to get the unreleased balance to verify to another proprietary system report, it required entering each subaccount manually to get the individual subaccount balance.  

I continued to play around in the system and think I solved the problem for now by combining the ACCOUNT by SUBACCOUNT to get the beginning balance and combining it with a GENERIC INQUIRY/PIVOT TABLE  that also allows for including unreleased activity in the report.  We then just have to add the debits and subtract the credits from the pivot table to get what the unreleased balance by subaccount would be.  

There may a different way but for now it works and takes less time so I count that as a win.  Hopefully this can help anyone else trying to do something similar.


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