Skip to Content

How to calculate Gross Profit % on Sales Quotation Rows

Jan 30, 2017 at 01:39 PM


avatar image
Former Member

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?

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

0 Answers