Print Duplicate Invoice (No data which meets the current criteria)
Print Duplicate Invoice (No data which meets the current criteria)
(OP)
In a previous question I asked, I was given some instructions for fixing an invoice stuck in limbo.
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.
Quote (Peter Shirley)
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.
RE: Print Duplicate Invoice (No data which meets the current criteria)
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
RE: Print Duplicate Invoice (No data which meets the current criteria)
RE: Print Duplicate Invoice (No data which meets the current criteria)
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:
www.gainfocus.biz/exceladdin.html
RE: Print Duplicate Invoice (No data which meets the current criteria)
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
RE: Print Duplicate Invoice (No data which meets the current criteria)
RE: Print Duplicate Invoice (No data which meets the current criteria)
Seems to be the same with both versions.
RE: Print Duplicate Invoice (No data which meets the current criteria)
RE: Print Duplicate Invoice (No data which meets the current criteria)
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
RE: Print Duplicate Invoice (No data which meets the current criteria)
Delete it from teh dbo.oeordhdr_sql table or delete it from the macole ES gui?
RE: Print Duplicate Invoice (No data which meets the current criteria)
Peter Shirley
Macola Consultant, PA and surrounding states.
http://www.erpessentials.com