cancel
Showing results for 
Search instead for 
Did you mean: 

Project Code Alert

Former Member
0 Kudos

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

Accepted Solutions (0)

Answers (5)

Answers (5)

Former Member
0 Kudos

Thanks, I will try and let you know

Former Member
0 Kudos

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

former_member583013
Active Contributor
0 Kudos

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

Former Member
0 Kudos

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

former_member583013
Active Contributor
0 Kudos

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

Former Member
0 Kudos

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

former_member583013
Active Contributor
0 Kudos

Is it only Incoming or Outgoing payments you use projects or any other documents too....

Also how would the system know which projects...does it apply to all project that are defined in the system...

former_member583013
Active Contributor
0 Kudos

Please explain what you mean by Project Code balance going negative? It is not clear..

A business example would help