How to Determine If An Invoice Is Fully Paid

How to Determine If An Invoice Is Fully Paid

Release Date: 03/10/2023
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


      • Related Articles

      • Crystal Report Conversion for V8.5

        A major improvement in Version 8.5 is the support of alphanumeric document numbers. This significant change adds flexibility and addresses the pressing issue that many Elliott users faced, which is running out of order and invoice numbers. The ...

      • How to Create CPHSTTRX_VIEW with Left Join to CPINVHDR Due to Invoice Database Archive

        Release Date: 12/6/2019 Version: All Q - I had to run Archive Invoices in the old fashioned way as the company ran out of invoice numbers and I didn’t have time to go to 8.5 (modifications). I ran the Archive procedure as outlined in the KB article ...

      • FULLPAY Accounts Payable Reset Fully Paid Status

        Reset Fully Paid Status Application Overview The Reset Fully Paid Status application will reset the fully paid status for records in the A/P Open Item File. This application is available so that if there is ever any doubt about the status of existing ...

      • Feature - Credit Memo Warning When Fully Paid

        Release date: 9/14/2019 Version 8.5 & Up Users can enter a new Credit Memo using COP, Order Entry, Change Mode, and pressing F3 or F4 at the Order Number field. When using the F4 option, the application allows the user to pick the invoice to apply it ...

      • CPFRMMNT Customer Order Processing Invoice Form Setup

        Invoice Form Setup Application Overview We are constantly striving to develop flexible and compatible business applications. The Invoice Form Setup application and Design Your Own Invoice enhance this objective, by combining Elliott's standard ...