Skip to Content

Automatic Sales Order Block for overdue Outstanding from Customer

Hi Team,

Sales order should get blocked automatically if customer has not made payment for previous invoices within given credit period. E.g. If a customer has 45 days payment term and he has not made a payment within 45 days then once we try to create new sales order,system should block that sales order automatically and authorization should be given to a particular person to release the blocked sales order.

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

1 Answer

  • Best Answer
    Jan 18 at 10:16 AM

    Hi Team,

    The below approval query will give the solution for this question,

    SELECT Distinct 'True'

    from INV1 T1 Inner join OINV T5 on T5.DocEntry = T1.DocEntry

    Inner join OCRD T2 on T5.CardCode=T2.CardCode where T5.DocStatus='O' and DATEDIFF(Day,T5.DocDueDate,GETDATE())>'0' and T2.CardCode = $[ORDR.CardCode.0]

    Add comment
    10|10000 characters needed characters exceeded