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
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 ...Automatically Create Invoice History Summary by Date Through Defer Processing
Release Date: 09/26/2017 Updated: 12/4/2024 Q - Is there a way to enter responses to reports that will run deferred so that the responses change from run to run? Example: As per the attached screenshot to print an invoice summary, the goal is to have ...CP1720 Customer Order Processing Invoice History Report
Invoice History Report Application Overview This function gives you access to all the necessary information to provide customer service analysis and research for posted invoices on file for customers. Additionally, you can print Duplicate Invoices to ...CP0308S1 Customer Order Processing Purge Invoice History
Purge Invoice History Application Overview This enhancement purges the invoice history file. The user can enter the invoice cutoff date for the purge to end. All invoice headers and invoice line items will be deleted. This will help make invoice ...CP1725S Customer Order Processing Print Duplicate Invoice
Print Duplicate Invoice Application Overview This feature allows you to reprint invoices that have not been purged from the Invoice history File, (COP -> Util_Setup -> Purge Invoice History). The invoice will reprint as the original invoice and ...