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