I want to change the sorting order of the records in the standard session.
I mean when we open the tiitm0101m00 session the records are shown in the item code order.But I need descending order of itemcode.like when I open the Item session it should show the items which are start with z then y like that.
Is it possible with out source code???

rgds,
jack

Refer to - Standard commands (http://www.baanboard.com/programmers_manual_baanerp_help_4gl_features_4gl_choice_sections)

Change the session start up option to - last.view or last.set

Suppose if I want to sort on Itemgroup rather than Item code.Is there anyway to do??

U can use the Tools--> Query for that purpose. Please note this may not always be efficient and speedy in response . Recommended to use sort ordering only on fields which are index fields using indices .

Hitesh is right.

Not sure if you get this filter/query warning in your BaaN Version or not. But using non-index fields you can result it into a full table scan and affect the performance.