Decimal Places in Transactions
3 min
background quickbooks online can handle 7 decimal places in the line quantity and unit price fields and 2 decimal places in the line amount field quickbooks online can also handle two decimal places in the percentage field (i e , 12 75%) quickbooks online rounds line totals to 2 decimal places tax is calculated at two decimal places subtotals and totals are stored to 2 decimal places ( how quickbooks online rounds https //developer intuit com/docs/00 quickbooks online/2 build/60 tutorials/0060 manage sales tax for non us locales#/rounding rules for tax calculation ) salesforce can handle up to 8 decimal places on the opportunity products price field and the price book field, but only if you file a case this is further complicated in salesforce, where only 2 decimal places are permitted in the quantity or percentage fields additionally, the amount field in the opportunity only allows 2 decimal places creating invoices in quickbooks online with breadwinner if you are creating an invoice in quickbooks online via breadwinner, you can enter any number of decimal places in the fields however, quickbooks online supports only 7 decimal places, so the eighth decimal place onward will be dropped when we pass the invoice to quickbooks online, and for percentages, quickbooks online will drop the third decimal place please note this is only for the line items quantity, price, and percent quickbooks online calculates line item totals, as well as the subtotal, tax, and total, to 2 decimal places (beyond our control) as a result, breadwinner allows you to enter the full decimal places into your quickbooks online invoice line items invoices in salesforce breadwinner keeps a copy of all your quickbooks online invoices in salesforce these fields are 16,2 fields, meaning that you can have 16 numbers before the decimal place, and 2 numbers after the decimal place this means that all data from quickbooks online is saved in our fields, since quickbooks online only displays 2 decimal places for subtotal and total (and related) fields of course, the 16 character limitation before the decimal place limits the user to invoices with a total of just under 10 quadrillion dollars if you are indeed billing in the quadrillions, we have a special pricing plan for you contact our billing department!
