on 09-24-2022 5:30 PM
Hi,
how can I see in SAP B1 how many times and when one specific article has been bought by one specific customer?
Thanks
Hi Marcus,
Please check this Query:
SELECT Distinct T0.*
FROM ORDR T0 INNER JOIN RDR1 T1 ON T0.DocEntry = T1.DocEntry
WHERE T1.[ItemCode] ='[%0]' and T0.[CardCode]='[%1]' Thank you,
Aziz
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
69 | |
14 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 | |
3 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.