Dynamics Community Forum Thread Details

Issue on opening Trial Balance

Hi Team,

we are getting this message when we open trial balance, we think that someone has posted some transactions with a very big amount

SQL statement: INSERT INTO tempdb."DBO".t101024_6B85B5D8D1064DA18957DF3D81E44C3A (ACCOUNTINGDATE,AMOUNTDEBIT,AMOUNTCREDIT,LEDGERDIMENSION,POSTINGLAYER,DETAILSUMMARY,TRANSACTIONTYPE,PRIMARYFOCUS,CREATEDBY,DATAAREAID,RECVERSION,PARTITION) SELECT MIN(T1.ACCOUNTINGDATE) AS f1,SUM(T1.DEBITACCOUNTINGCURRENCYAMOUNT) AS f2,SUM(T1.CREDITACCOUNTINGCURRENCYAMOUNT) AS f3,T1.FOCUSLEDGERDIMENSION AS f4,T1.POSTINGLAYER AS f5,1 AS f6,1 AS f7,T2.DISPLAYVALUE AS f8,N'Admin' AS CREATEDBY,N'okcs' AS DATAAREAID,1 AS RECVERSION,5637144576 AS PARTITION FROM DIMENSIONFOCUSBALANCE T1 CROSS JOIN DIMENSIONATTRIBUTEVALUECOMBINATION T2 WHERE ((T1.PARTITION=5637144576) AND (((((T1.FOCUSDIMENSIONHIERARCHY=5637176826) AND (T1.LEDGER=5637145326)) AND (T1.ACCOUNTINGDATE>={ts '2018-03-21 00:00:00.000'})) AND (T1.ACCOUNTINGDATE<={ts '2019-03-20 00:00:00.000'})) AND (T1.FISCALCALENDARPERIODTYPE=1))) AND ((T2.PARTITION=5637144576) AND (T2.RECID=T1.FOCUSLEDGERDIMENSION)) GROUP BY T1.FOCUSLEDGERDIMENSION,T1.POSTINGLAYER,T2.DISPLAYVALUE ORDER BY T1.FOCUSLEDGERDIMENSION,T1.POSTINGLAYER,T2.DISPLAYVALUE