on 03-19-2015 11:56 AM
Dear experts,
I need to create query for ,
Customer who has not spent at all in the last year.
Please assist,
Thank you,
hi
CHECK THIS ONE
SELECT DISTINCT T0.[CardCode], T0.[CardName]
FROM OINV T0 WHERE T0.[CardCode] not in (select T0.[CardCode] from OINV T0 where T0.[DocDate] > =[%0] AND T0.[DocDate] <=[%1])
AND UPDATE THE STATUS
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
hi SANTOSH
AS I SENT query is working for me ,, tell me what exactly your Requirement...
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
Try this query:
SELECT T0.[CardCode], T0.[CardName] FROM OCRD T0 WHERE T0.[CardCode] not in (select t0.cardcode from OINV t0 where datediff(yy,t0.docdate,getdate()) =1) and T0.[CardType] = 'c'
Thanks & Regards,
Nagarajan
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Or you can use "Inactive customer" report (Standard in SAP b1)
Business Partners >> Business Partner reports >> Inactive Customers
Fill in date from to get report for customers who have not spent since this date
When the report is opened it will have choice of tickboxes at the top (Quotations / Orders / invoices / Delivery notes etc.)
You can untick all apart from AR invoice and then hit refresh at the bottom of the screen
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
Try:
SELECT T0.[CardCode], T0.[CardName]
FROM OCRD T0
WHERE T0.[CardType] = 'c' and
T0.[CardCode] not in (select cardcode from OINV where datediff(yy,docdate,getdate()) =1)
Thanks,
Gordon
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
Try this
select distinct cardcode
from oinv
where CardCode not in (select a.cardcode from oinv a where a.[DocDate] > =[%0] and a.[DocDate] <=[%1])
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi santosh
check once bellow Document and analyze
http://scn.sap.com/docs/DOC-59629
and Give me Clear Requirement
Thanks®ards
Andakondaramudu
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
89 | |
7 | |
7 | |
4 | |
4 | |
3 | |
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.