cancel
Showing results for 
Search instead for 
Did you mean: 

Delivery Approvals

Former Member
0 Kudos

Hello,

Can an approval be created on a sales order to warn if the customer is more than 60 days due on payment. If yes what is the process.

Thanks

Max

Accepted Solutions (0)

Answers (1)

Answers (1)

Former Member
0 Kudos

Hi,

Define approval procedure for sales order documents, then apply this query into Approval template >>> Term tab: with option 'When the Following Applies'

SELECT DISTINCT 'True' From OCRD T0 inner join OINV T1 on T0.cardcode=T1.cardcode
WHERE T0.CardCode =$[$4.0.0] and T1.DocStatus='O' and datediff(day, T1.DocDueDate, GetDate()) > 60

Hope this helps,

TVSon