Stop rounding Qty field

I can (and really need to) use the Qty field to enter quantities such as 0.035 (for 3.5% commission rate). I can enter them and save them. BUT if I navigate back to the invoice the value gets rounded to two decimals.

You can look at invoice 2914056 in my acount where I entered 0.0322 initially ans tested with 0.035.

Can you ensure this get fixed please?

I’m afraid this is not a bug but a feature.

We currently round all quantities to two decimal places and this is how they’re stored internally, as they need to be reduced to pounds and pence for accounting. Any longer decimals would need to be expressed in the invoice item description.

I understand 100% the need to reduced to pounds and pence for accounting. Quantities could have more that two decimals without affecting this. Currently it is possible to have more than two decimals and all works well as long as you do not re-open/refresh the page. There are a few community posts from users explaining how to enter decimal quantities by tricking the system (cut and paste instead of typing). There is clearly a need to enter these more-than-two decimals and you software already does 99% of the job. It just needs to stop rounding quantities.

Could/would you consider this pretty please?

Yes I understand your point and as far as rounding goes, as long as the line total is rounded to pounds and pence this shouldn’t be an issue, regardless of the QTY column.

I think regarding the other posts on the forum all that’s happening here is the Javascript is being tricked, when it goes to the server it will get rounded again there before it goes into the database.

The key thing is how the data is stored in the database, if it’s going in as a short decimal it will be a massive job to change. The testing alone could take a week as the fields are read in 100s of places in the application.

I’ll definitely ask someone to take a deeper look but I can’t promise anything here I’m afraid.

Thanks for your reply and tiem to understand my point.

I am planning to use your api to generate invoices automatically but without this I will not be able to use my commission rates accurately and therefore not able to use the automation.

I look forward to hearing back from you whilst I keep my fingers crossed!

If you’re planning to use the API then why not just do the multiplication in your own code when you are working out what value to put in the “commission” line on the invoice you’re building, and give the line a “quantity” of 1? That way you can handle the rounding as you see fit rather than leaving it to QuickFile to decide.

Because I need to show the calculation to my clients. Show them the sales figure (they can check on their own systems and records) and show them the commission rate agreed.

I guess the simplest workaround would be to include that in the description field, e.g. “Commission on £x sales @ 3.2%”

1 Like

What you are saying of course makes sense but I am not really asking for help to find a work around. I moved away from Quickbooks to streamline my accounting and this is proving a tough hurdle for me. I currently do not use the API and enter the data manually. Having to calculate the amounts for each client manually is both time consuming and a source of error. The particular “feature” of greater number of decimals is one I miss from Quickbooks… (did I actually say I missed Quickbooks!? I must be ill…!))
I am still hoping that decimals can be changed to allow even more flexibility for this already great system.

I’ve had a chat with our database admin and it seems that this will not be too difficult to implement. We could therefore bump the rounding up to 4 decimal places e.g. 0.0322.

Do you envisage needing more than 4 decimal places at this stage?

1 Like

Four decimals would be perfect!!

I’ve logged this on our short term planner so it should get looked at in the next 1-2 weeks. I will update when I know more.

That is wonderful - thanks!

I can now confirm that this update is live.

You are now able to enter quantities for items and tasks up to 4 decimal places.

I hope this solves the original problem you mentioned.

1 Like

That is wonderful; thank you very much!!

1 Like

This topic was automatically closed 4 days after the last reply. New replies are no longer allowed.