11/04/2023 09:48:24 am >> SELECT document_num FROM ps_document WHERE document_num = '51/A' AND id_document != '82710' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2023-04-06') 11/04/2023 09:48:24 am >> UPDATE ps_document SET id_document_type = '24', document_num = '51/A', document_date = '2023-04-06', document_letter = 'A', id_customer = '333', id_supplier = '', id_address = '4671072', address1 = 'P.ZZA S. MICHELE 84135 RUFOLI', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '314.50', price_tax_excluded = '258.64', date_upd = NOW() WHERE id_document = '82710' 11/04/2023 09:48:24 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '82710' 11/04/2023 09:48:24 am >> DELETE FROM ps_document_detail WHERE id_document = '82710' 11/04/2023 09:48:24 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82710' , '15331' , 'CERO PASQUALE 80X120 - RILIEVO IN CERA' , '1' , '-1' , '1' , '135.0000' , '110.65573770492' , '22' , '0' , '135.00' ) 11/04/2023 09:48:24 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82710' , '20791' , 'BOTTIGLIE PER ACQUA BENEDETTA - CONF. 100 PZ' , '3' , '-3' , '1' , '22.0000' , '18.032786885246' , '22' , '0' , '66.00' ) 11/04/2023 09:48:24 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82710' , '1041' , 'BENEDIZIONI' , '500' , '-500' , '1' , '0.1200' , '0.098360655737705' , '22' , '0' , '60.00' ) 11/04/2023 09:48:24 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82710' , '1631' , 'CANDELINE NON GOCCIOLANTI ' , '1' , '-1' , '1' , '29.0000' , '23.770491803279' , '22' , '0' , '29.00' ) 11/04/2023 09:48:24 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82710' , '1914' , 'CERA DELLA LITURGIA' , '2' , '-2' , '1' , '4.90' , '4.016393442623' , '22' , '0' , '9.80' ) 11/04/2023 09:48:24 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82710' , '11756' , 'VINO BIANCO SECCO - 14%' , '1' , '-1' , '1' , '6.50' , '5.327868852459' , '22' , '0' , '6.50' ) 11/04/2023 09:48:24 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82710' , '16689' , 'OSTIA PAN DI CENA mm80' , '1' , '-1' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '2.00' ) 11/04/2023 09:48:24 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82710' , '16691' , 'PARTICOLE PER CELIACI 25pz' , '1' , '-1' , '3' , '4.00' , '3.8461538461538' , '4' , '0' , '4.00' ) 11/04/2023 09:48:24 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82710' , '18122' , 'ROCCA STOPPINO M. 100 - 469/100' , '2' , '-2' , '1' , '1.10' , '0.9016393442623' , '22' , '0' , '2.20' ) 11/04/2023 10:27:17 am >> SELECT document_num FROM ps_document WHERE document_num = '1198' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-04-11') 11/04/2023 10:27:17 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1198' , '2023-04-11' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '42.40' , '34.75' , NOW() , NOW() ) 11/04/2023 10:27:17 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '82738' 11/04/2023 10:27:17 am >> DELETE FROM ps_document_detail WHERE id_document = '82738' 11/04/2023 10:27:17 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82738' , '18122' , 'ROCCA STOPPINO M. 100 - 469/100' , '4' , '-4' , '1' , '1.10' , '0.9016393442623' , '22' , '0' , '4.40' ) 11/04/2023 10:27:17 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82738' , '1750' , 'CARTUCCIA TRASPARENTE DIAM. 3,2 - 454' , '2' , '-2' , '1' , '13.00' , '10.655737704918' , '22' , '0' , '26.00' ) 11/04/2023 10:27:17 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82738' , '17161' , 'CARBONCINI NERI - CARNE' , '1' , '-1' , '1' , '12.00' , '9.8360655737705' , '22' , '0' , '12.00' ) 11/04/2023 10:36:35 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '31' , '19' , '2023-04-07' , '' , '0' , '172' , '4677909' , 'VIA PIER LUIGI DA PALESTRINA 2 20124 MILANO' , '' , '' , '15' , '1' , '0' , '0' , '0' , '' , '9' , '0' , '784.67' , '643.17' , NOW() , NOW() ) 11/04/2023 10:36:35 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '82739' 11/04/2023 10:36:35 am >> DELETE FROM ps_document_detail WHERE id_document = '82739' 11/04/2023 10:36:35 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82739' , '13160' , 'CASULA MOD. CRISTOGRAMMA - cs12271' , '4' , '4' , '1' , '161.9' , '132.70491803279' , '22' , '3' , '766.3698' ) 11/04/2023 10:36:35 am >> DELETE FROM ps_product_supplier WHERE id_product = '13160' AND id_supplier = '172' 11/04/2023 10:36:35 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '13160' , '172' , '1' ) 11/04/2023 10:55:25 am >> SELECT document_num FROM ps_document WHERE document_num = '669' AND id_document != '82066' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-02-28') 11/04/2023 10:55:25 am >> UPDATE ps_document SET id_document_type = '11', document_num = '669', document_date = '2023-02-28', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '184.50', price_tax_excluded = '151.50', date_upd = NOW() WHERE id_document = '82066' 11/04/2023 10:55:25 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '82066' 11/04/2023 10:55:25 am >> DELETE FROM ps_document_detail WHERE id_document = '82066' 11/04/2023 10:55:26 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82066' , '12659' , 'CAMICE BIANCO - MISTO COT. 140' , '1' , '-1' , '1' , '55.0000' , '45.081967213115' , '22' , '0' , '55.00' ) 11/04/2023 10:55:26 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82066' , '18399' , 'CAMICE DUE PIEGONI POL. CERNIERA DAVANTI - 405TPAD' , '1' , '-1' , '1' , '68.0000' , '55.737704918033' , '22' , '0' , '68.00' ) 11/04/2023 10:55:26 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82066' , '18223' , 'CORONA MISSIONARIA - R102' , '6' , '-6' , '1' , '1.00' , '0.81967213114754' , '22' , '0' , '6.00' ) 11/04/2023 10:55:26 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82066' , '6962' , 'NELLA CASA DEL DEFUNTO' , '1' , '-1' , '4' , '1.5000' , '1.5' , '0' , '0' , '1.50' ) 11/04/2023 10:55:26 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82066' , '15481' , 'CROCE IHS - 2389/CZ' , '27' , '-27' , '1' , '2' , '1.6393442622951' , '22' , '0' , '54.00' ) 11/04/2023 10:56:39 am >> SELECT document_num FROM ps_document WHERE document_num = '34/A' AND id_document != '82289' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2023-03-14') 11/04/2023 10:56:39 am >> UPDATE ps_document SET id_document_type = '24', document_num = '34/A', document_date = '2023-03-14', document_letter = 'A', id_customer = '1656', id_supplier = '', id_address = '4677544', address1 = 'VIA NAZIONALE 84060 OMIGNANO SCALO', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '613.00', price_tax_excluded = '608.13', date_upd = NOW() WHERE id_document = '82289' 11/04/2023 10:56:39 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '82289' 11/04/2023 10:56:39 am >> DELETE FROM ps_document_detail WHERE id_document = '82289' 11/04/2023 10:57:30 am >> SELECT document_num FROM ps_document WHERE document_num = '647' AND id_document != '82040' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-02-27') 11/04/2023 10:57:30 am >> UPDATE ps_document SET id_document_type = '11', document_num = '647', document_date = '2023-02-27', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '100.00', price_tax_excluded = '95.67', date_upd = NOW() WHERE id_document = '82040' 11/04/2023 10:57:30 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '82040' 11/04/2023 10:57:30 am >> DELETE FROM ps_document_detail WHERE id_document = '82040' 11/04/2023 10:57:30 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82040' , '20064' , 'CATENINA IN ACCIAIO - NS053' , '1' , '-1' , '1' , '4.5000' , '3.6885245901639' , '22' , '0' , '4.50' ) 11/04/2023 10:57:30 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82040' , '18223' , 'CORONA MISSIONARIA - R102' , '7' , '-7' , '1' , '1.00' , '0.81967213114754' , '22' , '0' , '7.00' ) 11/04/2023 10:57:30 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82040' , '4697' , 'GLORIA MISCELA 25G - GLORE' , '3' , '-3' , '1' , '1.5000' , '1.2295081967213' , '22' , '0' , '4.50' ) 11/04/2023 10:57:30 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82040' , '20592' , 'SULLA TUA PAROLA MAR/APR 23 - 515' , '16' , '-16' , '4' , '5.0000' , '5' , '0' , '5' , '76.00' ) 11/04/2023 10:57:30 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82040' , '20516' , 'CROCE COMUNIONE - 42/08' , '6' , '-6' , '1' , '1.20' , '0.98360655737705' , '22' , '0' , '7.20' ) 11/04/2023 10:57:30 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82040' , '18223' , 'CORONA MISSIONARIA - R102' , '1' , '-1' , '1' , '0.8' , '0.65573770491803' , '22' , '0' , '0.80' ) 11/04/2023 10:57:49 am >> SELECT document_num FROM ps_document WHERE document_num = '820' AND id_document != '82272' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-03-13') 11/04/2023 10:57:49 am >> UPDATE ps_document SET id_document_type = '11', document_num = '820', document_date = '2023-03-13', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '64.00', price_tax_excluded = '52.46', date_upd = NOW() WHERE id_document = '82272' 11/04/2023 10:57:49 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '82272' 11/04/2023 10:57:49 am >> DELETE FROM ps_document_detail WHERE id_document = '82272' 11/04/2023 10:57:49 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82272' , '1041' , 'BENEDIZIONI' , '400' , '-400' , '1' , '0.1500' , '0.12295081967213' , '22' , '0' , '60.00' ) 11/04/2023 10:57:49 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82272' , '18223' , 'CORONA MISSIONARIA - R102' , '4' , '-4' , '1' , '1.00' , '0.81967213114754' , '22' , '0' , '4.00' ) 11/04/2023 10:58:24 am >> SELECT document_num FROM ps_document WHERE document_num = '767' AND id_document != '82204' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-03-08') 11/04/2023 10:58:24 am >> UPDATE ps_document SET id_document_type = '11', document_num = '767', document_date = '2023-03-08', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '42.90', price_tax_excluded = '35.16', date_upd = NOW() WHERE id_document = '82204' 11/04/2023 10:58:24 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '82204' 11/04/2023 10:58:24 am >> DELETE FROM ps_document_detail WHERE id_document = '82204' 11/04/2023 10:58:24 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82204' , '19717' , 'ROSARIO LEGNO SAN BENEDETTO - RE5042NAT' , '1' , '-1' , '1' , '5.8000' , '4.7540983606557' , '22' , '0' , '5.80' ) 11/04/2023 10:58:25 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82204' , '19777' , 'ANELLO CROCE/S.BENEDETTO' , '1' , '-1' , '1' , '15.0000' , '12.295081967213' , '22' , '0' , '15.00' ) 11/04/2023 10:58:25 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82204' , '18274' , 'BRACCIALE A NODI - 2610' , '1' , '-1' , '1' , '1.4000' , '1.1475409836066' , '22' , '0' , '1.40' ) 11/04/2023 10:58:25 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82204' , '18222' , 'ROSARIO COLORATO - R316' , '1' , '-1' , '1' , '0.70' , '0.57377049180328' , '22' , '0' , '0.70' ) 11/04/2023 10:58:25 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82204' , '19106' , 'FRAGRANZA NARDO' , '1' , '-1' , '1' , '15.0000' , '12.295081967213' , '22' , '0' , '15.00' ) 11/04/2023 10:58:25 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82204' , '18223' , 'CORONA MISSIONARIA - R102' , '5' , '-5' , '1' , '1.00' , '0.81967213114754' , '22' , '0' , '5.00' ) 11/04/2023 10:58:46 am >> SELECT document_num FROM ps_document WHERE document_num = '586' AND id_document != '81454' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-02-22') 11/04/2023 10:58:46 am >> UPDATE ps_document SET id_document_type = '11', document_num = '586', document_date = '2023-02-22', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '9.00', price_tax_excluded = '7.38', date_upd = NOW() WHERE id_document = '81454' 11/04/2023 10:58:46 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '81454' 11/04/2023 10:58:46 am >> DELETE FROM ps_document_detail WHERE id_document = '81454' 11/04/2023 10:58:46 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '81454' , '18223' , 'CORONA MISSIONARIA - R102' , '9' , '-9' , '1' , '1.00' , '0.81967213114754' , '22' , '0' , '9.00' ) 11/04/2023 10:59:28 am >> SELECT document_num FROM ps_document WHERE document_num = '874' AND id_document != '82337' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-03-16') 11/04/2023 10:59:28 am >> UPDATE ps_document SET id_document_type = '11', document_num = '874', document_date = '2023-03-16', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '45.00', price_tax_excluded = '36.89', date_upd = NOW() WHERE id_document = '82337' 11/04/2023 10:59:28 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '82337' 11/04/2023 10:59:28 am >> DELETE FROM ps_document_detail WHERE id_document = '82337' 11/04/2023 10:59:28 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82337' , '18617' , 'MEDAGLIA MIRACOLOSA - OV22/M' , '1' , '-1' , '1' , '0.20' , '0.16393442622951' , '22' , '0' , '0.20' ) 11/04/2023 10:59:28 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82337' , '20644' , 'STOLA - PST022' , '2' , '-2' , '1' , '19.9000' , '16.311475409836' , '22' , '0' , '39.80' ) 11/04/2023 10:59:28 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82337' , '18223' , 'CORONA MISSIONARIA - R102' , '5' , '-5' , '1' , '1' , '0.81967213114754' , '22' , '0' , '5.00' ) 11/04/2023 11:00:11 am >> SELECT document_num FROM ps_document WHERE document_num = '1003' AND id_document != '82504' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-03-28') 11/04/2023 11:00:11 am >> UPDATE ps_document SET id_document_type = '11', document_num = '1003', document_date = '2023-03-28', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '9.00', price_tax_excluded = '7.38', date_upd = NOW() WHERE id_document = '82504' 11/04/2023 11:00:11 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '82504' 11/04/2023 11:00:11 am >> DELETE FROM ps_document_detail WHERE id_document = '82504' 11/04/2023 11:00:11 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82504' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '6' , '4.9180327868852' , '22' , '0' , '6.00' ) 11/04/2023 11:00:11 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82504' , '18223' , 'CORONA MISSIONARIA - R102' , '3' , '-3' , '1' , '1.00' , '0.81967213114754' , '22' , '0' , '3.00' ) 11/04/2023 11:09:58 am >> SELECT document_num FROM ps_document WHERE document_num = '1199' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-04-11') 11/04/2023 11:09:58 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1199' , '2023-04-11' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '21.60' , '17.70' , NOW() , NOW() ) 11/04/2023 11:09:58 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '82740' 11/04/2023 11:09:58 am >> DELETE FROM ps_document_detail WHERE id_document = '82740' 11/04/2023 11:09:58 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82740' , '18318' , 'CONFEZIONE BRACCIALE MULTICOLORE COMUNIONE - 2377/K0001' , '8' , '-8' , '1' , '2.70' , '2.2131147540984' , '22' , '0' , '21.60' ) 11/04/2023 11:26:32 am >> SELECT document_num FROM ps_document WHERE document_num = '1200' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-04-11') 11/04/2023 11:26:32 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1200' , '2023-04-11' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '19.60' , '16.07' , NOW() , NOW() ) 11/04/2023 11:26:32 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '82741' 11/04/2023 11:26:32 am >> DELETE FROM ps_document_detail WHERE id_document = '82741' 11/04/2023 11:26:32 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82741' , '1914' , 'CERA DELLA LITURGIA' , '4' , '-4' , '1' , '4.90' , '4.016393442623' , '22' , '0' , '19.60' ) 11/04/2023 11:50:27 am >> SELECT document_num FROM ps_document WHERE document_num = '1201' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-04-11') 11/04/2023 11:50:27 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1201' , '2023-04-11' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '32.86' , '32.23' , NOW() , NOW() ) 11/04/2023 11:50:27 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '82742' 11/04/2023 11:50:27 am >> DELETE FROM ps_document_detail WHERE id_document = '82742' 11/04/2023 11:50:27 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82742' , '20902' , 'SCIENZIATI DUNQUE CREDENTI - F. AGNOLI' , '1' , '-1' , '4' , '16.00' , '16' , '0' , '5' , '15.20' ) 11/04/2023 11:50:27 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82742' , '16398' , 'MADONNA DELLE GRAZIE - 143' , '1' , '-1' , '1' , '3.50' , '2.8688524590164' , '22' , '0' , '3.50' ) 11/04/2023 11:50:27 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82742' , '16836' , 'AMORE DELLE ANIME - 8199' , '1' , '-1' , '4' , '7.00' , '7' , '0' , '5' , '6.65' ) 11/04/2023 11:50:27 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82742' , '17063' , 'MADONNA DEL CARMINE' , '1' , '-1' , '4' , '7.90' , '7.9' , '0' , '5' , '7.51' ) 11/04/2023 12:20:11 pm >> SELECT document_num FROM ps_document WHERE document_num = '1202' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-04-11') 11/04/2023 12:20:11 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1202' , '2023-04-11' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '44.88' , '44.81' , NOW() , NOW() ) 11/04/2023 12:20:11 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '82743' 11/04/2023 12:20:11 pm >> DELETE FROM ps_document_detail WHERE id_document = '82743' 11/04/2023 12:20:11 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82743' , '20578' , 'TOTUM AMORIS EST ' , '1' , '-1' , '4' , '2.00' , '2' , '0' , '0' , '2.00' ) 11/04/2023 12:20:11 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82743' , '20773' , 'VIA CRUCIS CON BENEDETTO XVI' , '1' , '-1' , '4' , '2.00' , '2' , '0' , '0' , '2.00' ) 11/04/2023 12:20:11 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82743' , '19376' , 'INCONTRARE IL CROCIFISSO - T. HALIK' , '1' , '-1' , '4' , '3.00' , '3' , '0' , '5' , '2.85' ) 11/04/2023 12:20:11 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82743' , '20652' , 'VIA CRUCIS CON GLI SCRITTI DI C. LUBICH - G. VALSECCHI' , '1' , '-1' , '4' , '2.00' , '2' , '0' , '0' , '2.00' ) 11/04/2023 12:20:11 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82743' , '20790' , 'AI PIEDI DEL SUO AMORE ' , '1' , '-1' , '4' , '3.50' , '3.5' , '0' , '5' , '3.33' ) 11/04/2023 12:20:11 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82743' , '15939' , 'AMORE CHE DECIDE - L. EPICOCO' , '1' , '-1' , '4' , '10.00' , '10' , '0' , '5' , '9.50' ) 11/04/2023 12:20:11 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82743' , '20804' , 'AFFIDABILI STORIE DI DONNE - L. EPICOCO' , '1' , '-1' , '4' , '12.00' , '12' , '0' , '5' , '11.40' ) 11/04/2023 12:20:11 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82743' , '20804' , 'AFFIDABILI STORIE DI DONNE - L. EPICOCO' , '1' , '-1' , '4' , '12.00' , '12' , '0' , '5' , '11.40' ) 11/04/2023 12:20:11 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82743' , '19468' , 'CORONA DELLE ROSE BIGLIETTO - 31111' , '2' , '-2' , '1' , '0.20' , '0.16393442622951' , '22' , '0' , '0.40' ) 11/04/2023 12:36:59 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788831555586' AND id_product != '20739' AND ean13 != '' 11/04/2023 12:36:59 pm >> UPDATE ps_product SET id_supplier = '7', reference = '7/3', ean13 = '9788831555586', date_upd = NOW() WHERE id_product = '20739' 11/04/2023 12:36:59 pm >> UPDATE ps_product_lang SET name = 'OLIO DI LETIZIA - M. MANCA', description = '' WHERE id_product = '20739' 11/04/2023 12:36:59 pm >> UPDATE ps_product SET wholesale_price = '4.02', on_sale = '0', price = '6.0000' WHERE id_product = '20739' 11/04/2023 12:36:59 pm >> UPDATE ps_product_shop SET wholesale_price = '4.02', price = '6.0000', id_tax_rules_group = '4', id_category_default = '27', id_argoment_default = '50', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '20739' 11/04/2023 12:36:59 pm >> DELETE FROM ps_specific_price WHERE id_product = '20739' 11/04/2023 12:37:42 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788831555593' AND id_product != '20728' AND ean13 != '' 11/04/2023 12:37:42 pm >> UPDATE ps_product SET id_supplier = '7', reference = '7/5', ean13 = '9788831555593', date_upd = NOW() WHERE id_product = '20728' 11/04/2023 12:37:42 pm >> UPDATE ps_product_lang SET name = 'OCCHI CHE SI APRONO', description = '' WHERE id_product = '20728' 11/04/2023 12:37:42 pm >> UPDATE ps_product SET wholesale_price = '4.02', on_sale = '0', price = '6.0000' WHERE id_product = '20728' 11/04/2023 12:37:42 pm >> UPDATE ps_product_shop SET wholesale_price = '4.02', price = '6.0000', id_tax_rules_group = '4', id_category_default = '27', id_argoment_default = '50', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '20728' 11/04/2023 12:37:42 pm >> DELETE FROM ps_specific_price WHERE id_product = '20728' 11/04/2023 12:40:02 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9791259752185' AND id_product != '20672' AND ean13 != '' 11/04/2023 12:40:02 pm >> UPDATE ps_product SET id_supplier = '7', reference = '13/4', ean13 = '9791259752185', date_upd = NOW() WHERE id_product = '20672' 11/04/2023 12:40:02 pm >> UPDATE ps_product_lang SET name = 'VOLGERANNO LO SGUARDO A COLUI ... - P. MONTINI', description = '' WHERE id_product = '20672' 11/04/2023 12:40:02 pm >> UPDATE ps_product SET wholesale_price = '8.40', on_sale = '0', price = '12.0000' WHERE id_product = '20672' 11/04/2023 12:40:02 pm >> UPDATE ps_product_shop SET wholesale_price = '8.40', price = '12.0000', id_tax_rules_group = '4', id_category_default = '267', id_argoment_default = '50', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '20672' 11/04/2023 12:40:02 pm >> DELETE FROM ps_specific_price WHERE id_product = '20672' 11/04/2023 12:41:38 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788892240605' AND id_product != '20663' AND ean13 != '' 11/04/2023 12:41:38 pm >> UPDATE ps_product SET id_supplier = '7', reference = '7/5', ean13 = '9788892240605', date_upd = NOW() WHERE id_product = '20663' 11/04/2023 12:41:38 pm >> UPDATE ps_product_lang SET name = 'CON MARIA SULLA STRADA DELLA PASQUA - L. FANZAGA', description = '' WHERE id_product = '20663' 11/04/2023 12:41:38 pm >> UPDATE ps_product SET wholesale_price = '8.04', on_sale = '0', price = '12.0000' WHERE id_product = '20663' 11/04/2023 12:41:38 pm >> UPDATE ps_product_shop SET wholesale_price = '8.04', price = '12.0000', id_tax_rules_group = '4', id_category_default = '30', id_argoment_default = '23', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '20663' 11/04/2023 12:41:38 pm >> DELETE FROM ps_specific_price WHERE id_product = '20663' 11/04/2023 02:30:00 pm >> SELECT document_num FROM ps_document WHERE document_num = '1203' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-04-11') 11/04/2023 02:30:00 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1203' , '2023-04-11' , '' , '1237' , '0' , '4678089' , 'VIA MILANO 11 97019 VITTORIA' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '569.50' , '566.07' , NOW() , NOW() ) 11/04/2023 02:30:00 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '82744' 11/04/2023 02:30:00 pm >> DELETE FROM ps_document_detail WHERE id_document = '82744' 11/04/2023 02:30:00 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82744' , '20722' , 'SEMINATORI DI GIOIA' , '50' , '-50' , '4' , '2.50' , '2.5' , '0' , '25' , '94.00' ) 11/04/2023 02:30:00 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82744' , '13505' , 'CELEBRIAMO IL SACRAMENTO DEL PERDONO' , '50' , '-50' , '0' , '0.50' , '0.5' , '' , '25' , '19.00' ) 11/04/2023 02:30:00 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82744' , '12255' , 'IN CAMMINO CON GESU\'' , '50' , '-50' , '4' , '3.80' , '3.8' , '0' , '25' , '142.50' ) 11/04/2023 02:30:00 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82744' , '7916' , 'PERGAMENE - 1A RICONCILIAZIONE MOD. A' , '50' , '-50' , '1' , '0.50' , '0.40983606557377' , '22' , '25' , '19.00' ) 11/04/2023 02:30:00 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82744' , '' , 'CAMICE' , '1' , '-1' , '0' , '295' , '295' , '' , '0' , '295.00' ) 11/04/2023 02:30:54 pm >> DELETE FROM ps_document WHERE id_document = '82744' 11/04/2023 02:30:54 pm >> DELETE FROM ps_document_detail WHERE id_document = '82744' 11/04/2023 02:33:43 pm >> SELECT document_num FROM ps_document WHERE document_num = '1203' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-04-11') 11/04/2023 02:33:43 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1203' , '2023-04-11' , '' , '1237' , '0' , '4678089' , 'VIA MILANO 11 97019 VITTORIA' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '619.50' , '610.48' , NOW() , NOW() ) 11/04/2023 02:33:43 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '82745' 11/04/2023 02:33:43 pm >> DELETE FROM ps_document_detail WHERE id_document = '82745' 11/04/2023 02:33:43 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82745' , '20722' , 'SEMINATORI DI GIOIA' , '50' , '-50' , '4' , '2.50' , '2.5' , '0' , '25' , '94.00' ) 11/04/2023 02:33:43 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82745' , '13505' , 'CELEBRIAMO IL SACRAMENTO DEL PERDONO' , '50' , '-50' , '0' , '0.50' , '0.5' , '' , '25' , '19.00' ) 11/04/2023 02:33:43 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82745' , '12255' , 'IN CAMMINO CON GESU\'' , '50' , '-50' , '4' , '3.80' , '3.8' , '0' , '25' , '142.50' ) 11/04/2023 02:33:43 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82745' , '7916' , 'PERGAMENE - 1A RICONCILIAZIONE MOD. A' , '50' , '-50' , '0' , '0.50' , '0.5' , '' , '25' , '19.00' ) 11/04/2023 02:33:43 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82745' , '19231' , 'CARD CARLO ACUTIS - RN93' , '50' , '-50' , '1' , '1.00' , '0.81967213114754' , '22' , '0' , '50.00' ) 11/04/2023 02:33:43 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82745' , '' , 'CAMICE - 145' , '1' , '-1' , '0' , '295' , '295' , '' , '0' , '295.00' ) 11/04/2023 02:33:59 pm >> DELETE FROM ps_document WHERE id_document = '82745' 11/04/2023 02:33:59 pm >> DELETE FROM ps_document_detail WHERE id_document = '82745' 11/04/2023 02:35:30 pm >> SELECT document_num FROM ps_document WHERE document_num = '751' AND id_document != '82184' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-03-07') 11/04/2023 02:35:30 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '751', document_date = '2023-03-07', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '38.50', price_tax_excluded = '31.83', date_upd = NOW() WHERE id_document = '82184' 11/04/2023 02:35:30 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '82184' 11/04/2023 02:35:30 pm >> DELETE FROM ps_document_detail WHERE id_document = '82184' 11/04/2023 02:35:30 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82184' , '6016' , 'LUMINO ELETTRONICO VOTIVO - 2297 ' , '2' , '-2' , '1' , '8.5000' , '6.9672131147541' , '22' , '0' , '17.00' ) 11/04/2023 02:35:30 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82184' , '17719' , 'VIA CRUCIS PER GLI SPOSI E FAMIGLIE - 8444' , '1' , '-1' , '4' , '1.5000' , '1.5' , '0' , '0' , '1.50' ) 11/04/2023 02:35:31 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82184' , '19231' , 'CARD CARLO ACUTIS - RN93' , '20' , '-20' , '1' , '1.00' , '0.81967213114754' , '22' , '0' , '20.00' ) 11/04/2023 02:36:04 pm >> SELECT document_num FROM ps_document WHERE document_num = '845' AND id_document != '82302' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-03-15') 11/04/2023 02:36:04 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '845', document_date = '2023-03-15', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '70.00', price_tax_excluded = '60.12', date_upd = NOW() WHERE id_document = '82302' 11/04/2023 02:36:04 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '82302' 11/04/2023 02:36:04 pm >> DELETE FROM ps_document_detail WHERE id_document = '82302' 11/04/2023 02:36:04 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82302' , '20431' , 'PARTICOLA TAGLIO CHIUSO 35MM - W500' , '2' , '-2' , '3' , '3.3000' , '3.1730769230769' , '4' , '0' , '6.60' ) 11/04/2023 02:36:04 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82302' , '20433' , 'PARTICOLA MORREALE 38MM - PTC38S' , '2' , '-2' , '3' , '3.5000' , '3.3653846153846' , '4' , '0' , '7.00' ) 11/04/2023 02:36:04 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82302' , '7311' , 'OSTIA SOTTILE 74MM' , '3' , '-3' , '3' , '1.9000' , '1.8269230769231' , '4' , '0' , '5.70' ) 11/04/2023 02:36:04 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82302' , '11757' , 'VINO LIQUOROSO DOLCE - 16%' , '3' , '-3' , '1' , '7.5000' , '6.1475409836066' , '22' , '0' , '22.50' ) 11/04/2023 02:36:04 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82302' , '18617' , 'MEDAGLIA MIRACOLOSA - OV22/M' , '1' , '-1' , '1' , '0.20' , '0.16393442622951' , '22' , '0' , '0.20' ) 11/04/2023 02:36:04 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82302' , '19231' , 'CARD CARLO ACUTIS - RN93' , '28' , '-28' , '1' , '1.00' , '0.81967213114754' , '22' , '0' , '28.00' ) 11/04/2023 03:22:58 pm >> SELECT document_num FROM ps_document WHERE document_num = '7/L' AND id_document != '' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2023-04-11') 11/04/2023 03:22:58 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '23' , '7/L' , '2023-04-11' , 'L' , '204' , '0' , '4671483' , 'VIA ROBERTO IL GUISCARDO, 3 84121 SALERNO' , '' , 'CAPPELLANIA OSPEDALIERA M. S. SEVERINO' , '0.00' , '4' , '0' , '0' , '0' , '' , '3' , '0' , '101.00' , '83.15' , NOW() , NOW() ) 11/04/2023 03:22:58 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '82746' 11/04/2023 03:22:58 pm >> DELETE FROM ps_document_detail WHERE id_document = '82746' 11/04/2023 03:22:58 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82746' , '5903' , 'LITURGICO ART. 60LT ROSSO SUPER' , '30' , '-30' , '1' , '3.3000' , '2.7049' , '22' , '' , '99.00' ) 11/04/2023 03:22:58 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82746' , '20578' , 'TOTUM AMORIS EST ' , '1' , '-1' , '4' , '2.0000' , '2' , '0' , '0' , '2.00' ) 11/04/2023 03:25:59 pm >> DELETE FROM ps_document WHERE id_document = '78146' 11/04/2023 03:25:59 pm >> DELETE FROM ps_document_detail WHERE id_document = '78146' 11/04/2023 04:07:38 pm >> SELECT document_num FROM ps_document WHERE document_num = '1203' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-04-11') 11/04/2023 04:07:38 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1203' , '2023-04-11' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '155.00' , '127.05' , NOW() , NOW() ) 11/04/2023 04:07:38 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '82747' 11/04/2023 04:07:38 pm >> DELETE FROM ps_document_detail WHERE id_document = '82747' 11/04/2023 04:07:38 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82747' , '17568' , 'BAMBINO IN RESINA FASCIA ORO - PB13629' , '4' , '-4' , '1' , '15.00' , '12.295081967213' , '22' , '0' , '60.00' ) 11/04/2023 04:07:38 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82747' , '18884' , 'BAMBINELLO CM 10 - PB13627' , '2' , '-2' , '1' , '6.5' , '5.327868852459' , '22' , '0' , '13.00' ) 11/04/2023 04:07:38 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82747' , '19999' , 'GESU BAMBINO CON AUREOLA CM 15 - BJ148-15' , '4' , '-4' , '1' , '10' , '8.1967213114754' , '22' , '0' , '40.00' ) 11/04/2023 04:07:38 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82747' , '20000' , 'GESU BAMBINO CM 15 - BJ140-15E' , '4' , '-4' , '1' , '10.5' , '8.6065573770492' , '22' , '0' , '42.00' ) 11/04/2023 04:46:32 pm >> SELECT document_num FROM ps_document WHERE document_num = '1204' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-04-11') 11/04/2023 04:46:32 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1204' , '2023-04-11' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '15.00' , '12.30' , NOW() , NOW() ) 11/04/2023 04:46:32 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '82748' 11/04/2023 04:46:32 pm >> DELETE FROM ps_document_detail WHERE id_document = '82748' 11/04/2023 04:46:32 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82748' , '19315' , 'SCATOLINA METALLO CON CORONCINA COMUNIONE - 1016/K209' , '5' , '-5' , '1' , '3.00' , '2.4590163934426' , '22' , '0' , '15.00' ) 11/04/2023 04:49:00 pm >> SELECT document_num FROM ps_document WHERE document_num = '833' AND id_document != '82287' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-03-13') 11/04/2023 04:49:00 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '833', document_date = '2023-03-13', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '27.80', price_tax_excluded = '25.90', date_upd = NOW() WHERE id_document = '82287' 11/04/2023 04:49:00 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '82287' 11/04/2023 04:49:00 pm >> DELETE FROM ps_document_detail WHERE id_document = '82287' 11/04/2023 04:49:00 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82287' , '20433' , 'PARTICOLA MORREALE 38MM - PTC38S' , '5' , '-5' , '3' , '3.5000' , '3.3653846153846' , '4' , '0' , '17.50' ) 11/04/2023 04:49:00 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82287' , '19157' , 'COMUNIONE AGLI INFERMI - N.E.' , '1' , '-1' , '4' , '2.0000' , '2' , '0' , '0' , '2.00' ) 11/04/2023 04:49:00 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82287' , '6962' , 'NELLA CASA DEL DEFUNTO' , '1' , '-1' , '4' , '1.5000' , '1.5' , '0' , '0' , '1.50' ) 11/04/2023 04:49:00 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82287' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '6.6' , '5.4098360655738' , '22' , '0' , '6.60' ) 11/04/2023 04:49:00 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82287' , '19468' , 'CORONA DELLE ROSE BIGLIETTO - 31111' , '1' , '-1' , '1' , '0.20' , '0.16393442622951' , '22' , '0' , '0.20' ) 11/04/2023 06:17:24 pm >> SELECT document_num FROM ps_document WHERE document_num = '1205' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-04-11') 11/04/2023 06:17:24 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1205' , '2023-04-11' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '30.80' , '25.25' , NOW() , NOW() ) 11/04/2023 06:17:24 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '82749' 11/04/2023 06:17:24 pm >> DELETE FROM ps_document_detail WHERE id_document = '82749' 11/04/2023 06:17:24 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82749' , '11625' , 'CORPORALE - 47X47 - SERV 4' , '1' , '-1' , '1' , '11.80' , '9.672131147541' , '22' , '0' , '11.80' ) 11/04/2023 06:17:25 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82749' , '11623' , 'MANUTERGIO 28X48 - SERV 2' , '2' , '-2' , '1' , '6.50' , '5.327868852459' , '22' , '0' , '13.00' ) 11/04/2023 06:17:25 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82749' , '1912' , 'CERA DELL\'EREMO - 415/B ' , '1' , '-1' , '1' , '6.00' , '4.9180327868852' , '22' , '0' , '6.00' ) 11/04/2023 07:06:02 pm >> SELECT document_num FROM ps_document WHERE document_num = '1206' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-04-11') 11/04/2023 07:06:02 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1206' , '2023-04-11' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '121.50' , '99.59' , NOW() , NOW() ) 11/04/2023 07:06:02 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '82750' 11/04/2023 07:06:02 pm >> DELETE FROM ps_document_detail WHERE id_document = '82750' 11/04/2023 07:06:02 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82750' , '20705' , 'CANDELA CUBO' , '9' , '-9' , '1' , '13.50' , '11.065573770492' , '22' , '0' , '121.50' ) 11/04/2023 07:45:35 pm >> SELECT document_num FROM ps_document WHERE document_num = '1207' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-04-11') 11/04/2023 07:45:35 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1207' , '2023-04-11' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '9.50' , '9.50' , NOW() , NOW() ) 11/04/2023 07:45:35 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '82751' 11/04/2023 07:45:35 pm >> DELETE FROM ps_document_detail WHERE id_document = '82751' 11/04/2023 07:45:35 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82751' , '20795' , 'SULLA TUA PAROLA MAG/GIU 2023 - 516' , '2' , '-2' , '4' , '5.00' , '5' , '0' , '5' , '9.50' ) 11/04/2023 07:58:01 pm >> SELECT document_num FROM ps_document WHERE document_num = '1208' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-04-11') 11/04/2023 07:58:01 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1208' , '2023-04-11' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '9.00' , '7.38' , NOW() , NOW() ) 11/04/2023 07:58:01 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '82752' 11/04/2023 07:58:01 pm >> DELETE FROM ps_document_detail WHERE id_document = '82752' 11/04/2023 07:58:01 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82752' , '1914' , 'CERA DELLA LITURGIA' , '1' , '-1' , '1' , '4.90' , '4.016393442623' , '22' , '0' , '4.90' ) 11/04/2023 07:58:01 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82752' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '2' , '1.6393442622951' , '22' , '0' , '2.00' ) 11/04/2023 07:58:01 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82752' , '16989' , 'QUADRETTO SMUSSATO 7X10 MIRACOLOSA' , '1' , '-1' , '1' , '2.10' , '1.7213114754098' , '22' , '0' , '2.10' )