cancel
Showing results for 
Search instead for 
Did you mean: 

Display amount and currency in the same cell of grid

former_member243716
Active Participant
0 Kudos

I would like to see in a SAPbouiCOM.grid amount and currency into the same column (as picture sample).

If I set the type textedit I lose total... If I set the type as double (or the inherited from the query) I can not see the currency...

How can I do it in VB .net?

Thanks a lot

CV

Accepted Solutions (1)

Accepted Solutions (1)

former_member183373
Active Participant
0 Kudos

Hello Cristiano,

If this is a custom grid that you fill via query result you can try concatenating Amount and Currency columns.

Is this only for display or do you also need to make them editable seperately?

Thanks,

Atilla

former_member243716
Active Participant
0 Kudos

Thanks Atilla, is only display mode.

I try to concatenate Amount and currency in column type SAPbouiCOM.BoFieldsType.ft_AlphaNumeric and it's ok but the problem is when I set col.ColumnSetting.SumType = SAPbouiCOM.BoColumnSumType.bst_Auto the total-cell does not appear.

I could solve by entering a new text field outside the grid ( bottom column ) but I would like to know if there is a correct way (for example you can see the grid of purchase-analysis).

Thanks

former_member183373
Active Participant
0 Kudos

Hello Cristiano,

`Unit Price` columns does something similar to this. You can write the amount + currency as text to `Unit Price` column and form automatically reads it seperately. I examined this `Unit Price` column in an invoice form and looks like the column is bind to a UserDataSource which is also a `dt_SHORT_TEXT`. I checked the help file but I couldn't find a specific function for that.


Therefore my assumption is you would need a custom method to handle this like using a hidden column for amount. I will also follow this thread to see if someone has an easier solution.

Thanks,

Atilla

Answers (2)

Answers (2)

edy_simon
Active Contributor
0 Kudos

Hi Cristiano,

Unfortunately, this can not be done straight forward currently.

It is available to internal SAP only.


Regards

Edy


former_member185682
Active Contributor
0 Kudos

Hi Cristiano,

I neved did this. But I think that you need follow like suggestion.

I found this topic:

Grid: Format columns, currency etc | SCN

but with similar answer.


Best regards,

Diego Lother


View Diego Lother's profile on LinkedIn