Skip to Content
avatar image
Former Member

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

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?

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Jan 06, 2017 at 06:46 AM

    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

    Add comment
    10|10000 characters needed characters exceeded