Sorting Sales Lines in Sales Order.

snehalppatel

Hello Friends,

In one of the projects, I need to sort Sales Lines of the Sales Order based on the No. of the Item. I tried using the DataItemTableView property to sort the Sales Lines as soon as they are inserted. But it doesn't work, it seems that the Line No. is causing the problem.

Please let me know if there is any other solution for accomplishing the above.

Thanks in advance.

Regards,
Snehal

snehalppatel

I just found that AutosplitKey is enabled on the Sales Order Subform, which is responsible for maintaining the Order of the Sales Line. What are the implications, if I add "No." field in the Primary Key prior to the "Line No." ???

Will it create conflict anywhere else?

Thanks,
Snehal

kapamarou

snehalppatel wrote:

What are the implications, if I add "No." field in the Primary Key prior to the "Line No." ???

Will it create conflict anywhere else?

Thanks,

Huge implications. Don't do that. It will break your system everywhere.
All the sales line functionality is based on that key. Your Line No. field which is filled automatically bu autosplit key won't work.

Why do you want this so badly?

snehalppatel

The system is to be developed for Sales Representatives, who take the Order details on the phone. Once, they start entering details in the Sales Order, they need a sorted view of the Sales Order Lines, so that they can see what items have been entered in the Sales Lines. Number of Sales Lines are more than 40-50. So, it would be easy for them to view them in sorted order of Item No.

Is there any alternate way to achieve this, other than changing the Primary Key?

Thanks,
Snehal

kapamarou

That can be achieved in other ways.

You can train them to change the key on the form using the sorting button when they want to review the order, and change it back when they want to insert.

You can create a new Non-Editable form that they can call for reviewing.

Or, even better, create a report that will show the lines sorted in whatever way you need.