1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
| -- Recherche de doublons -------------------------------------------
select
t2.[Analysis View Code],
t2.[G_L Account No_],
t2.[Dimension 1 Value Code],
t2.[Dimension 2 Value Code],
t2.[Posting Date],
t2.[Entry No_],
t2.[Amount],
t2.[Debit Amount],
t2.[Credit Amount]
from dbo.[SOCIETE$Analysis View Entry] T1
left join dbo.[SOCIETE$Analysis View Entry] T2
on T1.[Entry No_] = T2.[Entry No_]
where T1.[Posting Date] between '01/08/2010' and '31/08/2010'
and T2.[Analysis View Code] ='DEPOT'
and T1.[Analysis View Code] ='MAGASIN' |
