cancel
Showing results for 
Search instead for 
Did you mean: 

Invoice Time

Former Member
0 Kudos

Hi,

i want invoice creation time.

doctime colum in oinv is not working for me.

Any idea from where i can get AR invoice creation time.

regards,

avijit

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hi Avijit,

It will not come by default. You can create a date field with sub type as time and enter the time when the add button is pressed.

Regards,

Satish.

Former Member
0 Kudos

Hi,

that i know .

but i have found the colum called doctime on OINV table.

what is the utility of that colum?

Former Member
0 Kudos

Hi Avijit,

You are right, doctime, gives the time, but not drilled down till the seconds info. It jus says as 1731, if your created time is 05:31 PM. If this is sufficient for you, then, fine.

Regards,

Satish.

Former Member
0 Kudos

its sufficient to me.

but how i will convert into time.

Former Member
0 Kudos

when i drag this field into crystal report its showing 12.00 AM only.

is there any method are available to convert into time.

Former Member
0 Kudos

select dateadd(minute, convert(integer, right(doctime,2))

+

convert(integer, left(doctime, len(doctime) - 2)) * 60, docdate) as date_with_time, * from oinv

Former Member
0 Kudos

Hi Avijit,

Thats exactly why i told that, you need to create a UDF for time and get the time there. Reason is, doctime is basically a shortint and you also can't edit that with the actual time.

Regards,

Satish.

Answers (0)