fms in item master data

[former_member487237]

Hi All,

I'm using multiple UOM. I created one udf under item master data warehouses as ' U_SinU' (Field Type is Quantity).

I tried like this but i know somewhere i'm wrong.

fms:

IF $[OITM.CntUnitMsr] = 'Cases1'

Select $[OITW.OnHand.number] * 24

ELSE 0 END FROM OITM T0 WHERE T0.ItemCode = $[$OITW.ItemCode]

Can anybody help me in this fms?

Thanks & Regards,

Sai

[former_member186712 · Accepted solution]

Hi Sai,

What are you trying to do?

Please explain by words,

Regards,

[former_member487237 · Accepted solution]

Hi Silva,

My stock is always in cases. But as per client req. , they want in units also. So i created udf under OITW table and trying to achieve my req. by fms.

1 case= 24 units.

If the actual stock (In stock) is 3 means 72 Units(U_SinU value).

Regards,

Sai.

[former_member186712 · Accepted solution]

Hi Sai,

Try this:

Select oitw.onhand * 24 from oitw inner join oitm on Oitm.Itemcode = Oitw.itemcode and oitw.whscode = '01' where oitw.itemcode = $[$5.0] and oitm.CntUnitMsr = 'Cases1'

Change the '01' to the warehouse you want to see.

Also check if the field CntUnitMsr as the 'Cases1'

I hope it helps,

Augusto

[a_grootens · Accepted solution]

Hello Sai,

In my opinion this can easily be achieved with standard functionality. In the Sales Data tab of your item you can set the UoM name and units:

In your sales document it will be shown as:

Kind regards,

Andy