on 08-28-2015 11:11 AM
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
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)
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
107 | |
12 | |
11 | |
6 | |
5 | |
4 | |
4 | |
3 | |
3 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.