I have seen that if you put the sentence between parenthesis this is
executed well, but this did not happen to me with version 4.6, thus
the sentence:

SELECT (sum(coalesce(Precio, 0) * coalesce(Cantidad, 1) *
(100-coalesce(Descuento, 0))/100)*1.16) as TotalAlbaran
FROM LinAlbaranes LIN
WHERE AnoAlbaran=2007 and SerieAlbaran=0 and idAlbaran=36


is executed correctly