How to Determine If An Invoice Is Fully Paid
Version: 7.5 & Up
Q - I can use Crystal Report to find a list of invoices in the CPINVHDR table. There's a column for INV_FULL_PAY_DATE in CPINVHDR, but it does not look like the value in this column is updated. Why?
A - To use the INV_FULL_PAY_DATE column in CPINVHDR, you should be aware of the following:
- The INV_FULL_PAY_DATE column is updated when the A/R Open File Is purged (A/R -> Processing -> Purge Closed Open Items -> Purge Open Item).
- Purge Open Item will move fully paid records from the AROPNFIL table to the ARHISFIL table. At the same time, the system will update the CPINVHDR.INV_FULL_PAY_DATE column. After the purge, you still can look at the history of AR records through various A/R History inquiries and reporting based on records in ARHISFIL.
- The big question is whether you perform “Purge Open Item” on a routine basis or not. If you don’t, then you need to adopt this new procedure in order to use the INV_FULL_PAY_DATE column.
- We do have many customers that perform “Purge Open Item” on a daily basis through Deferred Processing. For these customers, their AROPNFIL table is very small and only contains the outstanding unpaid or partially paid invoices. If they want to see paid invoices, they can use various A/R History inquiries or reporting.
- Please have an internal discussion to determine if you can adopt this new procedure to "Purge Open Item" on a daily basis, and possibly set up Deferred Processing to automate it.
EMK