Userfield in ITM1

[Former Member]

Hello,

I have added a userfield in table ITM1. It's ok, the userfield appears in the table but i can't access it or update it.

I get the following message :"Invalid field name"

This is my code for updating the userfield :

oItem_Price.UserFields.Fields.Item("u_slb_coef3").Value = 12

Have you ever add a userfield in this table ??

Have you some idea ???

Thank you .

Jocelyn

[Former Member · Accepted solution]

Hi Jocelyn,

You must ensure that the field name the exact same case as it is in the SQL database. U_SBO is not equal to u_sbo or u_Sbo. Open the table in SQL server and make sure what the field name and case is and try it again.

Hope it helps,

Adele

[Former Member]

Hello Adele,

You solved my problem, the error was in the case of the name of th userfield.

Thanks a lot, you're great !

Jocelyn

[Former Member]

Jocelyn,

R u using userdatasource or dbdatasource so that i can help u. Weather u cant able to insert the value aslo rite?

Regards,

Anitha