David Figueroa
17th April 2007, 00:21
Hi,

Solution #200326 refers to certain orders that show up on report of session tfacp1439m000 "Print Receivable Invoices upto period" when they should be cleared, because the invoices have been fully matched and approved to receipts.

I'm experiencing a similar situation with session tfacp1435m000 "Print GRNI Reconciliation - Balances", i.e., balances of orders fully matched and approved are being showed in the reports of the session (and they should not).

I will appreciate any information about a solution to this problem.

Best regards..

mtho33
24th April 2007, 08:11
Hi,
Please check whether you have archived the invoices that was matched and approved to the PO.

What I mean by archived is that you have run the session to remove fully paid invoices.

If you have done so then the PO will always show on the GRNI report.

David Figueroa
25th April 2007, 16:03
Hi,
Please check whether you have archived the invoices that was matched and approved to the PO.

What I mean by archived is that you have run the session to remove fully paid invoices.

If you have done so then the PO will always show on the GRNI report.

I'll check it, thanks mtho33!

mtho33
26th April 2007, 15:32
Great. Since you have archived the invoice in acp200 table, then you need to archive the GRINYA report as well.

I assume that you have installed the GRINYA functionality in your system where a new table tfacp135 was created to enable you to print the tfacp1435 report.
There was an archiving functionality for GRINYA where the report will not print the fiscal period that was archived. In this case, you can chose not to delete the records in acp135 table but the system will know that the records was archived. As such, the report will not show those periods that was archived.
Another effect of archiving is that session tfacp1235m000 will no longer select any records to acp135 table if the finalization period falls within the archived period.

David Figueroa
9th May 2007, 00:18
Great. Since you have archived the invoice in acp200 table, then you need to archive the GRINYA report as well.

I assume that you have installed the GRINYA functionality in your system where a new table tfacp135 was created to enable you to print the tfacp1435 report.
There was an archiving functionality for GRINYA where the report will not print the fiscal period that was archived. In this case, you can chose not to delete the records in acp135 table but the system will know that the records was archived. As such, the report will not show those periods that was archived.
Another effect of archiving is that session tfacp1235m000 will no longer select any records to acp135 table if the finalization period falls within the archived period.

I think we haven't performed archiving, but anyway I'm gonna check it, thanks mtho33