Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Order View (sort/order)

Status
Not open for further replies.

allogagan1

Programmer
Aug 13, 2010
11
US
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.
 
After more nudging, Exact has confirmed this as a bug.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top