Page 1 of 1

Add vat

Posted: Wed May 13, 2009 11:30 am
by lillolollo
Possibility to add a varchar field on users profile to store vat number and possibility to insert it on invoice.
In italy we need this option, actually we are a patch , but I think it is better to insert it into the main code for all user

Re: Add vat

Posted: Sun May 17, 2009 6:35 am
by Daniel
ok i might be able to add this.

Re: Add vat

Posted: Mon May 18, 2009 3:32 am
by lillolollo
We need also to modificate region it's wrong delete the old one and add

INSERT INTO `zone` (`zone_id`, `country_id`, `code`, `name`) VALUES
(3859, 105, 'CA', 'Cagliari'),
(3858, 105, 'BR', 'Brindisi'),
(3857, 105, 'BS', 'Brescia'),
(3856, 105, 'BZ', 'Bolzano'),
(3855, 105, 'BO', 'Bologna'),
(3854, 105, 'BI', 'Biella'),
(3853, 105, 'BG', 'Bergamo'),
(3852, 105, 'BN', 'Benevento'),
(3851, 105, 'BL', 'Belluno'),
(3850, 105, 'BA', 'Bari'),
(3849, 105, 'AV', 'Avellino'),
(3848, 105, 'AT', 'Asti'),
(3847, 105, 'AP', 'Ascoli Piceno'),
(3846, 105, 'AR', 'Arezzo'),
(3845, 105, 'AO', 'Aosta'),
(3844, 105, 'AN', 'Ancona'),
(3843, 105, 'AL', 'Alessandria'),
(3842, 105, 'AG', 'Agrigento'),
(3860, 105, 'CL', 'Caltanissetta'),
(3861, 105, 'CB', 'Campobasso'),
(3862, 105, 'CI', 'Carbonia-Iglesias'),
(3863, 105, 'CE', 'Caserta'),
(3864, 105, 'CT', 'Catania'),
(3865, 105, 'CZ', 'Catanzaro'),
(3866, 105, 'CH', 'Chieti'),
(3867, 105, 'CO', 'Como'),
(3868, 105, 'CS', 'Cosenza'),
(3869, 105, 'CR', 'Cremona'),
(3870, 105, 'KR', 'Crotone'),
(3871, 105, 'CN', 'Cuneo'),
(3872, 105, 'EN', 'Enna'),
(3873, 105, 'FE', 'Ferrara'),
(3874, 105, 'FI', 'Firenze'),
(3875, 105, 'FG', 'Foggia'),
(3876, 105, 'FC', 'Forli-Cesena'),
(3877, 105, 'FR', 'Frosinone'),
(3878, 105, 'GE', 'Genova'),
(3879, 105, 'GO', 'Gorizia'),
(3880, 105, 'GR', 'Grosseto'),
(3881, 105, 'IM', 'Imperia'),
(3882, 105, 'IS', 'Isernia'),
(3883, 105, 'AQ', 'L'Aquila'),
(3884, 105, 'SP', 'La Spezia'),
(3885, 105, 'LT', 'Latina'),
(3886, 105, 'LE', 'Lecce'),
(3887, 105, 'LC', 'Lecco'),
(3888, 105, 'LI', 'Livorno'),
(3889, 105, 'LO', 'Lodi'),
(3890, 105, 'LU', 'Lucca'),
(3891, 105, 'MC', 'Macerata'),
(3892, 105, 'MN', 'Mantova'),
(3893, 105, 'MS', 'Massa-Carrara'),
(3894, 105, 'MT', 'Matera'),
(3895, 105, 'VS', 'Medio Campidano'),
(3896, 105, 'ME', 'Messina'),
(3897, 105, 'MI', 'Milano'),
(3898, 105, 'MO', 'Modena'),
(3899, 105, 'NA', 'Napoli'),
(3900, 105, 'NO', 'Novara'),
(3901, 105, 'NU', 'Nuoro'),
(3902, 105, 'OG', 'Ogliastra'),
(3903, 105, 'OT', 'Olbia-Tempio'),
(3904, 105, 'OR', 'Oristano'),
(3905, 105, 'PD', 'Padova'),
(3906, 105, 'PA', 'Palermo'),
(3907, 105, 'PR', 'Parma'),
(3908, 105, 'PV', 'Pavia'),
(3909, 105, 'PG', 'Perugia'),
(3910, 105, 'PU', 'Pesaro e Urbino'),
(3911, 105, 'PE', 'Pescara'),
(3912, 105, 'PC', 'Piacenza'),
(3913, 105, 'PI', 'Pisa'),
(3914, 105, 'PT', 'Pistoia'),
(3915, 105, 'PN', 'Pordenone'),
(3916, 105, 'PZ', 'Potenza'),
(3917, 105, 'PO', 'Prato'),
(3918, 105, 'RG', 'Ragusa'),
(3919, 105, 'RA', 'Ravenna'),
(3920, 105, 'RC', 'Reggio Calabria'),
(3921, 105, 'RE', 'Reggio Emilia'),
(3922, 105, 'RI', 'Rieti'),
(3923, 105, 'RN', 'Rimini'),
(3924, 105, 'RM', 'Roma'),
(3925, 105, 'RO', 'Rovigo'),
(3926, 105, 'SA', 'Salerno'),
(3927, 105, 'SS', 'Sassari'),
(3928, 105, 'SV', 'Savona'),
(3929, 105, 'SI', 'Siena'),
(3930, 105, 'SR', 'Siracusa'),
(3931, 105, 'SO', 'Sondrio'),
(3932, 105, 'TA', 'Taranto'),
(3933, 105, 'TE', 'Teramo'),
(3934, 105, 'TR', 'Terni'),
(3935, 105, 'TO', 'Torino'),
(3936, 105, 'TP', 'Trapani'),
(3937, 105, 'TN', 'Trento'),
(3938, 105, 'TV', 'Treviso'),
(3939, 105, 'TS', 'Trieste'),
(3940, 105, 'UD', 'Udine'),
(3941, 105, 'VA', 'Varese'),
(3942, 105, 'VE', 'Venezia'),
(3943, 105, 'VB', 'Verbano-Cusio-Ossola'),
(3944, 105, 'VC', 'Vercelli'),
(3945, 105, 'VR', 'Verona'),
(3946, 105, 'VV', 'Vibo Valentia'),
(3947, 105, 'VI', 'Vicenza'),
(3948, 105, 'VT', 'Viterbo');

Re: Add vat

Posted: Thu Jul 23, 2009 6:23 am
by Daniel
done it will be in 1.3.1

Re: Add vat

Posted: Thu Jul 23, 2009 11:38 am
by lillolollo
ok thanks daniel