Monday, 8 May 2017

Trial Balance Detailed Generic Inquiry

Hi All,

During my last project I have faces a situation that Acumatica does not give us ability to see Trial Balance detailed by subaccount with denominated currency balance.
That information might be needed because of integration with 3rd party system.

They only things available:
  • Account Summary Inquiry screen - it gives us account balances withing base and denominated currency, but it does not give us information about subaccounts.
  • Trial Balance Detailed report - it gives us detailed information about subaccounts, but there is not balance in denominated currency.
But we have a solution under the cut.
But fortunately Acumatica has very powerful Generic Inquiries where we can construct such report within few minutes. To do that, we just need to combine few tables - GLHistory, Account and Subaccount, than apply filters and conditions.
And voila, we having new cool Trial Balance detailed dynamic report!

Full code snippet of Generic Inquiry.

Have a nice closing!

No comments: