Skip to main content
Answer

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

  • April 3, 2025
  • 2 replies
  • 48 views

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.

2 replies

BenjaminCrisman
Acumatica Employee
Forum|alt.badge.img+4
  • Acumatica Support Team
  • April 4, 2025

@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’.


  • Author
  • Freshman II
  • Answer
  • 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.