Hi,

I'm having issues when trying to reconcile my GRNI numbers with the actual Ledger numbers for invoices actually paid. Even though invoices are matched and approved, I still see them on the GRNI report as 'not invoiced'.

Looking at the table level, I see that for those that show up as 'not invoiced', the tfacp250 table has them as approved (tfacp250.apry, aprp, data), with the approval year and mnth filled in. But, in the tfacp251 table the same fields are empty.

This is the only pattern I see....
Purchase orders, which are matched by receipt, and which have been used in the "Approve by Receipt" functionality, but which have also been used in the "Approve by Order" functionality do not have the approval date information (date and year and period) filled in tfacp251.

I have a correction program to populate the missing fields and fix this problem, for now.
Shouldnt the system stop me from doing a 'Approve by Receipt', If I've already done a 'Approve by Order' for the same Pur Order?

But how do I avoid this from happening from a procedural stand point.
All suggestions are welcome. Thanks

Regards
LittleJohn

I thought that if you approve by order you shouldn't get a record in tfacp251. Maybe you are behind on patches?

Hi MariaC,
Thnks for the response.

I checked out all the solutions, I've them installed and we are presently at SP18.

LittleJohn