Feature - Invoice History Archive
The current invoice history data tables CPINVHDR, CPINVLIN, CPINVOPT, CPINVMTL, CPINVRTG, CPBOXFHS (history version of CPBOXFIL), CPBOXHSR (history version of CPBOXSER), CPBOXHST (history version of CPBOXSHP), …etc.
These tables can become very big, especially for customers who process a large number of invoices. This can cause slow processing when running Invoice History Inquiries or Invoice History Reports now that the database does not need to be purged due to alphabetic invoice number support. The following archive tables have been added to reduce the size of the database and still allow the data to remain on file without using a separate archive directory: CPINAHDR, CPINALIN, CPINAOPT, CPINAMTL, CPINARTG, CPBOAFHS, CPBOAHSR, and CPBOAHST. The data structures are the same.
When purging invoice history in Elliott 8.6 or after, instead of deleting the data the system will now move CPINV* records to CPINA*. The Invoice Inquiry programs now show the archive data along with the invoice history data. For example, if the invoice history data is purged through 12/31/2018 and the Invoice Inquiry By Invoice is run, data after 12/31/2018 is displayed from the Invoice History files while data one or before 12/31/2018 is displayed from the Invoice Archive tables.
A new Archive menu option is available for the Invoice Inquiry By Customer application. This application will only display data from the Invoice Archive tables instead of the Invoice History tables.
A new submenu has been added to Customer Order Processing-> Report-> Invoice History Report. The Archive submenu allows the user to print reports from the Archive database.
Programs Modified: CP0308.CBL, CP0400.CBL, CP1700.CBL, CP1702.CBL, CP1703.CBL, CP1704.CBL, CP1713.CBL, CP1720.CBL, CP1721P.CBL, CP1721P1.CBL, CP1721PO.CBL, CP1721S.CBL, CP1722P.CBL, CP1722S.CBL, CP1723P.CBL, CP1723S.CBL, CP1724P.CBL, CP1724S.CBL, CP1726P.CBL, CP1726S.CBL, CP1727P.CBL, CP1727S.CBL, CP1728P.CBL, CP1728S.CBL, IMBATFGP.CBL, IMBATGRP.CBL
Programs Added: CPINAHDR.DS, CPINAHDR.FD, CPINAHDR.SL, CPINAHDR.WS, CPINALIN.DS, CPINALIN.FD, CPINALIN.SL, CPINALIN.WS, CPINAMTL.DS, CPINAMTL.FD, CPINAMTL.IO, CPINAMTL.SL, CPINAMTL.WS, CPINAOPT.DS, CPINAOPT.FD, CPINAOPT.IO, CPINAOPT.SL, CPINAOPT.WS, CPINARTG.DS, CPINARTG.FD, CPINARTG.IO, CPINARTG.SL, CPINARTG.WS, CPBOAFHS.DS, CPBOAFHS.FD, CPBOAFHS.IO, CPBOAFHS.SL, CPBOAFHS.WS, CPBOAHSR.DS, CPBOAHSR.FD, CPBOAHSR.IO, CPBOAHSR.SL, CPBOAHSR.WS, CPBOAHST.DS, CPBOAHST.FD, CPBOAHST.IO, CPBOAHST.SL, CPBOAHST.WS
CLS
Related Articles
I Am Running Out of Invoice Numbers -- I Need Direction to Archive Invoices
Q: Within the next 6 months we will run out of invoice numbers. I don't want to purge my invoice history because it contains valuable data that I would like to go back to in the future. So I would prefer a method to archive my invoice history instead ...Feature - Allow Invoice History Inquiry to Drill Down to Order Inquiry
Release Date: 4/25/2018 This feature allows users to drill down to order inquiry from invoice history inquiry. This applies to two different types of invoice history inquiry: (1) From COP -> Inquiry -> Invoice History Inquiry -> Inquiry -> Invoice ...Feature - F7 to Print Duplicate Invoice in Invoice History Inquiry
Release Date: 2/9/16 This function allow users to use F7 function key in Invoice History Inquiry to print a duplicate invoice for the highlighted invoice. User must have the privilege to access menu item COP -> Processing -> Print Duplicate Invoice ...CP1700 Customer Order Processing Invoice History Inquiry
Invoice History Inquiry Application Overview This function gives you fast and easy access to all the necessary information to provide customer service for posted invoices on file for a customer. It allows you to quickly access and display a customer ...Feature - Payment History Inquiry
Release Date: 7/18/19 Version: 8.2 and Up This feature allows the user to see a customer's payment history summarized by date and payment document number. This is beneficial for accounts receivable and sales departments to easily view the payment ...