Print

Please login or register.
1 Hour 1 Day 1 Week 1 Month Forever
Login with username, password and session length

[TheBoy]

I have to write a load of sql scripts for my brother's shop to reprice some of his stock due to the vat cut.

Utterly pointless  , and i dont think the pillock realises for many that its too much work.

[Andy B]

.....
Utterly pointless  , and i dont think the pillock realises for many that its too much work.

Your brother or Mr Darling?  :-/  

[TheBoy]

.....
Utterly pointless  , and i dont think the pillock realises for many that its too much work.

Your brother or Mr Darling?  :-/  

in this case, eyebrow boy.

my brother has a shitload to do relabelling everything (and jewellery labels ain't cheap, nor is the ribbon), so I'll deal with the tech side.

[cem_devecioglu]

I have to write a load of sql scripts for my brother's shop to reprice some of his stock due to the vat cut.

Utterly pointless  , and i dont think the pillock realises for many that its too much work.

 

[cem_devecioglu]

double check the floating point operations as some data types like decimal sometimes make problem if you dont cast

[Martin_1962]

I take it you haven't seen Vince Cable or Ken Clarke calling him incompetent without actually saying it out right

[TheBoy]

double check the floating point operations as some data types like decimal sometimes make problem if you dont cast

all his money columns are sql type Currency, so guess should be OK?

[Martin_1962]

Our case - VAT at invoicing, so on Monday morning tell them to look in VAT setup screen

[TheBoy]

Our case - VAT at invoicing, so on Monday morning tell them to look in VAT setup screen

yeah, the system i wrote my brother has that, but as he sells to consumers, not trade, things aren't so simple. for consumer purchases, £7999 sounds ok, £7827.82 isn't quite right...

Many of his manufacturing suppliers, for example Tag, Omega etc, do not allow their retailers to alter from RRP, and they are still aiming for either no reduction or still a '99' ending price, so most of his watches will have to be manually done

[Martin_1962]

Our case - VAT at invoicing, so on Monday morning tell them to look in VAT setup screen

yeah, the system i wrote my brother has that, but as he sells to consumers, not trade, things aren't so simple. for consumer purchases, £7999 sounds ok, £7827.82 isn't quite right...

Many of his manufacturing suppliers, for example Tag, Omega etc, do not allow their retailers to alter from RRP, and they are still aiming for either no reduction or still a '99' ending price, so most of his watches will have to be manually done

He is Roger Budden AICMFP

[cem_devecioglu]

double check the floating point operations as some data types like decimal sometimes make problem if you dont cast

all his money columns are sql type Currency, so guess should be OK?

yep..anyway currency digits are narrow wont make problem..

[Kevin Wood]

Many of his manufacturing suppliers, for example Tag, Omega etc, do not allow their retailers to alter from RRP, and they are still aiming for either no reduction or still a '99' ending price, so most of his watches will have to be manually done

Don't suppose he services Breitlings, does he? Mine's stopped auto-winding and it feels like something's rattling around inside.

Vaseline at the ready...

Kevin

[amigov6]

A small business owner (who are most at risk ) was on the radio today saying that given the vat cut he now has to sell last months stock at a loss.
   I would'nt be too happy either!

[Vamps]

I don't see the point of a 2.0% cut, it will make little difference to the average daily purchases, and if you were going to buy a big tv or car then you would have done so anyway 2.5% reduction did not make you change your mind.

[Entwood]

I agree that the reduction will probably not make anyone spend more ... but it should get me £300 off the new pikey wagon when I collect and pay for it next week ..     It was ordered a month or so ago, so comes under "planned expenditure" .. nowt to do with eyebrows so called "incentives"