If you are facing any amount mismatch problem in trial balance report then you can cross check data with ledgertrans and ledgerbalancedimtrans table.
You can check amount dimension wise. You can get hints from below query.
select Sum(AmountMST) from _LedgerTrans group by AccountNum,transdate,Dimension[1],Dimension[2]
;
select sum(DebitMst),Sum(CreditMst) from _LedgerBalancesDimTrans where LedgerBalancesDimTrans.AccountNum ==_LedgerTrans.AccountNum &&
_LedgerBalancesDimTrans.transdate==_LedgerTrans.transdate &&
_LedgerBalancesDimTrans.Dimension[1]==_LedgerTrans.Dimension[1] &&
_LedgerBalancesDimTrans.Dimension[2]==_LedgerTrans.Dimension[2];
amt= _LedgerBalancesDimTrans.DebitMST + _LedgerBalancesDimTrans.CreditMST
You can check amount dimension wise. You can get hints from below query.
select Sum(AmountMST) from _LedgerTrans group by AccountNum,transdate,Dimension[1],Dimension[2]
;
select sum(DebitMst),Sum(CreditMst) from _LedgerBalancesDimTrans where LedgerBalancesDimTrans.AccountNum ==_LedgerTrans.AccountNum &&
_LedgerBalancesDimTrans.transdate==_LedgerTrans.transdate &&
_LedgerBalancesDimTrans.Dimension[1]==_LedgerTrans.Dimension[1] &&
_LedgerBalancesDimTrans.Dimension[2]==_LedgerTrans.Dimension[2];
amt= _LedgerBalancesDimTrans.DebitMST + _LedgerBalancesDimTrans.CreditMST