Invoice Approval date?

[nhsa]

Hi...
I'm trying to find out where is the invoice approval date, and approval by fields exist in the tables? We are using a manual method to approve invoices , using validate check box , and I want to create a report showing invoice created date, created by , validation date and validated by fields , but I can not find the validation fields , any help please , it's urgent issue.

Many thanks.

 

[mdwyer]

Did you look at AP.AP_INV_APRVL_HIST_ALL? That seems to have the right columns. But since we don't approve invoices, I have no data in that table to verify my assumption. Hopefully your mileage will vary.

 

[nhsa]

Hi and thanks for your help , I checked the table and it's empty, because we are not using approval workflow , we just let the user to choose validate check box from the action screen , Is this means that we can not see who validate invoices?

Thanks in advance

 

[mdwyer]

I'm sorry; I don't have the answer to that.

 

[lava1178]

Check ap_invoices_All table

 

[mdwyer]

Do you have a column for that, lava1178?

 

[nhsa]

I checked the table and I didn't find any column? But I have an idea i'm not sure if it's correct or not since I'm new to the ERP applications, if the invoice is validated , can we change any field on it, because if the system will lock this record , then the last update will be the date when the user validate the invoice? is this correct ?

 

[mdwyer]

I did a search on meta-link, and that seems to be the best answer available.