cancel
Showing results for 
Search instead for 
Did you mean: 

Controlling an FMS field

Former Member
0 Kudos

Hi Experts,

I have created an FMS on Item Details field in Sales Order lines which copies the Item Description on to that field. The reason for doing this was utilising the character limit in the details field as salesmen can type lots of other information in it after the basic information is copied from the description. My problem is that as soon as a purchase order is created from SO the additional information typed in Item Details field gets removed. I understand it happens because the FMS is refreshed but is there a way to control that?

Thanks.

Kind Regards,

IC

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hi.........

From which form it gets removed?

SO or PO?

Have you tried by keeping FMS on Display Saved Values instead of Refresh regularly?

Please check that..........

Regards,

Rahul

Former Member
0 Kudos

Hi Rahul,

1. It was getting deleted in SO - now it does not

2. If I click on FMS search glass then the user added information gets deleted

3. It is getting deleted in PO

Essentially I do not want user to have permission to refresh only this particular FMS after he/she has added the info in the field.

Thanks,

IC

Former Member
0 Kudos

OK, on the other hand, is it possible to create a UDF on OITM table and pull it on the Sales Order line? That can also solve the purpose.

Regards,

IC

Former Member
0 Kudos

Hi,

That is in right path. However, the UDF in OITM will not be updated in Marketing Documents if you update this UDF after document created. Otherwise, it is a perfect solution.

Thanks,

Gordon

Former Member
0 Kudos

Thanks Gordon. But how to pull the OITM UDF on to the Sales Order rows?

Regards,

IC

Former Member
0 Kudos

Hi.......

Try this for OITM UDF at SO Level........

Select U_UDF From OITM Where ItemCode=$[RDR1.ItemCode.0]

Apply Above FMS in SO.....

Regards,

Rahul

Former Member
0 Kudos

You can try:

Select T0.U_UDF From OITM T0 Where T0.ItemCode=$[$38.1.0\]

Former Member
0 Kudos

Try this...

SELECT T0.[U_UDF]  FROM [dbo].[OITM]  T0 WHERE T0.[ItemCode] = $[RDR1.ITEMCODE]

Thanks,

Srujal Patel

Former Member
0 Kudos

Hi,

Both, Gordon and your, queries are throwing the following error:

1). [Microsoft][SQL Server Native Client 10.0][SQL Server]The multi-part identifier "T0.ItemCode" could not be bound. 2). [Microsoft][SQL Server Native Client 10.0][SQL Server]The multi-part identifier "OITM.U_SODetails" could not be bound. 3). [Microsoft][SQL Server Native Client 10.0][SQL Server]Statement 'Special Prices' (OSPP) (s) could not be prepared.

But when I click on the magnifying glass the FMS is updated.

Thanks,

IC

Former Member
0 Kudos

It should be:

Select T0.U_SODetails From OITM T0 Where T0.ItemCode=$[$38.1.0\]

You can not use both alias and table name in front of your field

Former Member
0 Kudos

This is working Gordon. Thanks.

I am testing other requirements. Will close once resolved.

Regards,

IC

Answers (1)

Answers (1)

Former Member
0 Kudos

Hi IC,

Try to Auto referesh on Display Saved User-Defined Values instead of Referesh regularly.

then click on FMS on Marketing document & type further information.

Thanks,

Srujal Patel