Invoice History

[Former Member]

Hi All!

How to track the historical details of invoices?

Means an invoice is posted on June but got closed only by August. if we want to see the status of tat doc during July (which is open) how to achieve?

via query we retrieve the Invoice details between a date range. If the query been run for date range betwn june n july, the docstatus will be shown as closed. but the docment is closed only after tat date range. How to capture the history details?

hav checked the ADOC and ADO1 tables, but those too show the same datails as in OINV n INV1.

Hav any one tried this b4?

Kindly help,

Thanks,

[former_member187989 · Accepted solution]

Click Open A/R invoice > Tools>Change Log

Jeyakanthan

[Former Member]

HI Shivanesh,

Based on your posting, you have checked ADOC and ADO1 already. All those records can be showed on the Change Log.

If nothing can be found from those tables and your system works ok, it means nothing changed from the invoice before August closing. The status of your invoice should be always open during July. What is your issue for this invoice?

It sounds like something has been changed but no trace anywhere. I highly doubt that is the case. If it is true, you need to check all your history tables to make sure they are working properly.

Thanks,

Gordon