Modify Sales order line item Type

[Former Member]

Hey Guys,

I was wondering if there is a way through the DI or UI that I can change the type of a line item in a sales order matrix. I can change it through the Business One client to sub total or text on a line item and add comments. Is it possible to do this through code via DI or UI?

Any examples would be helpful.

[rasmuswulff_jensen · Accepted solution]

The line type is not released in the DI so no help there.

In the UI you should be able to manipulate the combobox value (Select method). Its not possible via datasources, and if the type-column is not shown and active it not possible at all... Sad but true.... Heard rumors the the type will be released for DI in SBO2005A SP1, but lets see

[Former Member · Accepted solution]

Thanks Rasmus,

Do you have any example code on how I might be able to do this? I have not done much with the combo boxes yet.

[rasmuswulff_jensen · Accepted solution]

Something like this.

ComboBox cb = (ComboBox)oMatrix.Columns.Item("COLUID").Cells.Item("row").Specific;

cb.Select("ValueToSelect",BoSearchKey.psk_ByValue);

Normal lines have "" (empty) value

Textlines have "T" value

Subtotals have "S" value

[Former Member · Accepted solution]

Hey Rasmus thanks so much. You have helped me solve the problem but for some reason I am unable to assign the reward points to you. I do not see the option to mark your answer as helpful and I am logged in.

[rasmuswulff_jensen · Accepted solution]

Hmmm. seems like the reward system is offline... If it works later i'l be happy to recieve your points, but else its ok... happy to be able to help you