P4205 with too many lines in Order

We have Sales Orders that are big: more than 200 lines. We have to deal with as is. The person who is using P4205 is very ungry: he spend his time searching for the good line in the grid: there is no QBE, and the grid is not sequenced with item code.
Any idea how to make life easier to that user ?

Hi "Panobois"

Just a quick "off the cuff" solution is to add a new Form Control (through form design) at the Header and set the filter properties to '=' and activate the wild card.

You could also resequence the grid (Grid Properties - data sort) and put "item number" at the top.

Good luck,

Sef van den Nieuwelaar
Australia
B732 on NT, XE on NT, B732/A73 on AS400, B733 on NT

Hi "Panobois",

I think, this issue better fit to the Developers Forum.
The answer generally is that you can use the FDA Designer Tool to accomlplish.

1.) You can override the sequencing of the Grid.
2.) You can enable the QBE on the Grid Properties window.
3.) Maybe you have to add the Short Item Number (ITM) BSVW field to the grid if you want to sort on it.
4.) ... and of course, see Sef's hints too.

Other considerations:
1.) You can sort only on BSVW columns but not on derived columns.
2.) On some forms the mentioned methods does not work when the application fill up the Grid programatically.
3.) On some Forms changing the sequence could cause problems when there are some special logic based on the hard-code sequence (e.g. totaling, etc.)
4.) Applying additional filtering also can cause problem when the logic requires to handle all line together (sometimes Master Business Functions requires this).

I have taken a glance to P4205 (just a glance!) and it seems so that you can enable QBE, add Short Item Number to the Grid and change the sequencing. Please, do not consider it a guarantee.

On the other hand, when the QBE is enabled then the Sequencing will be also enabled for the user on the grid.

Good luck,
Zoltán

P.S.: Please, attach your system configuration informations next time to your posts.

B7332 SP11, ESU 4116422, Intel NT4, SQL 7 SP1
(working with B7321, B7331, XE too)