×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Contact US

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

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

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.

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)

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

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

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

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

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:
www.gainfocus.biz/exceladdin.html

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

Quote (ndininno)

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

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

(OP)
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.

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

(OP)

Quote (Crystalreportin)

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.

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

(OP)
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?

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

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

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

(OP)

Quote (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.

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)

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

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close