BOM Quantity Calculations

[former_member252592]

Hi Experts i created FMS to sum up the quantites of BOM Row level to show on Header Level my FMS is

SELECT sum(T1.Quantity) FROM ITT1  T1 WHERE T1.Father =$[$3.2.11]

but its showing zero instead of Quantitiy sum

Can any one guide me what am i missing in this FMS

Regards

Jamil

[Former Member · Accepted solution]

Hi Jamil,

Thick Below Options in User Defined Values Setup.

Tick on Refresh Regularly Option.

Hope this helps

Thanks & Regards::::

Atul Chakraborty

[former_member252592 · Accepted solution]

thanx fro your reply Atul Chakarborty i appriciate it i tried it but its not working my SAP b-1 version is 8.82

[Former Member · Accepted solution]

Hi Jamil,

Replace your FMS with below.

SELECT sum(T1.Quantity) FROM ITT1  T1 WHERE T1.Father =$[OITT.Code]

and put above reply options i.e. Refresh Regularly.

Hope this helps

--

--

Thanks & Regards:::::

Atul Chakraborty

[Former Member]

Hi Jamil,

If its on header you should have - sign in fms.

try this

SELECT sum(T1.Quantity) FROM ITT1  T1 WHERE T1.Father =$[$-3.2.11]

Thanks,

Harshal