Close Date

[Former Member]

Hi everybody,

Which field on the SBO database tells when a Sales/Purchase document was closed?

Regards

--

Enriquillo Guigni

[Former Member]

hi,

i'm not sure why do u need to get this data thru query, is it that u need to see many documents' close date at once or anything else? if u just need to identify the close date of a particular document then u can goto that document and use Tools-Change Log option. there u can get the close date.

[Former Member]

I need to build a query with this particular information.

Regards.

--

Enriquillo Guigni

[former_member206488]

Dear,

The ClsDate field of that particular document show the closing date of that document.Check the header level table .

hope this will help you.

Thanks,

neetu

[Former Member]

Hi, this field is empty on SBO2007 Database. You can see this post that i made before.

Any other idea?

Thanks.

--

Enriquillo Guigni

[Former Member]

Hi Enriquillo Guigni,

"ClsDate" for Document Closing Date.

Regards,

Sachin