rounding up to .05 cents

(0) Share

Report

Posted on by Community Member

Has anyone come across this requirment before, or any suggestions on how it could be handled automatically.

User needs to round currency amounts up to the nearest 5 cents. So if the dollar amount is 199.94 - then in GP it becomes 199.95. If its 199.97, then it becomes 200.00.

This is genarally just a sales invoice issue. I could maybe modify the SOP Form to round up - but the amounts in GP would still be the actual amount and would lead to small writeoffs / write backs having to be posted for every transation when it is applied.

I.e. the invoice prints out for 199.95. The customer pays 199.95...but the invoice in GP is still for 199.94. Therefore a 1 cent write back required - which means posting a 1 cent debit document in GP. Would be better if there was some way to enter the invoice and have the document amount auto re-calc.

I suppose I could write a piece of code that takes the GP invoice amount, calculates the amount required to cause it to round up to the nearest 5 cents...and then write that amount back to the Misc field in the footer.....and distribute these amounts to a GL account code called 'Sales Rounding Amounts'...thinking out loud here.

Anyone got any other ideas?

*This post is locked for comments

I have the same question (0)

All responses (10)

Answers (0)

Rennecia Barran on at

Like (0)

Report

RE: rounding up to .05 cents

Hi Ian,

We have the same thing happening with our country but we only require rounding for cash invoices. If the customer remits payment with cheque or card, they pay the actual amount.

Have you found any other resolution for this beside scripting?

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Re: Re: Re: Re: Re: Re: rounding up to .05 cents

Hi Ian,

This exact situation is happening in Canada starting February 4, 2013. The penny is being eliminated so for cash sales we round to the nearest 5 cents. It would be nice to have a way to automatically round the sales invoices. Since this just applies to cash sales (credit card and debit transactions are exact value), my plan was to use the Misc. field. If you came up with something better, I am interested to know!

-Tracey

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Re: Re: Re: Re: Re: Re: rounding up to .05 cents

No, no monkeying around with any taxes. Same laws apply outside the US. My plan is to let the invoice subtotal, tax etc. calculate as per normal. Its just that the overall invoice total has to be rounded up to the nearest 5 cents. So, say the invoice ends up as 199.94. I will add a 1 cent to the Misc field (non taxable), this will increase the invoice to 199.95 - and so is rounded up to the nearest 5 cent. I can do this manually and its fine. My plan is to do this automatically through VB.

This is for a country where the value of the 'cent' is negligible and it is standard practice to round all amounts up to the nearest 5 'cent'. In fact the 1 and 2 cent pieces are not even in circulation any more.

Thanks for the input.

Was this reply helpful? Yes No
Richard Whaley 25,195 on at

Like (0)

Report

Re: Re: Re: Re: Re: rounding up to .05 cents

I don't know where you are located and what the laws are outside of the US but if you monkey with sales tax in the US you will incur an audit and penalties. You may have to refund over charges, yes even pennies, and eat under billings. You can round prices but you cannot round taxes.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Re: Re: Re: Re: rounding up to .05 cents

Hi Richard, yes you're right, the 'adjusting the report' option is out - we will get paid the rounded amount and it will leave small write off's to be done manually. However if I round up the item prices, I will in somecases still end up with an invoice total not rounded to the nearest 5 cent when sales tax is calculated. The best option is a VB script that inserts a value in the misc field to make the Invoice total rounded.

Best regards,

Was this reply helpful? Yes No
Richard Whaley 25,195 on at

Like (0)

Report

Re: Re: Re: rounding up to .05 cents

If you perform the rounding in the document print, the system will still have the un-rounded values and cause problems. Using the pricelist rounding options sets the rounded price in the db.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Re: Re: rounding up to .05 cents

Thanks Mariano. Its just the code on the invoice total I need to do. The item prices / vat etc are all fine - its just the invoice total that needs to be rounded. Might post again if having any issues with the VB code!!!

Regards, Ian.

Was this reply helpful? Yes No
Mariano Gomez 26,225 on at

Like (0)

Report

Re: rounding up to .05 cents

[quote user="Ian Stewart"]I suppose I could write a piece of code that takes the GP invoice amount, calculates the amount required to cause it to round up to the nearest 5 cents...and then write that amount back to the Misc field in the footer.....and distribute these amounts to a GL account code called 'Sales Rounding Amounts'...thinking out loud here.[/quote]
I second Victoria's approach. I believe you can take the price list and have it round to the nearest multiple of .05 based on your rounding requirements. However, if your invoice also calculates VAT, you may need some extra VBA code to round the invoice amount and distribute the extra cents to the rounding account you are proposing.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Re: Re: rounding up to .05 cents

Thanks for the input Victoria. Yes, probably the only way to handle it is use the misc field to balance it out.

Cheers.

Was this reply helpful? Yes No
Victoria Yudin 22,768 on at

Like (0)

Report

Re: rounding up to .05 cents

Ian,

I think the only thing that comes close to this out-of-the-box is the rounding on the price list setup (under Options)...but this would be on each line item, not for the entire invoice, and only for the calculated price methods.

If that's not an option, then using the Misc field how you're describing is probably what I would do, as well. We've done something similar in the past for small rounding differences on imported SOP transactions.

Was this reply helpful? Yes No