on 10-02-2008 8:14 PM
Hi
has anybody created a Query on the Project Code Balance. I need an Alert to be set up to alert me when Project code Balance goes into Negative or below $500 example.
Thanks
Thanks, I will try and let you know
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Rosi,
The query bu Suda is actually looks like:
SELECT T0.Project, SUM(T0.Debit) AS 'Debit Amount', SUM(T0.Credit) AS 'Credit Amount',
T0.Project AS 'Project Code'
FROM [dbo].[JDT1] T0
WHERE T0.Project is not null
GROUP BY T0.Project
Thanks,
Gordon
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hello Gordon,
The reason why I did not use
T0.Project IS NOT NULL
is because this will return even the rows which do not have a project. The Project field does not have NULL but blanks. I am saying this as
I test my queries even it is after copying from the other post.
Rosi: In my original query I have the Project twice in my select which I have corrected in this one.
SELECT T0.Project, SUM(T0.Debit) AS 'Debit Amount', SUM(T0.Credit) AS 'Credit Amount'
FROM [dbo].[JDT1] T0
WHERE T0.Project != ''
GROUP BY T0.Project
Best wishes
Suda
Yes it could be any document in SAP where the Project Code can be used.( JE etc etc) It would apply to all Project or in the Query hard code just some?? Thanks
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
This is a simple query which will give you the Debits and Credit for each Project...you can further develop this by adding a date range and even hard coding certain projects
SELECT T0.Project, SUM(T0.Debit) AS 'Debit Amount', SUM(T0.Credit) AS 'Credit Amount',
T0.Project AS 'Project Code'
FROM [dbo].[JDT1] T0
WHERE T0.Project != ''
GROUP BY T0.Project
We are using Project Code on Transaction when we get Contribuions. Let's say I get an incoming Payment for $1000 wich goes to Project Code AAA. The $1000 was a contribution. Now I am paying out using the same Project Code AAA since it will be pulled from that same project. I am paying out $300 so I have $700 left. I want an alert if I go below $500 balance in that project.
Hope that helps. Thank you
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Please explain what you mean by Project Code balance going negative? It is not clear..
A business example would help
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
88 | |
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.