Can I SetLineData on the Order Entry Matrix?

[Former Member]

Hello, All.

Programatically writing cells to rows in the matrix on the Sales Order Entry form is slow.

So I am looking for a faster way.

A SDK developer told me that I can read and write the Sales Order Entry Matrix rows using GetLineData and SetLineData.

The SDK help file says you can't do that on a system form.

I tried it and it gives me that error message; ie, "Item - The Item is not a user-defined item [66000-8].

The developer showed me an email exchange with SAP that appears to say that it was a bug and has been fixed.

My version of the SDK is 8.82, according to the VB References page.

My code is like this:

SystemForm.oSalesMatrix.GetLineData(RowIndex)

SystemForm.oOrderForm.DataSources.DBDataSources.Item("RDR1").SetValue("ItemCode", RowIndex,   {ValidItemNo}      )

..... ' Set other values

SystemForm.oSalesMatrix.SetLineData(RowIndex)

1.) Can anybody confirm/deny that this should/should not work....

2.) If you see an error in my code what is it?

3.) Does anybody know fo a fast way to programatically write rows to the Sales Order Form Matrix?

Thanks,

Mark

[pedro_magueija · Accepted solution]

Hi Mark,

1. I don't think this should work. It would allow you to access the datasource (system) directly, avoiding any validations from the B1 application.

2 .The code is fine and would work on a User form.

3. And finally, and don't think there is a quick way to do this. The only way I know of is using the UI API to fill the lines.

Hope it helps,

Best regards,

Pedro Magueija

[Former Member]

Can you post your code please.