21/12/2024 09:15:23 am >> SELECT document_num FROM ps_document WHERE document_num = '4016' AND id_document != '94950' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-12-19') 21/12/2024 09:15:23 am >> UPDATE ps_document SET id_document_type = '11', document_num = '4016', document_date = '2024-12-19', 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 = '40.00', price_tax_excluded = '32.79', date_upd = NOW() WHERE id_document = '94950' 21/12/2024 09:15:23 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 = '94950' 21/12/2024 09:15:23 am >> DELETE FROM ps_document_detail WHERE id_document = '94950' 21/12/2024 09:15:23 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 ( '94950' , '13049' , 'LITURGICO ART. 60LT BIANCO SUPER' , '10' , '-10' , '1' , '3.5000' , '2.8688524590164' , '22' , '0' , '35.00' ) 21/12/2024 09:15:23 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 ( '94950' , '16333' , 'NATIVITA ALBERO VETRO CM 16' , '1' , '-1' , '1' , '5' , '4.0983606557377' , '22' , '0' , '5.00' ) 21/12/2024 09:24:19 am >> SELECT document_num FROM ps_document WHERE document_num = '4042' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-12-21') 21/12/2024 09:24:19 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' , '4042' , '2024-12-21' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '70.00' , '57.38' , NOW() , NOW() ) 21/12/2024 09:24:19 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 = '94985' 21/12/2024 09:24:19 am >> DELETE FROM ps_document_detail WHERE id_document = '94985' 21/12/2024 09:24:50 am >> DELETE FROM ps_document WHERE id_document = '94985' 21/12/2024 09:24:50 am >> DELETE FROM ps_document_detail WHERE id_document = '94985' 21/12/2024 09:25:26 am >> SELECT document_num FROM ps_document WHERE document_num = '4042' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-12-21') 21/12/2024 09:25:26 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' , '4042' , '2024-12-21' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '70.00' , '57.38' , NOW() , NOW() ) 21/12/2024 09:25:26 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 = '94986' 21/12/2024 09:25:26 am >> DELETE FROM ps_document_detail WHERE id_document = '94986' 21/12/2024 09:25: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 ( '94986' , '16333' , 'NATIVITA\' ALBERO VETRO CM 16' , '8' , '-8' , '1' , '5' , '4.0983606557377' , '22' , '0' , '40.00' ) 21/12/2024 09:25: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 ( '94986' , '23189' , 'GRUPPO NATIVITA\' STILIZZATA - PB18073' , '15' , '-15' , '1' , '2.00' , '1.6393442622951' , '22' , '0' , '30.00' ) 21/12/2024 09:27:28 am >> SELECT document_num FROM ps_document WHERE document_num = '4043' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-12-21') 21/12/2024 09:27:28 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' , '4043' , '2024-12-21' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '49.31' , '49.31' , NOW() , NOW() ) 21/12/2024 09:27: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 = '94987' 21/12/2024 09:27:28 am >> DELETE FROM ps_document_detail WHERE id_document = '94987' 21/12/2024 09:27: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 ( '94987' , '22507' , 'SPES NON CONFUNDIT' , '1' , '-1' , '4' , '2.00' , '2' , '0' , '5' , '1.90' ) 21/12/2024 09:27: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 ( '94987' , '23274' , 'FEDE E UN VIAGGIO - PAPA FRANCESCO' , '1' , '-1' , '4' , '8.00' , '8' , '0' , '5' , '7.60' ) 21/12/2024 09:27: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 ( '94987' , '22871' , 'SPERANZA NON DELUDE - M. DE ROSA' , '1' , '-1' , '4' , '8.00' , '8' , '0' , '5' , '7.60' ) 21/12/2024 09:27: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 ( '94987' , '23015' , 'PELLEGRINI DI SPERANZA - SUSSIDIO GIUBILEO ADULTI' , '1' , '-1' , '4' , '2.90' , '2.9' , '0' , '5' , '2.76' ) 21/12/2024 09:27: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 ( '94987' , '23092' , 'SPERANZA CHE E IN NOI' , '1' , '-1' , '4' , '3.00' , '3' , '0' , '5' , '2.85' ) 21/12/2024 09:27: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 ( '94987' , '22877' , 'OH, MAMMA CELESTE! - F. CRISTOFARO' , '1' , '-1' , '4' , '15.00' , '15' , '0' , '5' , '14.25' ) 21/12/2024 09:27: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 ( '94987' , '23324' , 'PELLEGRINI DI SPERANZA' , '1' , '-1' , '4' , '3.00' , '3' , '0' , '5' , '2.85' ) 21/12/2024 09:27: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 ( '94987' , '23206' , 'GIUBILEO DELLA SPERANZA - U. TERRINONI' , '1' , '-1' , '4' , '10.00' , '10' , '0' , '5' , '9.50' ) 21/12/2024 09:51:37 am >> SELECT document_num FROM ps_document WHERE document_num = '4044' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-12-21') 21/12/2024 09:51:37 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' , '4044' , '2024-12-21' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '43.00' , '35.25' , NOW() , NOW() ) 21/12/2024 09:51:37 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 = '94988' 21/12/2024 09:51:37 am >> DELETE FROM ps_document_detail WHERE id_document = '94988' 21/12/2024 09:51:37 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 ( '94988' , '23188' , 'GRUPPO NATIVITA\' CAMPANA CON LUCI - PB20515' , '1' , '-1' , '1' , '23' , '18.852459016393' , '22' , '0' , '23.00' ) 21/12/2024 09:51:37 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 ( '94988' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '20' , '16.393442622951' , '22' , '0' , '20.00' ) 21/12/2024 10:48:01 am >> SELECT document_num FROM ps_document WHERE document_num = '4045' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-12-21') 21/12/2024 10:48:01 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' , '4045' , '2024-12-21' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '41.80' , '41.80' , NOW() , NOW() ) 21/12/2024 10:48:01 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 = '94989' 21/12/2024 10:48:01 am >> DELETE FROM ps_document_detail WHERE id_document = '94989' 21/12/2024 10:48:01 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 ( '94989' , '17673' , 'FUI CHIAMATO DOLINDO' , '1' , '-1' , '4' , '35.00' , '35' , '0' , '5' , '33.25' ) 21/12/2024 10:48:01 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 ( '94989' , '6414' , 'MERAVIGLIOSO SEGRETO DELLE ANIME DEL PURGATORIO - 8110' , '1' , '-1' , '4' , '9.00' , '9' , '0' , '5' , '8.55' ) 21/12/2024 10:50:55 am >> SELECT document_num FROM ps_document WHERE document_num = '4046' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-12-21') 21/12/2024 10:50:55 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' , '4046' , '2024-12-21' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '21.00' , '17.21' , NOW() , NOW() ) 21/12/2024 10:50:55 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 = '94990' 21/12/2024 10:50:55 am >> DELETE FROM ps_document_detail WHERE id_document = '94990' 21/12/2024 10:50:55 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 ( '94990' , '5976' , 'LUCERNA VETRO - 1493' , '1' , '-1' , '1' , '21.00' , '17.213114754098' , '22' , '0' , '21.00' ) 21/12/2024 11:21:25 am >> SELECT document_num FROM ps_document WHERE document_num = '4047' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-12-21') 21/12/2024 11:21:25 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' , '4047' , '2024-12-21' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '51.50' , '42.21' , NOW() , NOW() ) 21/12/2024 11:21: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 = '94991' 21/12/2024 11:21:25 am >> DELETE FROM ps_document_detail WHERE id_document = '94991' 21/12/2024 11:21: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 ( '94991' , '21790' , 'BAMBINELLO CM 20 - PB16832' , '1' , '-1' , '1' , '17.00' , '13.934426229508' , '22' , '0' , '17.00' ) 21/12/2024 11:21: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 ( '94991' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '22' , '18.032786885246' , '22' , '0' , '22.00' ) 21/12/2024 11:21: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 ( '94991' , '13355' , 'ROSARIO CRISTALLO VARI COLORI - 07777' , '1' , '-1' , '1' , '12.50' , '10.245901639344' , '22' , '0' , '12.50' ) 21/12/2024 11:28:39 am >> SELECT document_num FROM ps_document WHERE document_num = '4047' AND id_document != '94991' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-12-21') 21/12/2024 11:28:39 am >> UPDATE ps_document SET id_document_type = '11', document_num = '4047', document_date = '2024-12-21', 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 = '51.50', price_tax_excluded = '42.21', date_upd = NOW() WHERE id_document = '94991' 21/12/2024 11:28: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 = '94991' 21/12/2024 11:28:39 am >> DELETE FROM ps_document_detail WHERE id_document = '94991' 21/12/2024 11:28:39 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 ( '94991' , '21790' , 'BAMBINELLO CM 20 - PB16832' , '1' , '-1' , '1' , '17.0000' , '13.934426229508' , '22' , '0' , '17.00' ) 21/12/2024 11:28:39 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 ( '94991' , '20705' , 'CANDELA CUBO' , '2' , '-2' , '1' , '11' , '9.016393442623' , '22' , '0' , '22.00' ) 21/12/2024 11:28:39 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 ( '94991' , '13355' , 'ROSARIO CRISTALLO VARI COLORI - 07777' , '1' , '-1' , '1' , '12.5000' , '10.245901639344' , '22' , '0' , '12.50' ) 21/12/2024 11:29:19 am >> SELECT document_num FROM ps_document WHERE document_num = '3676' AND id_document != '94529' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-11-27') 21/12/2024 11:29:19 am >> UPDATE ps_document SET id_document_type = '11', document_num = '3676', document_date = '2024-11-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 = '70.09', price_tax_excluded = '57.83', date_upd = NOW() WHERE id_document = '94529' 21/12/2024 11:29:19 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 = '94529' 21/12/2024 11:29:20 am >> DELETE FROM ps_document_detail WHERE id_document = '94529' 21/12/2024 11:29:20 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 ( '94529' , '20705' , 'CANDELA CUBO' , '1' , '-1' , '1' , '14.7' , '12.049180327869' , '22' , '0' , '14.70' ) 21/12/2024 11:29:20 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 ( '94529' , '23169' , 'DILEXIT NOS ' , '1' , '-1' , '4' , '2.2000' , '2.2' , '0' , '5' , '2.09' ) 21/12/2024 11:29:20 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 ( '94529' , '12817' , 'LIBRO DEI MATRIMONI' , '1' , '-1' , '1' , '40.0000' , '32.786885245902' , '22' , '5' , '38.00' ) 21/12/2024 11:29:20 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 ( '94529' , '939' , 'BAMBINO CM 4 - CARNE - P1' , '13' , '-13' , '1' , '0.3000' , '0.24590163934426' , '22' , '0' , '3.90' ) 21/12/2024 11:29:20 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 ( '94529' , '22911' , 'AGENDA LITURGICO PASTORALE 2025 - 40821' , '1' , '-1' , '1' , '12.0000' , '9.8360655737705' , '22' , '5' , '11.40' ) 21/12/2024 11:29:37 am >> SELECT document_num FROM ps_document WHERE document_num = '3902' AND id_document != '94807' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-12-11') 21/12/2024 11:29:37 am >> UPDATE ps_document SET id_document_type = '11', document_num = '3902', document_date = '2024-12-11', 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 = '135.00', price_tax_excluded = '110.66', date_upd = NOW() WHERE id_document = '94807' 21/12/2024 11:29:37 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 = '94807' 21/12/2024 11:29:37 am >> DELETE FROM ps_document_detail WHERE id_document = '94807' 21/12/2024 11:29:37 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 ( '94807' , '20705' , 'CANDELA CUBO' , '2' , '-2' , '1' , '12.5' , '10.245901639344' , '22' , '0' , '25.00' ) 21/12/2024 11:29:38 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 ( '94807' , '23228' , 'CASULA GIUBILEO RICAMATA - CS64' , '1' , '-1' , '1' , '70.0000' , '57.377049180328' , '22' , '0' , '70.00' ) 21/12/2024 11:29:38 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 ( '94807' , '5976' , 'LUCERNA VETRO - 1493' , '2' , '-2' , '1' , '20.0000' , '16.393442622951' , '22' , '0' , '40.00' ) 21/12/2024 11:29:59 am >> SELECT document_num FROM ps_document WHERE document_num = '4019' AND id_document != '94954' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-12-19') 21/12/2024 11:29:59 am >> UPDATE ps_document SET id_document_type = '11', document_num = '4019', document_date = '2024-12-19', 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 = '130.00', price_tax_excluded = '106.56', date_upd = NOW() WHERE id_document = '94954' 21/12/2024 11:29:59 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 = '94954' 21/12/2024 11:29:59 am >> DELETE FROM ps_document_detail WHERE id_document = '94954' 21/12/2024 11:29:59 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 ( '94954' , '14792' , 'PRESEPE ALABASTRO 1921/22' , '2' , '-2' , '1' , '11.0000' , '9.016393442623' , '22' , '0' , '22.00' ) 21/12/2024 11:29:59 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 ( '94954' , '13299' , 'NATIVITA\' CON LED CM 13 - 30090' , '3' , '-3' , '1' , '10.0000' , '8.1967213114754' , '22' , '0' , '30.00' ) 21/12/2024 11:29:59 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 ( '94954' , '14790' , 'NATIVITA STELLATA 13,5 CM' , '3' , '-3' , '1' , '10.0000' , '8.1967213114754' , '22' , '0' , '30.00' ) 21/12/2024 11:29:59 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 ( '94954' , '15007' , 'PRESEPE LEGNO CON LUCI CM 20 - 31130' , '2' , '-2' , '1' , '10.0000' , '8.1967213114754' , '22' , '0' , '20.00' ) 21/12/2024 11:29:59 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 ( '94954' , '14789' , 'NATIVITA STELLATA 18 CM ' , '1' , '-1' , '1' , '14.0000' , '11.475409836066' , '22' , '0' , '14.00' ) 21/12/2024 11:29:59 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 ( '94954' , '20705' , 'CANDELA CUBO' , '1' , '-1' , '1' , '14' , '11.475409836066' , '22' , '0' , '14.00' ) 21/12/2024 11:30:39 am >> SELECT document_num FROM ps_document WHERE document_num = '4007' AND id_document != '94941' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-12-19') 21/12/2024 11:30:39 am >> UPDATE ps_document SET id_document_type = '11', document_num = '4007', document_date = '2024-12-19', 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 = '1110.00', price_tax_excluded = '917.20', date_upd = NOW() WHERE id_document = '94941' 21/12/2024 11:30: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 = '94941' 21/12/2024 11:30:39 am >> DELETE FROM ps_document_detail WHERE id_document = '94941' 21/12/2024 11:30:39 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 ( '94941' , '23231' , 'CLERGY MISTO ML' , '1' , '-1' , '1' , '30.0000' , '24.590163934426' , '22' , '0' , '30.00' ) 21/12/2024 11:30:39 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 ( '94941' , '18903' , 'TURIBOLO CM 28' , '1' , '-1' , '1' , '187.0000' , '153.27868852459' , '22' , '0' , '187.00' ) 21/12/2024 11:30:39 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 ( '94941' , '21792' , 'BAMBINO CM 60 - PB11786' , '1' , '-1' , '1' , '200.0000' , '163.93442622951' , '22' , '0' , '200.00' ) 21/12/2024 11:30:39 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 ( '94941' , '13565' , 'NAVETTA CLASSICA CM 13' , '1' , '-1' , '1' , '48.0000' , '39.344262295082' , '22' , '0' , '48.00' ) 21/12/2024 11:30:39 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 ( '94941' , '22780' , 'CASULA LANA - 661' , '1' , '-1' , '1' , '578.0000' , '473.77049180328' , '22' , '0' , '578.00' ) 21/12/2024 11:30:39 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 ( '94941' , '23285' , 'CHI E GESU - G. LAJOLO' , '1' , '-1' , '4' , '28.0000' , '28' , '0' , '5' , '26.60' ) 21/12/2024 11:30:39 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 ( '94941' , '22885' , 'MINISTERO DEL CATECHISTA E I MINISTERI LAICALI... ' , '1' , '-1' , '4' , '15.0000' , '15' , '0' , '5' , '14.25' ) 21/12/2024 11:30:40 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 ( '94941' , '20705' , 'CANDELA CUBO' , '1' , '-1' , '1' , '15' , '12.295081967213' , '22' , '0' , '15.00' ) 21/12/2024 11:30:40 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 ( '94941' , '20705' , 'CANDELA CUBO' , '1' , '-1' , '1' , '11.15' , '9.1393442622951' , '22' , '0' , '11.15' ) 21/12/2024 11:31:42 am >> SELECT document_num FROM ps_document WHERE document_num = '4012' AND id_document != '94946' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-12-19') 21/12/2024 11:31:42 am >> UPDATE ps_document SET id_document_type = '11', document_num = '4012', document_date = '2024-12-19', 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 = '14.40', price_tax_excluded = '11.80', date_upd = NOW() WHERE id_document = '94946' 21/12/2024 11:31:42 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 = '94946' 21/12/2024 11:31:42 am >> DELETE FROM ps_document_detail WHERE id_document = '94946' 21/12/2024 11:31:42 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 ( '94946' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '4.4' , '3.6065573770492' , '22' , '0' , '4.40' ) 21/12/2024 11:31:42 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 ( '94946' , '21688' , 'ANGELO PIEGHEVOLE CM 15' , '1' , '-1' , '1' , '10' , '8.1967213114754' , '22' , '0' , '10.00' ) 21/12/2024 11:32:29 am >> SELECT document_num FROM ps_document WHERE document_num = '3966' AND id_document != '94889' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-12-17') 21/12/2024 11:32:29 am >> UPDATE ps_document SET id_document_type = '11', document_num = '3966', document_date = '2024-12-17', 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 = '694.20', price_tax_excluded = '569.02', date_upd = NOW() WHERE id_document = '94889' 21/12/2024 11:32:29 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 = '94889' 21/12/2024 11:32:30 am >> DELETE FROM ps_document_detail WHERE id_document = '94889' 21/12/2024 11:32: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 ( '94889' , '19626' , 'STATUA S .ESPEDITO CM 30 - 642 ' , '1' , '-1' , '1' , '88.0000' , '72.131147540984' , '22' , '0' , '88.00' ) 21/12/2024 11:32: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 ( '94889' , '19107' , 'INCENSO GRANI 3A - BUSTA' , '3' , '-3' , '1' , '30.0000' , '24.590163934426' , '22' , '0' , '90.00' ) 21/12/2024 11:32: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 ( '94889' , '22920' , 'SERVIZIO MESSA GIUBILEO 2025' , '1' , '-1' , '1' , '60.0000' , '49.180327868852' , '22' , '0' , '60.00' ) 21/12/2024 11:32: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 ( '94889' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '8.5' , '6.9672131147541' , '22' , '0' , '8.50' ) 21/12/2024 11:32: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 ( '94889' , '18239' , 'SERVIZIO MESSA - MARIANO M/L - 7051' , '1' , '-1' , '1' , '65.0000' , '53.27868852459' , '22' , '0' , '65.00' ) 21/12/2024 11:32: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 ( '94889' , '18238' , 'SERVIZIO MESSA - M/LINO - 6799' , '1' , '-1' , '1' , '49.9000' , '40.901639344262' , '22' , '0' , '49.90' ) 21/12/2024 11:32: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 ( '94889' , '19087' , 'SERVIZIO MESSA LINO - 74101' , '1' , '-1' , '1' , '68.0000' , '55.737704918033' , '22' , '0' , '68.00' ) 21/12/2024 11:32: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 ( '94889' , '23231' , 'CLERGY MISTO ML' , '1' , '-1' , '1' , '30.0000' , '24.590163934426' , '22' , '0' , '30.00' ) 21/12/2024 11:32: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 ( '94889' , '18237' , 'SERVIZIO MESSA VARI COLORI - 8047' , '2' , '-2' , '1' , '49.9000' , '40.901639344262' , '22' , '0' , '99.80' ) 21/12/2024 11:32: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 ( '94889' , '12749' , 'DALMATICA - 3512/TP' , '1' , '-1' , '1' , '100.0000' , '81.967213114754' , '22' , '0' , '100.00' ) 21/12/2024 11:32: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 ( '94889' , '23226' , 'STOLA GIUBILEO RICAMATA - ST15GBR' , '1' , '-1' , '1' , '35.00' , '28.688524590164' , '22' , '0' , '35.00' ) 21/12/2024 11:38:00 am >> SELECT document_num FROM ps_document WHERE document_num = '4048' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-12-21') 21/12/2024 11:38:00 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' , '4048' , '2024-12-21' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '11.60' , '9.51' , NOW() , NOW() ) 21/12/2024 11:38:00 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 = '94992' 21/12/2024 11:38:00 am >> DELETE FROM ps_document_detail WHERE id_document = '94992' 21/12/2024 11:38:00 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 ( '94992' , '18884' , 'BAMBINELLO CM 10 - PB13627' , '1' , '-1' , '1' , '6.00' , '4.9180327868852' , '22' , '0' , '6.00' ) 21/12/2024 11:38:00 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 ( '94992' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '5.6' , '4.5901639344262' , '22' , '0' , '5.60' ) 21/12/2024 11:58:26 am >> SELECT document_num FROM ps_document WHERE document_num = '139/A' AND id_document != '' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2024-12-21') 21/12/2024 11:58:26 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 ( '24' , '139/A' , '2024-12-21' , 'A' , '0' , '0' , '0' , '' , '' , 'C/ VISIONE DON FRANCO BELLIZZI' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '150.00' , '150.00' , NOW() , NOW() ) 21/12/2024 11:58:26 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 = '94993' 21/12/2024 11:58:26 am >> DELETE FROM ps_document_detail WHERE id_document = '94993' 21/12/2024 11:58: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 ( '94993' , '16686' , 'EVANGELIARIO' , '1' , '-1' , '4' , '150.00' , '150' , '0' , '0' , '150.00' ) 21/12/2024 11:59:30 am >> SELECT document_num FROM ps_document WHERE document_num = '4049' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-12-21') 21/12/2024 11:59:30 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' , '4049' , '2024-12-21' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '130.00' , '108.00' , NOW() , NOW() ) 21/12/2024 11:59: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 = '94994' 21/12/2024 11:59:30 am >> DELETE FROM ps_document_detail WHERE id_document = '94994' 21/12/2024 11:59: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 ( '94994' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '122' , '100' , '22' , '0' , '122.00' ) 21/12/2024 11:59: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 ( '94994' , '23327' , 'ABBIAMO CONOSCIUTO LAMORE' , '1' , '-1' , '4' , '8.00' , '8' , '0' , '0' , '8.00' ) 21/12/2024 12:20:38 pm >> SELECT document_num FROM ps_document WHERE document_num = '4050' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-12-21') 21/12/2024 12:20: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' , '4050' , '2024-12-21' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '35.53' , '32.46' , NOW() , NOW() ) 21/12/2024 12:20: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 = '94995' 21/12/2024 12:20:38 pm >> DELETE FROM ps_document_detail WHERE id_document = '94995' 21/12/2024 12:20: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 ( '94995' , '23045' , 'DIO DEI NOSTRI PADRI - A. CAZZULLO' , '1' , '-1' , '4' , '19.50' , '19.5' , '0' , '5' , '18.53' ) 21/12/2024 12:20: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 ( '94995' , '21790' , 'BAMBINELLO CM 20 - PB16832' , '1' , '-1' , '1' , '17.00' , '13.934426229508' , '22' , '0' , '17.00' ) 21/12/2024 12:27:31 pm >> SELECT document_num FROM ps_document WHERE document_num = '4051' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-12-21') 21/12/2024 12:27:31 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' , '4051' , '2024-12-21' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '4.75' , '4.75' , NOW() , NOW() ) 21/12/2024 12:27:31 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 = '94996' 21/12/2024 12:27:32 pm >> DELETE FROM ps_document_detail WHERE id_document = '94996' 21/12/2024 12:27: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 ( '94996' , '18691' , 'IN_SEGUENDO GESU a emmaus - QUADERNO' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' )