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 ...Can I Get a List of Voided COP Invoices from Elliott?
Release Date: 02/24/2025 Version: 8.5 & up Q - Can I get a list of voided copy invoices from Elliott? Can a voided invoice number be re-used? A - Try COP -> Process -> Print Invoice -> Invoice Log. If you see the status is “Z”, then that invoice is ...ARCRDSCN Accounts Receivable Credit Card Log Report
Credit Card Log Report Application Overview This report shows all activity for credit card payments processed. With a wide range of selection criteria offered, it can also be used as an auditing tool to reconcile credit card statements. Run ...APINVIMS Accounts Payable Invoice Import Utility
A/P Invoice Import Utility Introduction This utility is similar to the COP Sales Order Import Utility. It will allow vendor invoices created through an external source to be imported and become New A/P Transactions in Elliott. Traditionally, if a ...ARFRMMNT Accounts Receivable Invoice Form Setup
Invoice Form Setup Application Overview We are constantly striving to develop flexible and compatible business applications. The Invoice Form Setup application enhances this objective, by combining Elliott's standard Invoice form definitions, with a ...