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

After update to 7.8.200

After update to 7.8.200

After update to 7.8.200

Hello everyone... quick question.. We updated from 7.6 to Macola Progression 7.8.200 and it changed the sort by under: order entry, view, order history, by item #. If you look up a product, it sorts it by Macola Order #, and it used to sort by requested date. Is this something I can change? If so, where?

Thank you in advance again.

Josh Fuller

RE: After update to 7.8.200

Well, I got my answer from support... Not too thrilled either, as it makes life harder doing things this way. I will include what I was told:


The changes to the Order History View were made deliberately to correct the following issues:

Bug report-Customer avail rel - 42.569.865

OE History View by Item is significantly slower in 7.7.700. This was due to changes made for Bug #40.748.947 which reads in part:

"The OE Order History View By Item is not sorting correctly. The Normal OE Order History View and Reverse OE Order History View Listbox Lines display out of order."

This was first resolved by changing the Alternate Key Lookup on the OELINHST Table from Item/Location to TRX-ID while using a SQL-WHERE to filter for the correct Item Number prior to each File Start.

While this solution did put the display into Order Number Order, for larger OELINHST Tables, it also had the effect of slowing down the processing and display of records. Now, instead of going into the table based on a specific Item Number, the entire Table had to be read and filtered for the correct Item and/or Customer Combination.

The next solution (Version 47) varied the Alternate Key that was being used on OELINHST, depending on the parms that the user entered.

However, this solution caused problems when moving backward through the table (using the double arrow keys) because of a conflict between the key in use, and what different key elements in the records were being compared to, on their way backward.

The current solution simplifies the code to use one key moving forward and a similar key going backward. Both keys will allow for proper comparisons to be made between key elements in the records and what they are being compared to, both forward and backward.

Bear in mind that the following still holds true:

All 'C' Type Orders (if any) will appear at the beginning of the listbox display
All 'Q' Type Orders (if any) will appear the end of the listbox display

OEINQITM.DLL 77.800.0.48

We also found that a Screen Change needed to be made to: OEITMHSQ. The "Hold Status" Literal was partially invading the double arrows and needed to be moved to the left. Otherwise, the double arrows moving backward would not work.

RE: After update to 7.8.200


You can create your own search. What exactly would you like to do? Can you write your own SQL?

Software Training, Implementation, Programming and Support for Macola Progression, Macola ES, Synergy, and Crystal Reports. Check out our Macola tools: www.gainfocus.biz/exceladdin.html

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