FMS on Header Level Field in SAP b1

[Former Member]

hi,

I want to add FMS on header level in SAP b1 (OOEI) table

for example :-

i want to calculate Linetotal + Tax Amount +(Freight Amount from Base Document Table)

i got LineTotal & Tax Amount field from OEI1 table  but how to calculte fright amount(DLN3) from Delivery(ODLN) table.

please help me for solve this type of Query .

myQuery is like that -

select $[OIEI.DocTotal.Number] + (select SUM(LineTotal) from DLN3  where DocEntry = (select DocEntry  from ODLN where DocEntry = $[$38.45.0]))

pleaserly me as soon as possible.

Thanks

[Former Member]

Hi Kiran,

Actually your query is working fine after changing the table from OIEI to OOEI.

Use this for reference

select $[OOEI.DocTotal.Number] + isnull((select SUM(LineTotal) from DLN3  where DocEntry = (select DocEntry  from ODLN where DocEntry = $[$38.45.0])),0)

[Former Member]

actully i want to calculte fright value from Base document from Outgoing Excsie

i use your rly Query but it is not working they give me error

[Former Member]

Your FMS will work only after adding the outoging excise invoice document. Kindly check it after ading the document.

Again if you get error message , then post the error msg.

[Former Member]

actully i check FMS after adding Outgoing Excise Invoice & Before adding Outgoing Excise Invoice

but they give me error

error msg : Internal error (3006) occurred  [Message 131-183]

[kothandaraman_nagarajan]

Hi,

Try this :

select $[OIEI.DocTotal.Number] + (select SUM(LineTotal) from DLN3  where DocEntry = (select DocEntry  from ODLN where DocEntry = $[$-38.45.0]))

Thank you.