Hello,

Can anybody tell me exactly what session tfacp1433m000 (Print Registered Invoice Specifications) is supposed to ouput. Our Finance department are attempting to use it to show Purchase Invoices which are still waiting to be approved.

However despite the latest patches I am getting Purchase Invoices appearing on the report with blank approved in dates when I know that they have been approved.

Which tables is it getting this information from ?

Regards
Neal Matthews
Intier Automotive - Project Leader

Hi Neal,

It should be looking at all invoices where the 'Match with Orders' field <> 'no'.

It also seems like the report will show orders which were approved in the period you're running it for but the invoice was created before the period you ran it for. I'm not sure what the reasoning behind this is, but that may account for the invoices you are seeing.

Thanks again for the info Maria,

I think if may have a problem with my output on this one as the report is definately printing out records where tfacp200.appr = 2 Purchase Orders.

I'll see if I can get some more info from support.

Cheers

Neal

Reply from support

"The Report is showing :
Registered or matched invoices within the requested period that are not yet
approved in the requested period OR Approved invoices within the requested
period that are not yet Registered or Matched in the requested period.

I had tried this on your system for period 2002-01 to 2002-01 and it gave me
invoices :
- registered before periode 2002-01 and not approved yet
- invoices approved in 2002-01 and registered in another periode then 2002-01 !"

After a lot of digging around I found that the invoices for which I had blank approval dates had been approved in the incorrect company when we originally had our tfacp200 table shared for some reason. So the root cause of my problem was corrupt data.

Regards
Neal Matthews