1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19
|
SELECT DISTINCT
YEAR(period),
[T0].[AccountNumber] AS [Code du compte], [T1].[FullName] AS [libellé du compte] ,
sum(case when [T0].[AccountNumber]=[T1].[AccountNumber] THEN [T0].[Totals_DebitAmount] END) AS [Total Mouvements Débits de lannée] ,
sum(case when [T0].[AccountNumber]=[T1].[AccountNumber]THEN [T0].[Totals_CreditAmount] END) AS [Total Mouvements Crédits de lannée],
(CASE
WHEN Totals_SoldAmount > 0 THEN Totals_SoldAmount
END) AS [Solde débiteur],
(CASE
WHEN Totals_SoldAmount < 0 THEN -Totals_SoldAmount
END) AS [Solde Créditeur]
FROM (([AccountTotals] T0
LEFT OUTER JOIN [Account] T1 ON (([T0].[AccountNumber] = [T1].[AccountNumber])))
LEFT OUTER JOIN [AccountingYear] T2 ON (([T0].[AccountingYearID] = [T2].[ID])))
GROUP BY
YEAR(period),
[T0].[AccountNumber] , [T1].[FullName], [T0].[Totals_DebitAmount],[T0].[Totals_CreditAmount],Totals_SoldAmount |
Partager