Skip to Content
avatar image
Former Member

Help in FMS Query to automate ITEM Based Delivery Note

Dear Experts

I need a FMS query which calculate 10 % along with the Item cost , and get auto posted the amount in Unit price in Delivery note, and this is only for 1 or 2 customer which i wish to assign.

i had try with a coding, but it gives me an error,

'1). [Microsoft][SQL Server Native Client 11.0][SQL Server]Operand data type nvarchar is invalid for multiply operator. 2). [Microsoft][SQL Server Native Client 11.0][SQL Server]Statement '' (SWEI) (s) could not be prepared.'

pls help me to edit my coding

Regards

select ($[DLN1.StockPrice]*$[DLN1.Quantity])+(10/100)
FROM DLN1
INNER JOIN ODLN ON DLN1.DocEntry = ODLN.DocEntry
WHERE ODLN.CARDCODE = 'RB00000689'
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    Aug 16, 2017 at 09:13 AM

    Hi Shahan,

    This will calculate the 10% from item cost as per warehouse and add with the item cost

    SELECT (($[$38.37.number]) * 0.10) + ($[$38.37.number]) where ($[ORDR.CardCode] ='C20000' or $[ORDR.CardCode] ='C30000')

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Aug 16, 2017 at 09:43 AM

    Dear Shahan/Vindo,

    Please try the below FMS .Check the item cost field where it is because as per my FMS configuration is itemcost as per warehouse.

    SELECT (T0.[Avgprice]*10/100) FROM OITW T0 WHERE T0.[WhsCode]='Saudi' and T0.[ItemCode]=$[DLN1.Itemcode] and $[ODLN.Cardcode] IN ('C00013','C00014')

    Thanks

    Ajith

    Add comment
    10|10000 characters needed characters exceeded