on 06-03-2022 4:21 PM
Is there a way when a certain name is selected it also filters for the business partner? Lets say slpcode 39 in the master data OCRD table. Right now it does the selection on the invoice and credits but would like to do it for one sales person with a code.
--Invoice Details
SELECT T0.[SlpCode], T4.[SlpName],
T0.[DocDate], T5.[CardCode], T5.[CardName], T0.[DocNum],
T1.[ItemCode], T1.[Dscription],
T2.[ItmsGrpCod],
T3.[ItmsGrpNam],
T1.[Quantity], T1.[Price], T1.[LineTotal], T1.[DistribSum]
FROM OINV T0
INNER JOIN INV1 T1 ON T0.[DocEntry] = T1.[DocEntry]
INNER JOIN OITM T2 ON T1.[ItemCode] = T2.[ItemCode]
INNER JOIN OITB T3 ON T2.[ItmsGrpCod] = T3.[ItmsGrpCod]
INNER JOIN OSLP T4 ON T0.[SlpCode] = T4.[SlpCode]
INNER JOIN OCRD T5 ON T0.[CardCode] = T5.[CardCode]
WHERE T0.[DocDate] >= '[%1]' and T0.[DocDate] <= '[%2]'
AND T4.[SlpName] = '[%0]'
UNION ALL
--Credit Details
SELECT T0.[SlpCode], T4.[SlpName],
T0.[DocDate], T5.[CardCode], T5.[CardName], T0.[DocNum],
T1.[ItemCode], T1.[Dscription],
T2.[ItmsGrpCod],
T3.[ItmsGrpNam],
-T1.[Quantity], T1.[Price], -T1.[LineTotal], -T1.[DistribSum]
FROM ORIN T0
INNER JOIN RIN1 T1 ON T0.[DocEntry] = T1.[DocEntry]
INNER JOIN OITM T2 ON T1.[ItemCode] = T2.[ItemCode]
INNER JOIN OITB T3 ON T2.[ItmsGrpCod] = T3.[ItmsGrpCod]
INNER JOIN OSLP T4 ON T0.[SlpCode] = T4.[SlpCode]
INNER JOIN OCRD T5 ON T0.[CardCode] = T5.[CardCode]
WHERE T0.[DocDate] >= '[%1]' and T0.[DocDate] <= '[%2]'
AND T4.[SlpName] = '[%0]'
User | Count |
---|---|
98 | |
12 | |
10 | |
6 | |
6 | |
4 | |
3 | |
3 | |
3 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.