Can Breadwinner Handle 4 Decimal Places?
3 min
background xero can handle up to 4 decimal places in the unit amount and unit price fields xero can also handle two decimal places in the percentage field (i e , 12 75%) ( more details from xero https //community xero com/business/discussion/51751/ ) xero rounds line totals to two decimal places tax is calculated at two decimal places and subtotals and totals are stored to two decimal places ( how xero rounds http //developer xero com/documentation/advanced docs/rounding in xero/ ) salesforce can handle up to 8 decimal places on opportunity products price field and price book field, but only if you file a case ( more details from salesforce https //help salesforce com/apex/htviewsolution?id=000005216\&language=en us ) this is further complicated in salesforce, which does not allow more than 2 decimal places in the quantity or percentage fields additionally, the amount field in the opportunity only allows 2 decimal places salesforce discounts are displayed to 2 decimal places, the same as xero breadwinner supports both two and four decimals on line items by default, we show up the four decimals on the detail page of line item creating invoices in xero with breadwinner if you are creating an invoice in xero via breadwinner, you can enter any number of decimal places in the fields however, xero only allows 4 decimal places, so the fifth decimal place onward will be dropped when we pass the invoice to xero, and for the percentage, xero will drop the third decimal place please note this is only for the line items quantity, price, and percent xero calculates the line item totals, as well as the subtotal, tax, and total, to 2 decimal places (this is beyond our control) therefore, breadwinner lets you enter full decimal places in your xero invoice line items invoices in salesforce breadwinner keeps a copy of all your xero 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 xero is saved in our fields, as xero only calculates 2 decimal places on subtotal and total (and related) fields of course, the 16 character limitation before the decimal place limits you 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!

