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

      • 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 ...

      • Customer Account Summary Inquiry Age Days Calculation Logic

        Release Date: 07/07/2021 Version: 8.5 Q - In A/R Customer Account Summary Inquiry, what is the logic on a partially paid invoice? See example below: In the above example, invoice number AXI990 was partially paid on 6/18/21. That is 49 days after the ...

      • APINVIMS Accounts Payable Invoice Import Utility

        A/P Invoice Import Utility Introduction This utility is similar to the COP Sales Order Import Utility. It will allow vendor invoices created through an external source to be imported and become New A/P Transactions in Elliott. Traditionally, if a ...

      • 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 ...

      • ARFRMMNT Accounts Receivable Invoice Form Setup

        Invoice Form Setup Application Overview We are constantly striving to develop flexible and compatible business applications. The Invoice Form Setup application enhances this objective, by combining Elliott's standard Invoice form definitions, with a ...