Skip to content
  • Categories
  • Recent
  • Tags
  • Popular
  • World
  • Users
  • Groups
Skins
  • Light
  • Cerulean
  • Cosmo
  • Flatly
  • Journal
  • Litera
  • Lumen
  • Lux
  • Materia
  • Minty
  • Morph
  • Pulse
  • Sandstone
  • Simplex
  • Sketchy
  • Spacelab
  • United
  • Yeti
  • Zephyr
  • Dark
  • Cyborg
  • Darkly
  • Quartz
  • Slate
  • Solar
  • Superhero
  • Vapor

  • Default (No Skin)
  • No Skin
Collapse
Code Project
  1. Home
  2. The Lounge
  3. Reading a quotation...

Reading a quotation...

Scheduled Pinned Locked Moved The Lounge
csharpjavascriptcloudcsslinq
38 Posts 19 Posters 0 Views 1 Watching
  • Oldest to Newest
  • Newest to Oldest
  • Most Votes
Reply
  • Reply as topic
Log in to reply
This topic has been deleted. Only users with topic management privileges can see it.
  • J Jacquers

    Correct to how many decimal places? ;) ;P

    Sander RosselS Offline
    Sander RosselS Offline
    Sander Rossel
    wrote on last edited by
    #9

    I've actually had a customer who wanted VAT on invoices calculated per product, which was completely irrelevant, instead of over the complete invoice. The problem is, you're going to round VAT to two decimals, because no one ever pays €0.001. So by adding up all the VATs for each product we got rounding errors (and those rounding errors added up!). If you calculated the VAT over the entire invoice (like EVERYBODY in that business does) it wouldn't add up. But for some reason they really wanted to have the VAT per product. We went as far as to round to 16 decimal places, but we still ended up with rounding errors :laugh: Ultimately, we actually went for "as correct as possible with x decimal places." In this case "correct" was of course VAT over the entire invoice because that was the only legal kind of VAT :laugh:

    Best, Sander sanderrossel.com Migrating Applications to the Cloud with Azure arrgh.js - Bringing LINQ to JavaScript Object-Oriented Programming in C# Succinctly

    J Richard DeemingR L N 4 Replies Last reply
    0
    • Sander RosselS Sander Rossel

      I've actually had a customer who wanted VAT on invoices calculated per product, which was completely irrelevant, instead of over the complete invoice. The problem is, you're going to round VAT to two decimals, because no one ever pays €0.001. So by adding up all the VATs for each product we got rounding errors (and those rounding errors added up!). If you calculated the VAT over the entire invoice (like EVERYBODY in that business does) it wouldn't add up. But for some reason they really wanted to have the VAT per product. We went as far as to round to 16 decimal places, but we still ended up with rounding errors :laugh: Ultimately, we actually went for "as correct as possible with x decimal places." In this case "correct" was of course VAT over the entire invoice because that was the only legal kind of VAT :laugh:

      Best, Sander sanderrossel.com Migrating Applications to the Cloud with Azure arrgh.js - Bringing LINQ to JavaScript Object-Oriented Programming in C# Succinctly

      J Offline
      J Offline
      Jacquers
      wrote on last edited by
      #10

      Those little bits can add up :) Here if a product is marked as 4.99 you'll pay 4.95 at the till / cashier, due to us no longer having 2c coins. AFAIK the rounding is only done on the total, but if you wanted to save a few cents you could pay for each product individually.

      F Sander RosselS J 3 Replies Last reply
      0
      • Sander RosselS Sander Rossel

        I've actually had a customer who wanted VAT on invoices calculated per product, which was completely irrelevant, instead of over the complete invoice. The problem is, you're going to round VAT to two decimals, because no one ever pays €0.001. So by adding up all the VATs for each product we got rounding errors (and those rounding errors added up!). If you calculated the VAT over the entire invoice (like EVERYBODY in that business does) it wouldn't add up. But for some reason they really wanted to have the VAT per product. We went as far as to round to 16 decimal places, but we still ended up with rounding errors :laugh: Ultimately, we actually went for "as correct as possible with x decimal places." In this case "correct" was of course VAT over the entire invoice because that was the only legal kind of VAT :laugh:

        Best, Sander sanderrossel.com Migrating Applications to the Cloud with Azure arrgh.js - Bringing LINQ to JavaScript Object-Oriented Programming in C# Succinctly

        Richard DeemingR Offline
        Richard DeemingR Offline
        Richard Deeming
        wrote on last edited by
        #11

        At least in the UK, it's perfectly fine to do it either way: 17.5 Calculation of VAT on invoices - rounding of amounts[^] Calculating per line makes it easier to deal with invoices where different products attract different VAT rates. And if you calculate and round per line, you sometimes end up paying slightly less VAT. :)


        "These people looked deep within my soul and assigned me a number based on the order in which I joined." - Homer

        "These people looked deep within my soul and assigned me a number based on the order in which I joined" - Homer

        G 1 Reply Last reply
        0
        • Sander RosselS Sander Rossel

          The quotation mentions rebuilding an Excel sheet to some web application. "This process must be as simple and correct as possible." Not "as correct as possible", just correct. If it's any less correct than "correct" it's not correct :laugh: I wonder, if they mention correctness explicitly at this point, does that mean all other points are assumed to be incorrect by default? :~

          Best, Sander sanderrossel.com Migrating Applications to the Cloud with Azure arrgh.js - Bringing LINQ to JavaScript Object-Oriented Programming in C# Succinctly

          Z Offline
          Z Offline
          ZurdoDev
          wrote on last edited by
          #12

          Sander Rossel wrote:

          If it's any less correct than "correct" it's not correct

          That is the most true statement I've ever read.

          Social Media - A platform that makes it easier for the crazies to find each other. Everyone is born right handed. Only the strongest overcome it. Fight for left-handed rights and hand equality.

          S 1 Reply Last reply
          0
          • Richard DeemingR Richard Deeming

            At least in the UK, it's perfectly fine to do it either way: 17.5 Calculation of VAT on invoices - rounding of amounts[^] Calculating per line makes it easier to deal with invoices where different products attract different VAT rates. And if you calculate and round per line, you sometimes end up paying slightly less VAT. :)


            "These people looked deep within my soul and assigned me a number based on the order in which I joined." - Homer

            G Offline
            G Offline
            GuyThiebaut
            wrote on last edited by
            #13

            So in practice you could get that new car invoice to be itemised by the atom and because HMRC allows you to round down there would be no VAT to pay :-D

            “That which can be asserted without evidence, can be dismissed without evidence.”

            ― Christopher Hitchens

            OriginalGriffO D 2 Replies Last reply
            0
            • Sander RosselS Sander Rossel

              What about "and correct if possible"? ;p Or "and correct if you pay extra for our special 'correctness module'" :cool:

              Best, Sander sanderrossel.com Migrating Applications to the Cloud with Azure arrgh.js - Bringing LINQ to JavaScript Object-Oriented Programming in C# Succinctly

              OriginalGriffO Offline
              OriginalGriffO Offline
              OriginalGriff
              wrote on last edited by
              #14

              You're starting to sound like EA Games ... DownLoadableCorrectness, anyone?

              "I have no idea what I did, but I'm taking full credit for it." - ThisOldTony AntiTwitter: @DalekDave is now a follower!

              "I have no idea what I did, but I'm taking full credit for it." - ThisOldTony
              "Common sense is so rare these days, it should be classified as a super power" - Random T-shirt

              Sander RosselS 1 Reply Last reply
              0
              • G GuyThiebaut

                So in practice you could get that new car invoice to be itemised by the atom and because HMRC allows you to round down there would be no VAT to pay :-D

                “That which can be asserted without evidence, can be dismissed without evidence.”

                ― Christopher Hitchens

                OriginalGriffO Offline
                OriginalGriffO Offline
                OriginalGriff
                wrote on last edited by
                #15

                I have a small feeling HMRC may see it slightly differently ... :~

                "I have no idea what I did, but I'm taking full credit for it." - ThisOldTony AntiTwitter: @DalekDave is now a follower!

                "I have no idea what I did, but I'm taking full credit for it." - ThisOldTony
                "Common sense is so rare these days, it should be classified as a super power" - Random T-shirt

                1 Reply Last reply
                0
                • Sander RosselS Sander Rossel

                  The quotation mentions rebuilding an Excel sheet to some web application. "This process must be as simple and correct as possible." Not "as correct as possible", just correct. If it's any less correct than "correct" it's not correct :laugh: I wonder, if they mention correctness explicitly at this point, does that mean all other points are assumed to be incorrect by default? :~

                  Best, Sander sanderrossel.com Migrating Applications to the Cloud with Azure arrgh.js - Bringing LINQ to JavaScript Object-Oriented Programming in C# Succinctly

                  J Offline
                  J Offline
                  Jacquers
                  wrote on last edited by
                  #16

                  Search results I saw on a page recently: About 18 games found :laugh:

                  K 1 Reply Last reply
                  0
                  • Sander RosselS Sander Rossel

                    The quotation mentions rebuilding an Excel sheet to some web application. "This process must be as simple and correct as possible." Not "as correct as possible", just correct. If it's any less correct than "correct" it's not correct :laugh: I wonder, if they mention correctness explicitly at this point, does that mean all other points are assumed to be incorrect by default? :~

                    Best, Sander sanderrossel.com Migrating Applications to the Cloud with Azure arrgh.js - Bringing LINQ to JavaScript Object-Oriented Programming in C# Succinctly

                    L Offline
                    L Offline
                    Lost User
                    wrote on last edited by
                    #17

                    Excel does a lot of magic; read theoldnewthing if you want details that you never need. Fun fact; Excel has better VB than the other MS products.

                    Bastard Programmer from Hell :suss: If you can't read my code, try converting it here[^] "If you just follow the bacon Eddy, wherever it leads you, then you won't have to think about politics." -- Some Bell.

                    K 1 Reply Last reply
                    0
                    • G GuyThiebaut

                      So in practice you could get that new car invoice to be itemised by the atom and because HMRC allows you to round down there would be no VAT to pay :-D

                      “That which can be asserted without evidence, can be dismissed without evidence.”

                      ― Christopher Hitchens

                      D Offline
                      D Offline
                      Daniel Pfeffer
                      wrote on last edited by
                      #18

                      GuyThiebaut wrote:

                      itemised by the atom

                      That would be a long invoice. :)

                      Freedom is the freedom to say that two plus two make four. If that is granted, all else follows. -- 6079 Smith W.

                      1 Reply Last reply
                      0
                      • J Jacquers

                        Those little bits can add up :) Here if a product is marked as 4.99 you'll pay 4.95 at the till / cashier, due to us no longer having 2c coins. AFAIK the rounding is only done on the total, but if you wanted to save a few cents you could pay for each product individually.

                        F Offline
                        F Offline
                        fd9750
                        wrote on last edited by
                        #19

                        Not around here as mathematically correct rounding is applied here. 4,99 and 4,98 will result in 5,00. 4,96 and 4,97 will become 4,95. Unless you pay with your debet/credit card then it remains whatever it is.

                        1 Reply Last reply
                        0
                        • J Jacquers

                          Those little bits can add up :) Here if a product is marked as 4.99 you'll pay 4.95 at the till / cashier, due to us no longer having 2c coins. AFAIK the rounding is only done on the total, but if you wanted to save a few cents you could pay for each product individually.

                          Sander RosselS Offline
                          Sander RosselS Offline
                          Sander Rossel
                          wrote on last edited by
                          #20

                          Over here, in a store (for example, supermarket), VAT is included in the product price. So 500 gr. (pre-packaged) grapes costs €2.19 incl. VAT. If you buy two packs, you pay €4.38. If you pay cash everything is rounded to 5 cents, so €4.38 would become €4.40, but €4.37 would be €4.35. I can't remember the last time I paid cash at a store :D This particular company sold meat (wholesale), so a customer would order five ribs, but they would pay per kg. The customer gets an estimated price, based on what my customer sent them, then that customer would weigh everything again, and that weight was invoiced. Naturally, you don't know the VAT until the actual invoice. And since the VAT isn't included in the individual prices, like in a supermarket, you really can't do anything other than calculate VAT over the entire invoice :D It's how I invoice too, and pretty much every business in the Netherlands.

                          Best, Sander sanderrossel.com Migrating Applications to the Cloud with Azure arrgh.js - Bringing LINQ to JavaScript Object-Oriented Programming in C# Succinctly

                          1 Reply Last reply
                          0
                          • OriginalGriffO OriginalGriff

                            You're starting to sound like EA Games ... DownLoadableCorrectness, anyone?

                            "I have no idea what I did, but I'm taking full credit for it." - ThisOldTony AntiTwitter: @DalekDave is now a follower!

                            Sander RosselS Offline
                            Sander RosselS Offline
                            Sander Rossel
                            wrote on last edited by
                            #21

                            EA, it's in the game (provided you bought all DLCs)! :D

                            Best, Sander sanderrossel.com Migrating Applications to the Cloud with Azure arrgh.js - Bringing LINQ to JavaScript Object-Oriented Programming in C# Succinctly

                            1 Reply Last reply
                            0
                            • Z ZurdoDev

                              Sander Rossel wrote:

                              If it's any less correct than "correct" it's not correct

                              That is the most true statement I've ever read.

                              Social Media - A platform that makes it easier for the crazies to find each other. Everyone is born right handed. Only the strongest overcome it. Fight for left-handed rights and hand equality.

                              S Offline
                              S Offline
                              Slacker007
                              wrote on last edited by
                              #22

                              18 Reasons One is Executed for Witchcraft during the 'Burning Times'[^] :laugh: :laugh: Just realized you are a lefty. Keeping an eye on this one.

                              Z 1 Reply Last reply
                              0
                              • Sander RosselS Sander Rossel

                                I've actually had a customer who wanted VAT on invoices calculated per product, which was completely irrelevant, instead of over the complete invoice. The problem is, you're going to round VAT to two decimals, because no one ever pays €0.001. So by adding up all the VATs for each product we got rounding errors (and those rounding errors added up!). If you calculated the VAT over the entire invoice (like EVERYBODY in that business does) it wouldn't add up. But for some reason they really wanted to have the VAT per product. We went as far as to round to 16 decimal places, but we still ended up with rounding errors :laugh: Ultimately, we actually went for "as correct as possible with x decimal places." In this case "correct" was of course VAT over the entire invoice because that was the only legal kind of VAT :laugh:

                                Best, Sander sanderrossel.com Migrating Applications to the Cloud with Azure arrgh.js - Bringing LINQ to JavaScript Object-Oriented Programming in C# Succinctly

                                L Offline
                                L Offline
                                Lost User
                                wrote on last edited by
                                #23

                                There is a thing called "Summenerhaltendes Runden" ;)

                                It does not solve my Problem, but it answers my question

                                Sander RosselS 1 Reply Last reply
                                0
                                • J Jacquers

                                  Search results I saw on a page recently: About 18 games found :laugh:

                                  K Offline
                                  K Offline
                                  kalberts
                                  wrote on last edited by
                                  #24

                                  Our local newspaper reported that "approximately five candidates" had failed this public exam. (The same local newspaper also once told about this guy who had one a huge prize in an English lottery: Until this, he had been selling fish and ships at a London street.)

                                  1 Reply Last reply
                                  0
                                  • S Slacker007

                                    18 Reasons One is Executed for Witchcraft during the 'Burning Times'[^] :laugh: :laugh: Just realized you are a lefty. Keeping an eye on this one.

                                    Z Offline
                                    Z Offline
                                    ZurdoDev
                                    wrote on last edited by
                                    #25

                                    Slacker007 wrote:

                                    Just realized you are a lefty. Keeping an eye on this one.

                                    Thanks. :laugh: :thumbsup:

                                    Social Media - A platform that makes it easier for the crazies to find each other. Everyone is born right handed. Only the strongest overcome it. Fight for left-handed rights and hand equality.

                                    1 Reply Last reply
                                    0
                                    • Sander RosselS Sander Rossel

                                      The quotation mentions rebuilding an Excel sheet to some web application. "This process must be as simple and correct as possible." Not "as correct as possible", just correct. If it's any less correct than "correct" it's not correct :laugh: I wonder, if they mention correctness explicitly at this point, does that mean all other points are assumed to be incorrect by default? :~

                                      Best, Sander sanderrossel.com Migrating Applications to the Cloud with Azure arrgh.js - Bringing LINQ to JavaScript Object-Oriented Programming in C# Succinctly

                                      H Offline
                                      H Offline
                                      honey the codewitch
                                      wrote on last edited by
                                      #26

                                      I wonder if by correct they mean no hacks. In some cases hacks are acceptable if undesirable. The real world (deadlines and budget) often intervenes to undercut design, leading to kludges, and also maintenance can lead to kludgy code over time. Maybe by correct they mean with as little of this as possible. If I'm reading it charitably this is how I would interpret it.

                                      Real programmers use butterflies

                                      Sander RosselS 1 Reply Last reply
                                      0
                                      • Sander RosselS Sander Rossel

                                        What about "and correct if possible"? ;p Or "and correct if you pay extra for our special 'correctness module'" :cool:

                                        Best, Sander sanderrossel.com Migrating Applications to the Cloud with Azure arrgh.js - Bringing LINQ to JavaScript Object-Oriented Programming in C# Succinctly

                                        D Offline
                                        D Offline
                                        David ONeil
                                        wrote on last edited by
                                        #27

                                        Sander Rossel wrote:

                                        our special 'correctness module'

                                        For those times you must ensure you are correctly correct!

                                        The forgotten roots of science | C++ Programming | DWinLib

                                        1 Reply Last reply
                                        0
                                        • L Lost User

                                          Excel does a lot of magic; read theoldnewthing if you want details that you never need. Fun fact; Excel has better VB than the other MS products.

                                          Bastard Programmer from Hell :suss: If you can't read my code, try converting it here[^] "If you just follow the bacon Eddy, wherever it leads you, then you won't have to think about politics." -- Some Bell.

                                          K Offline
                                          K Offline
                                          kalberts
                                          wrote on last edited by
                                          #28

                                          Read The Old New Thing in any case! Some posts are really entertaining (especially when he tells about crazy legacy issues), and some of it is really useful! (I made an adjustment as late as last night, based on what I read in one old entry about file system tunneling. C++ / Win32 people will find more useful stuff there, there is less of C#/dotNet. But a lot is also general, about Windows in all forms.

                                          1 Reply Last reply
                                          0
                                          Reply
                                          • Reply as topic
                                          Log in to reply
                                          • Oldest to Newest
                                          • Newest to Oldest
                                          • Most Votes


                                          • Login

                                          • Don't have an account? Register

                                          • Login or register to search.
                                          • First post
                                            Last post
                                          0
                                          • Categories
                                          • Recent
                                          • Tags
                                          • Popular
                                          • World
                                          • Users
                                          • Groups