Print Duplicate Invoice (No data which meets the current criteria)

[ndininno]

In a previous question I asked, I was given some instructions for fixing an invoice stuck in limbo.

If you run the pre-post invoice register after everything has posted, then the 'stuck' order/invoice should show there and you will often be able to tell why. The most common reasons are duplicate invoice number and invalid GL accounts. Looking at your list of tables that the order/invoice exists in, it is not partially posted so you should be able to correct it by doing the following;

1). Print the invoice again (by enabling the print duplicates check box).
2). Respond NO when asked if the invoice printed OK.
3). Unselect the order.
4). Review the order and make any required changes.
5). Print the order.
6). Post the order.

Note that the steps above will assign a new invoice number.

When trying to do this for another order, I get "No data which meets the criteria entered". So from OE & RMA screen, I chose Invoices>Print Invoices. Then i pick the order number from the order header file

And when I click start I get the error mentioned. The status on this particular order is 8.

Any assistance is greatly appreciated.

 

[crystalreporting]

Status 8 is selected for billing. To print an invoice that is in status 8 you would just print the invoice i.e. you would not select the 'print duplicates' option.

The 'print duplicates' option is only used when you want to take an order that is status 9 (invoice printed) and move it back to status 8 (selected for billing). This occurs when you use the 'print duplicates' option and respond NO to the 'Did the invoice print OK' question.

Peter Shirley
Macola Consultant, PA and surrounding states.

http://www.erpessentials.com

 

[ndininno]

I get the same error whether print duplicate invoices is checked or not. Do you know what could cause this?

 

[dgillz]

If you unselected all the line items, or changed the date of the line items to be some future date, or if when you reselected you somehow put in a date date, this can happen.

Honestly just try it again, make sure of the dates, which items are to be invoiced and the qty to ship on each line. This has been working for 20+ years.

Software Training, Implementation, Programming and Support for Macola Progression, Macola ES, Macola 10, Synergy, and Crystal Reports.
Check out our Macola tools:

http://www.gainfocus.biz/exceladdin.html

 

[crystalreporting]

I get the same error whether print duplicate invoices is checked or not. Do you know what could cause this?

I have seen a similar problem whereby the Crystal version of the invoice print can get confused. Try using the COBOL version and see if you get a different result.

Peter Shirley
Macola Consultant, PA and surrounding states.

http://www.erpessentials.com

 

[ndininno]

OK I tried it again using the crystal print invoices option, didn't click print duplicates. The software crashed during this, and the status is 9 now, but when I try to view under OE enter orders i get "order already invoiced. access denied" It's not showing up in the customer card either.

 

[ndininno]

have seen a similar problem whereby the Crystal version of the invoice print can get confused. Try using the COBOL version and see if you get a different result.

Seems to be the same with both versions.

 

[ndininno]

OK so new info. I'm looking at the dbo.oeordhdr_sql tableand this particular order has an inv_no, inv_dt and the selection_cd column is X. Posted is NULL. I'm wondering if I can change some values in here to get it unstuck?

 

[crystalreporting]

The 'Order Already Invoiced' message simply refers to it being status 9.

At this stage I would take it back to a status 8, unselect it, delete the order altogether and enter a new one with the same details.



Peter Shirley
Macola Consultant, PA and surrounding states.

http://www.erpessentials.com

 

[ndininno]

The 'Order Already Invoiced' message simply refers to it being status 9.

At this stage I would take it back to a status 8, unselect it, delete the order altogether and enter a new one with the same details.

Delete it from teh dbo.oeordhdr_sql table or delete it from the macole ES gui?

 

[crystalreporting]

There are numerous tables that are written to when an order is created - delete it through Macola.

Peter Shirley
Macola Consultant, PA and surrounding states.

http://www.erpessentials.com