Create Alert for Pending C-form

[former_member654795]

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.

[narayanis]

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