Column id in Sales Quotation grid

[sbastien_dubourdieu]

Hi experts,

I've to modify the matrix of the form Sales quotation to put some columns visible by default.

I notice that the ID shown by the "View System Information" functionality depend on the database where the add-on is launch.

Do you know how to get an invariant specific ID of each matrix's columns?

Thanks

Best regards.

Sebastien Dubourdieu

[Former Member · Accepted solution]

Hi,

AFAIK, Column ID in the sales quotation matrix will be same in all the databases independent of any add-on.

The above image is the system information of taxcode column in sales quotation. 'Form' is the Form ID of the sales quotation, 'Item' is the matrix Item UID and 'Column' is the column UID.

You can write like this to make the column bydefault visible.

Dim objMatrix As SAPbouiCOM.Matrix = objForm.Items.Item("38").Specific

objMatrix.Columns.Item("160").Visible = True

Regards

Kartheek

[sbastien_dubourdieu · Accepted solution]

Hi Kartheek,

On one of our database the "G/L account" column have the ID 159 and on another one the ID is 29.

Regards

Sebastien

[Former Member · Accepted solution]

Hi,

Can you attach screen capture of the "System Information" section of both forms?

Are both databases have the same localization? Which?

Beni.

[sbastien_dubourdieu · Accepted solution]

Hi beni,

See the screen capture below.

The database aren't on the same localization one is USA and the other one is Malaysia.

[Former Member · Accepted solution]

Notice that although titles of both columns are the same, they actually refer to different columns. One refers to AcctCode (ID=29) and one to FormatCode (ID=159).

Beni.

[sbastien_dubourdieu · Accepted solution]

It's the same object but on the US database the format code is the translation of the acctCode with a specific formatting

[Former Member · Accepted solution]

So the solution to your problem is to determine which column ID to use according the localization, or maybe even better, according to EnableAccountSegmentation property of CompanyInfo object.

Beni.

[sbastien_dubourdieu · Accepted solution]

Thanks Beni,

We will try to use the EnableAccountSegmentation Property to solve our problem!

Best regards,

Sebastien

[Former Member]

Hi Sébastien

Can u give an example for this behavior?

Beni.