Skip to Content
avatar image
Former Member

Alert on Payment Term

Hi All,

I want an alert on the invoice if the customer payment term is 30 days then it show an alert before 1 days to collect payment.

Thanks & Regards

Shiv

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

2 Answers

  • Best Answer
    avatar image
    Former Member
    Apr 10, 2010 at 03:08 PM

    Hi Shiv,

    You may start from this:

    SELECT T0.DocNum, T0.CardCode, T0.DocTotal, T1.PymntGroup

    FROM dbo.OINV T0

    INNER JOIN dbo.OCTG T1 ON T1.GroupNum = T0.GroupNum

    WHERE T1.PymntGroup LIKE '%30%' AND DateDiff(DD,T0.DocDueDate,GetDate()) = 29

    Thanks,

    Gordon

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Apr 15, 2010 at 11:05 PM

    I would suggest that you just look at the invoice due dates - 1 day regardless of the terms

    Add comment
    10|10000 characters needed characters exceeded