Question Status

Unanswered
Ian Stewart asked a question on 23 Sep 2010 7:26 AM

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?

 

 

Ian Stewart MVP - International support for Dynamics GP. Local knowledge, local timelines, local GP talent. Genesys Financial Systems (Europe) Microsoft Gold Certified Partner http://dynamicsgp.wordpress.com/

Reply
Victoria Yudin responded on 23 Sep 2010 2:01 PM

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.

Reply
Ian Stewart responded on 24 Sep 2010 1:29 AM

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

Cheers.

Ian Stewart MVP - International support for Dynamics GP. Local knowledge, local timelines, local GP talent. Genesys Financial Systems (Europe) Microsoft Gold Certified Partner http://dynamicsgp.wordpress.com/

Reply
Mariano Gomez responded on 26 Sep 2010 1:39 PM

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.

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.

Best regards,

MG.-
Mariano Gomez, MIS, MVP, MCP, PMP
IntellPartners, LLC
Blog: http://dynamicsgpblogster.blogspot.com

Reply
Ian Stewart responded on 27 Sep 2010 9:04 AM

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.

Ian Stewart MVP - International support for Dynamics GP. Local knowledge, local timelines, local GP talent. Genesys Financial Systems (Europe) Microsoft Gold Certified Partner http://dynamicsgp.wordpress.com/

Reply
Richard L. Whaley responded on 27 Sep 2010 1:46 PM

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.

Richard L. Whaley Author, Publisher, Consultant

http://www.AccoladePublications.com

Enhancing your Dynamics Knowledge!

Reply
Ian Stewart responded on 28 Sep 2010 2:16 AM

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,

Ian Stewart MVP - International support for Dynamics GP. Local knowledge, local timelines, local GP talent. Genesys Financial Systems (Europe) Microsoft Gold Certified Partner http://dynamicsgp.wordpress.com/

Reply
Richard L. Whaley responded on 28 Sep 2010 4:36 AM

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.

Richard L. Whaley Author, Publisher, Consultant

http://www.AccoladePublications.com

Enhancing your Dynamics Knowledge!

Reply
Ian Stewart responded on 28 Sep 2010 5:47 AM

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.

Ian Stewart MVP - International support for Dynamics GP. Local knowledge, local timelines, local GP talent. Genesys Financial Systems (Europe) Microsoft Gold Certified Partner http://dynamicsgp.wordpress.com/

Reply
Tracey Wright responded on 21 Jan 2013 11:04 AM

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

Reply