Home › Forums › Users › General User's Discussion ›

Impending GST changes

Submitted by Geoffvet on Fri, 25/06/2010 - 19:21
in

Hi Guys,

Sadly the powers that be have decided to up the GST rate on our side of the ditch come the 1st of October.

I have tried replacing the GST lookup (on my testout computer) but in order for a price to be updated to the new
rate I have to edit each product unit price, change it, ok it, then change it back before it updates the GST to 15 %.

I am hoping there is an easier way as with fixed and unit prices thats about 3000 changes to make.

Fingers crossed,

Geoff

‹ Check-in printing of documents Post vs finalise ›

Comment viewing options

Select your preferred way to display the comments and click "Save settings" to activate your changes.

Re: Impending GST changes

Submitted by Tony De Keizer (not verified) on Sat, 26/06/2010 - 09:00.
Hi Geoff,Although there is no method in the current application to make these changes we can assist in supplying a sql query that will do this for you. Not difficult.From a design perspective the current system of storing the inc tax price in product prices  rather than storing the ex tax price and calculating the inc tax price based on the current tax setting needs to change.  CheersTony On Fri, Jun 25, 2010 at 7:21 PM, <geoffsim@yahoo.com.au> wrote:
Hi Guys, Sadly the powers that be have decided to up the GST rate on our side of the ditch come the 1st of October. I have tried replacing the GST lookup (on my testout computer) but in order for a price to be updated to the new rate I have to edit each product unit price, change it, ok it, then change it back before it updates the GST to 15 %.

I am hoping there is an easier way as with fixed and unit prices thats about 3000 changes to make. Fingers crossed, Geoff _______________________________________________ OpenVPMS User Mailing List users@lists.openvpms.org To unsubscribe or change your subscription visit: //lists.openvpms.org/listinfo/users" target="_blank">http://lists.openvpms.org/listinfo/users Posts from this mailing list can be viewed online and replied to in the OpenVPMS User's forum- //tinyurl.com/openvfu" target="_blank">http://tinyurl.com/openvfu

Re: Impending GST changes

Submitted by Geoffvet on Wed, 30/06/2010 - 08:37.

Hi Tony,

That will be good if you can sort out an sql query to do the job.

Much thanks

Geoff

Impending GST changes

Submitted by tony on Wed, 30/06/2010 - 13:26.

Hi Geoff,

I assume that all product prices are affected by the tax change (unit and fixed) ?

I also assume we can do a standard arithmetic operation to change price i.e  newprice =  oldprice * 1.175/1.15  (if going from 15% tax to 17.5% tax) ?

What rounding would be required i.e 2 decimal places ?

Cheers

Tony

Impending GST changes

Submitted by Geoffvet on Wed, 30/06/2010 - 14:49.

Hi Tony,

Yes both unit and fixed prices.  In our case going from 12.5% to 15 %. So newprice = oldprice*1.15/1.125. 

Two decimal places would be fine.

So I assume running the query will convert all existing prices to 15 % added GST and then changing the GST

rate itself will sort any future prices automatically.

Much Thanks

Geoff

 

 

 

 

Impending GST changes

Submitted by tony on Thu, 01/07/2010 - 08:30.

Hi Geoff,

 I think the following sql will do what you require. This only updates active prices so any historical prices remain unchanged. 

update product_prices set price = round(price*1.15/1.125,2) where active = 1;

Of course check thoroughly before running on production database. :-)

Cheers

Tony

Syndicate content