Skip to Content
avatar image
Former Member

How to calculate Gross Profit % on Sales Quotation Rows

I am on SAP Business One for Hana 9.2 PL4. We would like to calculate the GP as percentage on Sales Quotation rows. We have a FMS at row level linked to a UDF. The FMS query is ($[$38.123.2]/$[$38.21.2]), however it gives the following error

1). [SAP AG][LIBODBCHDB32 DLL][HDBODBC32] Syntax error or access violation;257 sql syntax error: incorrect syntax near "KES 241,950.00": line 1 col 2 '' (SWEI) (at pos 2)

How to we get the query to exclude the currency symbol in the calculation?

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

0 Answers