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

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

      • Why Would Invoice Balance Due Field Be a Credit?

        Q - We entered an order in the amount of $1,445 and applied an outstanding open credit of $1,445 to the order. The order was later revised to $867, but the already applied open credit of $1,445 was not adjusted by the order entry person manually. Now ...

      • Feature - Prevent Duplicate Invoice Numbers with Invoice Cross Reference File

        Release Date - 3/25/19 Version: 8.5 and Up This feature uses a new table, the Invoice Cross Reference table, to determine if an invoice has already been used by another unposted or posted order. The Invoice Cross Reference is updated at the time of ...