Automatic Sales Order Block for overdue Outstanding from Customer

[former_member320372]

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.

[former_member320372 · Accepted solution]

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]