on 07-02-2014 11:06 AM
Can someone please help me with writing a query to pull Sales Analysis Report sorted and grouped by Sales Employee and Business Partner.
The report contains the following columns:
Sales Employee Name and Number, Business Partner Name & Number, Current Month Sales (or the month specified in the report parameter), Same Month's sale last year, YTD-Current Year, YTD-Previous Year
Also, if you are interested in working on small Business One projects, please contact me with your resume, rate and location. You can work remotely.
Thanks
http://wiki.scn.sap.com/wiki/display/B1/SQL+Queries
you can use query mentioned in link above as base query and modify it as required
Thanks
Navneet
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Sam
I am interested to work in doing small SAP projects .. Pls give me ur mail id
Regards,
K.Ramasamy
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Please contact me at SamAngel7@yahoo.com and we take it from there.
Hi Sam,
i think i can help you in your problem, and i am interested to work w/ you in your small SAP project.
please drop me an email and send me the details to contact you.
regards,
jeff
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Please contact me at SamAngel7@yahoo.com and we take it from there.
Hi,
If you got answer, please close this thread by marking correct answer.
Please check your email.
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.
Hi,
Try this query:
SELECT T0.CardCode, T0.cardname, T1.SlpCode, t1.Slpname,
(SELECT SUM(T2.Debit) - sum(T2.Credit) FROM JDT1 T2
INNER JOIN OJDT T4 ON T4.TransID = T2.TransID AND month(T4.Refdate) = month(getdate())
WHERE T2.ShortName = T0.CardCode AND T2.TransType in ('13','14')) AS 'Current month',
(SELECT SUM(T2.Debit) - sum(T2.Credit) FROM JDT1 T2
INNER JOIN OJDT T4 ON T4.TransID = T2.TransID AND Year(T4.Refdate) = 2014
WHERE T2.ShortName = T0.CardCode AND T2.TransType in ('13','14')) AS 'Sales 2014',
(SELECT SUM(T2.Debit) - sum(T2.Credit) FROM JDT1 T2
INNER JOIN OJDT T4 ON T4.TransID = T2.TransID AND Year(T4.Refdate) = 2013
WHERE T2.ShortName = T0.CardCode AND T2.TransType in ('13','14')) AS 'Sales 2013'
FROM DBO.OCRD T0 INNER JOIN OSLP T1 ON T0.SlpCode = T1.SlpCode
WHERE 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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
85 | |
7 | |
6 | |
4 | |
3 | |
3 | |
3 | |
3 | |
3 | |
2 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.