Bug 18736: (QA follow-up) Change to signed, add large int test

[koha.git] / C4 / Acquisition.pm

diff --git a/C4/Acquisition.pm b/C4/Acquisition.pm
index 2123ea3..dfea465 100644 (file)
--- a/C4/Acquisition.pm
+++ b/C4/Acquisition.pm
@@ -2013,7 +2013,7 @@ sub get_rounding_sql {
     my ( $round_string ) = @_;
     my $rounding_pref = C4::Context->preference('OrderPriceRounding') // q{};
     if ( $rounding_pref eq "nearest_cent"  ) {
-        return "CAST($round_string*100 AS UNSIGNED)/100";
+        return "CAST($round_string*100 AS SIGNED)/100";
     }
     return $round_string;
 }