Skip to Content
0

Unable to find data in ADOC table for documents with no change

Jan 06, 2017 at 03:39 AM

47

avatar image

Hi,

We have several AR invoices that we have backdated Posting Dates and Document Dates. E.g. the OINV.DocDate and TaxDate might show 01.01.2016 but it may have actually been created on 30.06.2016

If I check the change log, I can find the correct Update Date, however looking in the ADOC table, there are no entries if there have been no changes to the document since posting.

I've looked up some other similar posts online and it looks like this was an update to SAP B1 8.8 where the current revision is no longer stored in the ADOC table, and that it now only stores historical versions of the documents.

However, SAP must be storing the correct update date somewhere as it knows that the document was updated on a day different to the DocDate and TaxDate. I have looked at journal entries and can also only find the backdated dates, is there anywhere else that I can look?

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Jitin Chawla
Jan 06, 2017 at 06:46 AM
1

Hi,

Check this query:

select updatedate, createdate, DocDate , * from OINV where DocDate <> CreateDate

The Update Date is the date for the Invoice which any change was made.

The Create Date is the creation date of the Invoice.

The DocDate is the date on which the Invoice was added as date taken.

Check and let us know more what exactly is required.

Regards,

Jitin

Show 1 Share
10 |10000 characters needed characters left characters exceeded

Thanks Jitin, that was exactly what I was looking for!

0