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 http://support.elliott.com/knowledgebase/articles/1906873-feature-prevent-duplicate-invoice-numbers-with-i 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