Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

FS Query the days of invoice delay

Hi Experts,

I need help to create formatted search query to get the number of days of delay most delayed invoice refreshed on BP Code

Thank You

Wojtek

Former Member
Former Member replied

Hi Wojciech,

Your question is not clear, can you explain more i think you requirement is

When you want to make Sales order that time you need which oldest invoice still not paid?

select DATEDIFF(Day,min(t11.DocDueDate),SYSDATETIME()) as 'Days' from OINV t11 where t11.CardCode=$[$OINV.4.0.0] and T11.[DocStatus]='O'))

Please try above FMS

Regards

Mukesh Singh

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question