1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34
| SELECT
DISTINCT [Kanabeach$Sales Line].[PfsSalesperson Code],
[Kanabeach$Customer].No_,
[Kanabeach$Customer].Name,
[Kanabeach$Customer].[TCO Customer],
(
SELECT
sum([Kanabeach$Sales Line].Amount)
FROM
[Kanabeach$Sales Line] , [Kanabeach$Sales header]
WHERE
[Kanabeach$Sales Line].[Document No_]=[Kanabeach$Sales header].No_
AND [Kanabeach$Customer].No_ = [Kanabeach$Sales Header].[Sell-to Customer No_]
AND [Kanabeach$Sales header].[Salesperson Code]=[Kanabeach$Sales Line].[PfsSalesperson Code]
AND [Kanabeach$Sales Header].[Order Date] > '20091115'
AND [Kanabeach$Sales Header].[PfsOrder Type] = 'PRECO'
HAVING sum([Kanabeach$Sales Line].Amount)>0
)
FROM
[Kanabeach$Sales Line] , [Kanabeach$Sales Header] , [Kanabeach$Customer]
WHERE
[Kanabeach$Sales Line].[PfsSalesperson Code] = '001'
OR [Kanabeach$Sales Line].[PfsSalesperson Code] = '002'
OR [Kanabeach$Sales Line].[PfsSalesperson Code] = '004'
OR [Kanabeach$Sales Line].[PfsSalesperson Code] = '008'
OR [Kanabeach$Sales Line].[PfsSalesperson Code] = '009'
OR [Kanabeach$Sales Line].[PfsSalesperson Code] = '011'
OR [Kanabeach$Sales Line].[PfsSalesperson Code] = '012'
GROUP BY
[Kanabeach$Sales Line].[PfsSalesperson Code], [Kanabeach$Customer].No_,[Kanabeach$Customer].Name,[Kanabeach$Customer].[TCO Customer]
ORDER BY
[Kanabeach$Sales Line].[PfsSalesperson Code], [Kanabeach$Customer].No_,[Kanabeach$Customer].Name,[Kanabeach$Customer].[TCO Customer] |
Partager