Skip to Content
0

Create Alert for Pending C-form

Dec 14, 2016 at 04:30 AM

57

avatar image

Dear Experts,

I need help with a query that will help me to generate alerts for pending C-forms.

Our process is like, we allow 5 months for the customer after the specific quarter to send us the c-form, if we do not receive the same after that period then we need an alert for it. so that we can take action on that customer.

Now what i am able to achieve is that i am getting alert for invoice that have crossed months, but i am unaware on how to check for the specific quarter in which the invoice is generated?

requestingn you to please help. let me know if you need more information.

thanks.

SQL
10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Pradnya S Dec 15, 2016 at 05:53 AM
0

Hi,

I am not very good at writing queries. You can make use of Case Statement in your query.

The syntax is as follows

Select Case

When 'Condition1' then 'Result1'

When 'Condition2' then 'Result2'

Else

'Resultn'

End

From <TableName>

Hope this will give you an idea.

Regards

Pradnya

Share
10 |10000 characters needed characters left characters exceeded