×
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

Order View (sort/order)

Order View (sort/order)

Order View (sort/order)

(OP)
Anyone having issues sorting / viewing most recent orders in Order View?

Environment:
Macola ES 9.5.800

Issue:
When attempting to view orders for a customer via Order View (OE & RMA - View - Orders/Invoices) the orders that are displayed on the page are not consistent. Attempts to sort by order number or date seems to only work for the current page and cannot "page up" to most recent as this will still only show the existing orders (makes sense from the query that gets submitted when page up is entered shown later but still wrong).

For example I attempt to view orders for a customer with a lot of orders (> 7450) so I go to OE & RMA - View - Orders/Invoices, type in a customer number and tab through to get the orders to list. The list that gets displayed may or may not be the most recent. If I escape and reenter the customer number and tab through again the list that is displayed may be or may not be the same as list I just saw and may or may not be the most recent.

When the list is not the most recent the Page Up button is available and when I click it the page does not change. The query behind the scenes that gets run is: select * from #oeinqtemp where id >= [someidnumberhere] where the idnumber appears random through each time of entering the view.

Note: it appears each page contains about 300 records.

Prior to this the queries that are run seem like everything should be good:
Create a temp table and fill it with all the orders (active & history) ordered by id

Running Procmon I don't find much of anything except at the point when the list is displayed FJMACEXE.EXE is looking for and cannot find macole.dll.dll
For kicks I copy macole.dll to macole.dll.dll this time in procmon FJMACEXE.EXE doesn't go looking for macole.dll.dll

This appears to be a bug however Exact support can't reproduce it so for them it is not a bug. I can reproduce it all day long for accounts with a lot of orders. I have not been able to reproduce so far with any account having less than 7450 orders.

Anyone else able to 1) reproduce 2) have a solution?

Thanks.

RE: Order View (sort/order)

(OP)
After more nudging, Exact has confirmed this as a bug.

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