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.
Full code snippet of Generic Inquiry.
Have a nice closing!