What Do I Do With "Invoice Printed But Not OK" Orders?

What Do I Do With "Invoice Printed But Not OK" Orders?

Q - I have an issue with an invoice that will not post. In the Order Inquiry, it shows that it has been billed and an invoice number has been assigned. 

I tried to un-select this order and re-bill, but the system tells me that "Order Invoiced But Not OK" or "Order Already Invoiced." I went to the pre-post edit list and there is nothing there. I tried going to the Open Item File in A/R, and nothing is there. I can't figure out how to resolve the issue.

A - First, let me explain the cause for this special condition.  

Cause of this Condition

There's a flag, ORDER_SELECTION_CODE, in the Elliott order header table (CPORDHDR).  This flag may have the following values:
  • I - Incomplete - This means someone is either in the middle of creating this order, or changing this order. It signals that no one should touch this order to avoid causing conflict.
  • C - Complete - This is the normal condition for an "O" type of order. It means the order is complete and ready for further processing, like printing a pick ticket or changing the order if need be.
  • S - Selected - Once an order is selected for billing, it will have this status.  The order is now ready for an invoice to be printed. If it is an "I" (invoice) or "C" (credit memo) type of order, then it will have this status by default.
  • N - Invoice Printed But Not OK - When Elliott prints an invoice for an order, it will first assign this status to the order.  At the end of the invoice printing, the system will ask, "Are Invoice Just Printed OK?"  If you answer "Y," then it changes the status to "X," which means the invoice printed.  If you answer "N," then it changes the status to "S."  So this status is temporary.
  • X - Invoice Printed - Once the invoice printed is OK, the value  changes from "N" to "X," and now the invoice is ready for posting.
  • Z - Invoice Posted - Once the invoice is posted, the status changes to "Z," and this order is protected, which means you can't make any further change to the order other than purging it from the system.
As you can see, the "N" status is a temporary situation that only exists in the middle of invoice printing.  Now let's imagine a user is in the middle of printing an invoice.  For whatever reason, the system locks up.  An order with an "N" status may never change to "X" or "S" because of the lockup.  When this happens, it can cause the above scenario.

What Do I Do with this Condition?

There are possible two solutions: (1) Print a duplicate invoice, or; (2) Void the invoice and re-print it.

Print Duplicate Invoice
You may go to COP -> Processing -> Print Invoice.  Choose to print only this one order and answer "Y" to "Print Duplicate Invoices?"  See sample screen below:



When you choose to do so, the original invoice number that was assigned to this order will be unchanged.

Void Invoice and Re-Print Invoice
You can also go to COP -> Util-Setup -> Void Invoice to void the invoice status of this order.  After that, you can print the invoice for this order in the normal way.  If you choose to do so, then a new invoice number will be assigned to this order.





    • Related Articles

    • Feature - Prompt "Are Purchase Orders Just Printed OK?" Message in Global Setup

      Release Date: 8/25/2024 Version: 8.5 and Above Background When printing purchase orders (PO), it is possible that a buyer may need to look at multiple separate POs at the same time. What this means is that the buyer will be in Purchase Order ...

    • Why Was This Invoice Printed but Not Posted?

      Released Date: 06/11/21 Version: 8.5 & Up Q - We have four orders where the invoice printed but the invoice date did not populate on the order header. We know the invoice hard copies printed because the orders can be tracked and we can scan the ...

    • Why Elliott 8.6 Does Not Prompt "Are Invoices Just Printed OK?"

      Release Date: 12/15/2023 Version: 8.6 & Up Q - When invoicing on 8.6 we have noticed that Elliott no longer prompts us to answer the question YES/NO Did Invoices Print OK? Is there a setup flag we can turn on? We really need the ability to say no. A ...

    • 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 ...

    • 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 ...