Skip to Content
avatar image
Former Member

Document posting time

I want to display invoice and delivery document posting time

Help me out

Regards,

Vijay

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Best Answer
    avatar image
    Former Member
    Sep 17, 2008 at 05:44 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Sep 17, 2008 at 05:42 AM

    Do you mean on PLD?

    Add comment
    10|10000 characters needed characters exceeded

  • Sep 17, 2008 at 05:43 AM

    Hi,

    using query, you could do:

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

    Rgds,

    Add comment
    10|10000 characters needed characters exceeded