cancel
Showing results for 
Search instead for 
Did you mean: 

Document posting time

Former Member
0 Kudos

I want to display invoice and delivery document posting time

Help me out

Regards,

Vijay

Accepted Solutions (1)

Accepted Solutions (1)

former_member187989
Active Contributor
0 Kudos

Delivery

SELECT T0.DocNum,T0.DocTime FROM [dbo].[ODLN]  T0 WHERE T0.DocDate >=[%0] AND  T0.DocDate <=[%1] ORDER BY T0.DocNum

AR Invoice

SELECT T0.DocNum,T0.DocTime FROM [dbo].[OINV]  T0 WHERE T0.DocDate >=[%0] AND  T0.DocDate <=[%1] ORDER BY T0.DocNum

Jeyakanthan

Answers (2)

Answers (2)

former_member186095
Active Contributor
0 Kudos

Hi,

using query, you could do:


SELECT T0.[DocTime] FROM OINV T0
union all 
select T1.[DocTime] from ODLN T1

Rgds,

Former Member
0 Kudos

Do you mean on PLD?