|
View unanswered posts | View active topics
It is currently Wed Jun 19, 2013 7:36 pm
Due to enormous amounts of spam, the forum has been set to read-only mode.
|
Page 1 of 1
|
[ 10 posts ] |
|
| Author |
Message |
|
LeGhe
Joined: Tue May 18, 2010 2:02 pm
Posts: 26
|
 French VAT modification
Hi,
Since April, 1st, all the prices for french books increased.
Is it a way to make a GENERAL update of book's prices ?
|
| Fri Apr 27, 2012 2:50 pm |
|
|
|
FredrikN
Site Admin
Joined: Fri Nov 22, 2002 3:52 pm
Posts: 13748
|
Re: French VAT modification
You could try Tools=>Adjust Value. Backup your database first!
_________________
Fredrik Nordbakke
www.fnprg.com
|
| Mon Apr 30, 2012 3:44 pm |
|
|
|
LeGhe
Joined: Tue May 18, 2010 2:02 pm
Posts: 26
|
Re: French VAT modification
No matter, nothing changes... Any other idea or patch ?
|
| Wed May 30, 2012 4:54 pm |
|
|
|
kevinrailway
Joined: Sat May 06, 2006 2:02 am
Posts: 87
Location: Melbourne, Australia
|
Re: French VAT modification
Book > Set Field Value > Appraisal? I guess you would need to do a search and only select the relevant books, i.e. the ones for sale & Currency (French)? Or else Search > Replace Select your field. Not sure if BookCAT does formulas, as in multiply existing number field by 1.1 to give a 10% increase. I haven't tried any of these, but just ideas. Definitely do a back up, or you'll be toast!!!! Search & Replace is very DANGEROUS. Kevin Martin
|
| Wed May 30, 2012 11:33 pm |
|
|
|
FredrikN
Site Admin
Joined: Fri Nov 22, 2002 3:52 pm
Posts: 13748
|
Re: French VAT modification
Are you sure you are updating the correct field? What is the old and the new VAT rate?
_________________
Fredrik Nordbakke
www.fnprg.com
|
| Thu May 31, 2012 9:04 am |
|
|
|
LeGhe
Joined: Tue May 18, 2010 2:02 pm
Posts: 26
|
Re: French VAT modification
Old one : 5.5%, new one : 7%
|
| Thu May 31, 2012 9:10 am |
|
|
|
LeGhe
Joined: Tue May 18, 2010 2:02 pm
Posts: 26
|
Re: French VAT modification
But some editors have increased more than 1.5% their book's prices, and others don't. It's a problem. Can I open a new database, paste all my ISBN (10000...), search only for prices, and merge (by import ?) with my actual database ?
|
| Thu May 31, 2012 9:20 am |
|
|
|
FredrikN
Site Admin
Joined: Fri Nov 22, 2002 3:52 pm
Posts: 13748
|
Re: French VAT modification
Yes, that is a problem. But if the VAT rate increases from 5.5% to 7%, the actual price increases by 1.4218% If you want update the Selling Price field (?), choose Tools=>Adjust Value=>Selling Price, and enter "1.4218" then click OK. No, this is not possible.
_________________
Fredrik Nordbakke
www.fnprg.com
|
| Thu May 31, 2012 9:56 am |
|
|
|
LeGhe
Joined: Tue May 18, 2010 2:02 pm
Posts: 26
|
Re: French VAT modification
even though I work directly in Access?
|
| Thu May 31, 2012 11:05 am |
|
|
|
FredrikN
Site Admin
Joined: Fri Nov 22, 2002 3:52 pm
Posts: 13748
|
Re: French VAT modification
If you know what you are doing, this should be possible...
_________________
Fredrik Nordbakke
www.fnprg.com
|
| Fri Jun 01, 2012 10:25 am |
|
|
|
|
Page 1 of 1
|
[ 10 posts ] |
|
|
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum
|
|
