How to handle precision when dealing with currency in MySQL and PHP -

-

i have 3 fields in invoice table:

subtotal    decimal(12,4) tax_amount  decimal(12,4) total       decimal(12,4)

i have run problem rounding. there's invoice following values. addition adds up, when displaying invoice data , generating pdf invoice, displayed data doesn't add up.

           stored value     displayed (rounded)                                 value subtotal    165.1610         165.16  tax_amount  24.7742          24.77 total       189.9352         189.94

the stored values add up. total column calculated adding subtotal , tax_amount values in php. rounding done correctly 165.16 + 24.77 = 189.93 , not 189.94.

how can handle these situations? not case.

round stored values nearest penny. when you're calculating total or subtotal using php, sum rounded values.

if you're going displaying rounded aggregates way, it's best practice calculate exact same way avoid confusion.

you could display aggregate items not being rounded, , round final sum display purposes. may play more nicely in long run if you're storing fractional pennies in database.

another option having rounding charge on invoice account discrepancy, though may confuse people.

that being said, programmatically speaking, it's best avoid fractional pennies whenever possible.

whatever choose do, consistent!


Comments

Post a Comment

Popular posts from this blog

Django REST Framework perform_create: You cannot call `.save()` after accessing `serializer.data` -

-
i have following viewset: class artistprofileviewset(viewsets.modelviewset): queryset = artistprofile.objects.all() serializer_class = artistprofileserializer def perform_create(self, serializer): if serializer.is_valid(): serializer.save() with following serializers: class simpleartisttrackserializer(serializers.hyperlinkedmodelserializer): class meta: model = artisttrack fields = (...my fields...) class artistprofileserializer(serializers.hyperlinkedmodelserializer): owners = userserializer(many=true, required=false) tracks = simpleartisttrackserializer(many=true, required=false) class meta: model = artistprofile fields = (...my fields...) i getting following error: assertionerror: cannot call `.save()` after accessing `serializer.data`.if need access data before committing database inspect 'serializer.validated_data' instead. i don't see editing serializer.data object. th...
Read more

Why does Go error when trying to marshal this JSON? -

-
i'm trying rather simple example of trying decode json file structs using golang. however, when attempting error that json: cannot unmarshal object go value of type []main.track which don't understand. here's code in question, , json can found here . package main import ( "encoding/json" "fmt" "net/http" "os" ) // tracks group of track types type tracks struct { tracks []track } // track represents singular track type track struct { name string url string artist artist } // artist represents single artist type artist struct { name string mbid string url string } func main() { url := "http://ws.audioscrobbler.com/2.0/?method=geo.gettoptracks&api_key=c1572082105bd40d247836b5c1819623&format=json&country=netherlands" response, err := http.get(url) if err != nil { fmt.printf("%s\n", err) os.exit(1) } de...
Read more