Issue With FMS on BoM

[Former Member]

Hi All,

I have created 4 udf's on BoM to capture Sales order No, SO date, Item code and Customer name. I have created FMS to capture so created in the system and they are working fine. The only problem that I am facing here is that as soon as i copy the item code from udf to product number and press tab, the values in the udf disappear. We have to search for the bom created and then update these values again.

These values are important because we have to generate an alert to production dept whenever a BoM is created based n any sales order. Please suggest how to configure this?

Thanks,

Joseph

[Former Member]

Hi Joseph,

Sales Order is better linked to Production Order. In that case, you got information already. No need UDF.

Thanks,

Gordon

[Former Member]

Hi Gordon,

I have created alert based on sales order but the person who creates BoM had to open the sales order and then copy the item code to create a new BoM. So I gave him this udf to capture item code and copy it from udf which doesn't work with Auto refresh but works well other wise.

Thanks,

Joseph

[Former Member]

Wow, Now its getting disappeared as soon as i select the row item. Any idea how to fix this?

Thanks,

Joseph

[Former Member]

The only work around I see is to just select the sales order o, use the fms in product number to get the item code, select row level item and then update the sales order number again and use auto refresh coz it now workin as desired anyway. Any other suggestions how to make this work?

Thanks,

Joseph

[Former Member]

Hi Joseph.....

Can you please paste you FMS here?

Regards,

Rahul

[Former Member]

hHi Rahul,

For Sales order;

SELECT T0.[DocNum], T0.[CardCode], T0.[CardName] FROM ORDR T0

For Item Code:

SELECT T1.[ItemCode] FROM ORDR T0  INNER JOIN RDR1 T1 ON T0.DocEntry = T1.DocEntry 
WHERE T0.[DocNum] = $[OITT.U_SoNo]

Thanks,

Joseph

[Former Member]

Hi Joseph...

I guess you need to modify this query.....

It would be

Select ltrim(str(T0.DocNum))+'!'+ltrim(str(T1.linenum)),  T0.CardCode, T0.CardName 
FROM ORDR T0 Inner Join RDR1 T1 On T0.DocEntry=T1.DocEntry

Select this in BOM in SO No. UDF. This will give you the SO no. with the Line No. in combination.

Then Apply

SELECT T1.[ItemCode] FROM ORDR T0  INNER JOIN RDR1 T1 ON T0.DocEntry = T1.DocEntry 
WHERE  ltrim(str(T0.DocNum))+'!'+ltrim(str(T1.linenum)) = $[OITT.U_SoNo]

in Item Code of BOM......

Hope this will work fine.....

Regards,

Rahul

[Former Member]

Hi rahul,

I tried with the queries tht you provided still I am facing the same problem. I guess this is system behavior. So, that leaves me with the work around. Any other suggestion.

Thanks,

Joseph

[former_member1269712]

Hi Joseph,

Can you paste your FMS for item code and size of that UDF??

Thanks

Sachin

[Former Member]

Hi Joseph.....

BOM might be the same for more than one SO. then in such case how SAP will recognize that this BOM is for particular SO?

Regards,

Rahul

[Former Member]

Hi Rahul,

I will explain the scenario to you.

We have created our standard BoM's. Every time we create a sales order, we create a new item. We copy this new item in udf (through fms) and then copy it to the product No. field. But as soon as we press tab, the values disappear. How to avoid this?

Thanks,

Joseph

[Former Member]

Hi Joseph......

Inspite of that I would recommend if a New SO is created it should go an alert to the production as well as development department.

Regards,

Rahul

[Former Member]

Hi......

Just do not put refresh regularly on anything and then check it.......

Regards,

Rahul

[Former Member]

Hi Rahul,

That did the trick.

Thanks,

Joseph