Skip to Content
avatar image
Former Member

Create Alert for Pending C-form

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.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • avatar image
    Former Member
    Dec 15, 2016 at 05:53 AM

    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

    Add comment
    10|10000 characters needed characters exceeded