Feature - Invoice Log Report
Release date: 4/10/19
Version: 8.5 and up
We recently added a new Invoice Cross Reference File (CPINVXRF) table to Version 8.5. This table is updated when invoices are printed.
Read https://support.netcellent.com/portal/en/kb/articles/feature-prevent-duplicate-invoice-numbers-with-invoice-cross-reference-file for more details.
This feature adds a new report to print the information captured in this file. The report is found at: COP--> Processing --> Print Invoices --> Invoice log
Report selection fields are:
1. Starting Activity Date - Enter the starting activity date. This is the date that the invoice was printed. Press Enter for All dates.
2. Ending Activity Date - Enter the ending activity date.
3. Starting Order Number - Enter the starting order number. Press Enter for All orders.
4. Ending Order Number - Enter the ending order number.
5. Starting Invoice Number - Enter the starting invoice number. Press Enter for All invoices.
6. Ending Invoice Number - Enter the ending invoice date.
7. Order Type - Enter the order type. Valid options are I=Invoice, O=Order, C=Credit Memo, and Enter=All.
8. Status - Enter the order status. Valid options are Z=Posted, X=Invoiced, N=Printed But Not OK, S=Selected, and Enter=All.
9. Ship Via - Enter the ship via code. An F7 search is available. Press Enter for All ship via codes.
10. User Id - Enter an Elliott user ID. Press Enter for All users.
11. Source - Enter the invoice source. This is the application that generated the invoice. Valid options are CP0100=Order Entry, CP0300=Billing, CPSLSDSK=Sales Desk, CPONEINV=Print One Invoice, CPSBMENU=Fill Back Orders, CPSHPVER=Shipment Verification, CP03S2/XCP03S2=Print Invoices, and Enter=All.
12. Customer - Enter a customer number. An F7 search is available. Press Enter for All customers.
2. Ending Activity Date - Enter the ending activity date.
3. Starting Order Number - Enter the starting order number. Press Enter for All orders.
4. Ending Order Number - Enter the ending order number.
5. Starting Invoice Number - Enter the starting invoice number. Press Enter for All invoices.
6. Ending Invoice Number - Enter the ending invoice date.
7. Order Type - Enter the order type. Valid options are I=Invoice, O=Order, C=Credit Memo, and Enter=All.
8. Status - Enter the order status. Valid options are Z=Posted, X=Invoiced, N=Printed But Not OK, S=Selected, and Enter=All.
9. Ship Via - Enter the ship via code. An F7 search is available. Press Enter for All ship via codes.
10. User Id - Enter an Elliott user ID. Press Enter for All users.
11. Source - Enter the invoice source. This is the application that generated the invoice. Valid options are CP0100=Order Entry, CP0300=Billing, CPSLSDSK=Sales Desk, CPONEINV=Print One Invoice, CPSBMENU=Fill Back Orders, CPSHPVER=Shipment Verification, CP03S2/XCP03S2=Print Invoices, and Enter=All.
12. Customer - Enter a customer number. An F7 search is available. Press Enter for All customers.
The report has the following layout:
Modified programs: CP03S2, CPINVLGP (new), CPINVLGS ( new), XCP03S2
DLM
Related Articles
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 ...Feature - Invoice History Archive
Release Date: 8/23/21 Version: 8.6 and Above 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 ...Feature - Enforced Report Destinations
Release Date: 9/28/16 Updated: 10/4/2022 Versions: 8.5 and 8.6 Overview It is now possible for an administrator to require that certain reports are spooled to disk and/or emailed in the same way every time they are run. In the same manner, a specific ...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 ...Feature - Added the Ability to Purge the System Activity Log
Release date: 8/27/2018 This feature will give the user the ability to selectively purge the data from the System Activity log file (SYLOGFIL). This file stores the following information: Elliott user login Web Services login (from your website) ...