barendrecht82
Gebruiker
- Lid geworden
- 24 mrt 2013
- Berichten
- 230
Hallo,
Ik heb het volgende probleem.
In sql view BB_FMF krijg je alle grootboeknummers te zien met de beginbalans bedragen. Dit werkt en sluit.
In sql view FMF_per periode hoor je alle grootboeknummers te zien met de alle boekingen per periode en de bijbehoordende beginbalans. Nu zie je niet alle regels..
Dus ik wil in de FMF per periode dus alle regels zien die uit BB_FMF komen.. wat doe ik fout?
Ik heb het volgende probleem.
In sql view BB_FMF krijg je alle grootboeknummers te zien met de beginbalans bedragen. Dit werkt en sluit.
Code:
SELECT TOP (100) PERCENT dbo.View_Balans.GeneralLedger, dbo.grtbk.oms25_0, dbo.grtbk.bal_vw, ROUND(COALESCE (SUM(dbo.View_Balans.Expr2), 0), 2) AS bb
FROM dbo.View_Balans LEFT OUTER JOIN
dbo.grtbk ON dbo.View_Balans.GeneralLedger = dbo.grtbk.reknr
GROUP BY dbo.View_Balans.GeneralLedger, dbo.grtbk.bal_vw, dbo.grtbk.oms25_0
ORDER BY dbo.View_Balans.GeneralLedger
In sql view FMF_per periode hoor je alle grootboeknummers te zien met de alle boekingen per periode en de bijbehoordende beginbalans. Nu zie je niet alle regels..
Code:
SELECT TOP (100) PERCENT dbo.View_BB_fmf.GeneralLedger AS Expr1, dbo.View_BB_fmf.oms25_0, dbo.View_BB_fmf.bb AS BB, SUM(CASE WHEN MONTH(ReportingDate)
= '1' THEN (AmountDCDebit - AmountDCCredit) ELSE 0 END) AS [1], SUM(CASE WHEN MONTH(ReportingDate) = '2' THEN (AmountDCDebit - AmountDCCredit) ELSE 0 END) AS [2],
SUM(CASE WHEN MONTH(ReportingDate) = '3' THEN (AmountDCDebit - AmountDCCredit) ELSE 0 END) AS [3], SUM(CASE WHEN MONTH(ReportingDate) = '4' THEN (AmountDCDebit - AmountDCCredit)
ELSE 0 END) AS [4], SUM(CASE WHEN MONTH(ReportingDate) = '5' THEN (AmountDCDebit - AmountDCCredit) ELSE 0 END) AS [5], SUM(CASE WHEN MONTH(ReportingDate)
= '6' THEN (AmountDCDebit - AmountDCCredit) ELSE 0 END) AS [6], SUM(CASE WHEN MONTH(ReportingDate) = '7' THEN (AmountDCDebit - AmountDCCredit) ELSE 0 END) AS [7],
SUM(CASE WHEN MONTH(ReportingDate) = '8' THEN (AmountDCDebit - AmountDCCredit) ELSE 0 END) AS [8], SUM(CASE WHEN MONTH(ReportingDate) = '9' THEN (AmountDCDebit - AmountDCCredit)
ELSE 0 END) AS [9], SUM(CASE WHEN MONTH(ReportingDate) = '10' THEN (AmountDCDebit - AmountDCCredit) ELSE 0 END) AS [10], SUM(CASE WHEN MONTH(ReportingDate)
= '11' THEN (AmountDCDebit - AmountDCCredit) ELSE 0 END) AS [11], SUM(CASE WHEN MONTH(ReportingDate) = '12' THEN (AmountDCDebit - AmountDCCredit) ELSE 0 END) AS [12]
FROM dbo.View_BB_fmf LEFT OUTER JOIN
dbo.GeneralLedgerBalances ON dbo.View_BB_fmf.GeneralLedger = dbo.GeneralLedgerBalances.GeneralLedger
GROUP BY YEAR(dbo.GeneralLedgerBalances.ReportingDate), dbo.View_BB_fmf.bb, dbo.View_BB_fmf.GeneralLedger, dbo.View_BB_fmf.oms25_0
HAVING (YEAR(dbo.GeneralLedgerBalances.ReportingDate) = 2021)
ORDER BY Expr1
Dus ik wil in de FMF per periode dus alle regels zien die uit BB_FMF komen.. wat doe ik fout?