19/10/2024 10:35:16 am >> SELECT document_num FROM ps_document WHERE document_num = '3099' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-10-19') 19/10/2024 10:35:16 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' , '3099' , '2024-10-19' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '25.00' , '25.00' , NOW() , NOW() ) 19/10/2024 10:35:16 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 = '93707' 19/10/2024 10:35:16 am >> DELETE FROM ps_document_detail WHERE id_document = '93707' 19/10/2024 10:35:16 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 ( '93707' , '5762' , 'LEZIONARIO E RITO DEL MATRIMONIO - KIT 2 VOL.' , '1' , '-1' , '4' , '25.00' , '25' , '0' , '0' , '25.00' ) 19/10/2024 10:39:06 am >> SELECT document_num FROM ps_document WHERE document_num = '3100' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-10-19') 19/10/2024 10:39:06 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' , '3100' , '2024-10-19' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '8.90' , '7.30' , NOW() , NOW() ) 19/10/2024 10:39:06 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 = '93708' 19/10/2024 10:39:06 am >> DELETE FROM ps_document_detail WHERE id_document = '93708' 19/10/2024 10:39:06 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 ( '93708' , '11384' , 'VINO BIANCO DOLCE - 102' , '1' , '-1' , '1' , '8.90' , '7.2950819672131' , '22' , '0' , '8.90' ) 19/10/2024 10:41:50 am >> SELECT document_num FROM ps_document WHERE document_num = '3101' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-10-19') 19/10/2024 10:41:50 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' , '3101' , '2024-10-19' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '9.00' , '8.65' , NOW() , NOW() ) 19/10/2024 10:41:50 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 = '93709' 19/10/2024 10:41:50 am >> DELETE FROM ps_document_detail WHERE id_document = '93709' 19/10/2024 10:41:50 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 ( '93709' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '2' , '-2' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '7.00' ) 19/10/2024 10:41:50 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 ( '93709' , '7311' , 'OSTIA SOTTILE 74MM' , '1' , '-1' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '2.00' ) 19/10/2024 10:52:33 am >> SELECT document_num FROM ps_document WHERE document_num = '3102' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-10-19') 19/10/2024 10:52:33 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' , '3102' , '2024-10-19' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '145.00' , '123.36' , NOW() , NOW() ) 19/10/2024 10:52:33 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 = '93710' 19/10/2024 10:52:33 am >> DELETE FROM ps_document_detail WHERE id_document = '93710' 19/10/2024 10:52:33 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 ( '93710' , '5762' , 'LEZIONARIO E RITO DEL MATRIMONIO - KIT 2 VOL.' , '1' , '-1' , '4' , '25.00' , '25' , '0' , '0' , '25.00' ) 19/10/2024 10:52:33 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 ( '93710' , '14389' , 'CAMICE MISTO COTONE - COLLO QUADRO - 446TCAQ' , '1' , '-1' , '1' , '120' , '98.360655737705' , '22' , '0' , '120.00' ) 19/10/2024 10:57:23 am >> SELECT document_num FROM ps_document WHERE document_num = '3103' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-10-19') 19/10/2024 10:57:23 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' , '3103' , '2024-10-19' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '19.41' , '19.41' , NOW() , NOW() ) 19/10/2024 10:57: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 = '93711' 19/10/2024 10:57:23 am >> DELETE FROM ps_document_detail WHERE id_document = '93711' 19/10/2024 10:57: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 ( '93711' , '18163' , 'GIOCO DELLE PAROLE DI DIO' , '1' , '-1' , '4' , '10.00' , '10' , '0' , '0' , '10.00' ) 19/10/2024 10:57: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 ( '93711' , '18110' , 'ATLANTE STORICO GEOGRAFICO DELLA BIBBIA' , '1' , '-1' , '4' , '9.90' , '9.9' , '0' , '5' , '9.41' ) 19/10/2024 11:09:05 am >> SELECT document_num FROM ps_document WHERE document_num = '3104' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-10-19') 19/10/2024 11:09:05 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' , '3104' , '2024-10-19' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '6.45' , '5.67' , NOW() , NOW() ) 19/10/2024 11:09:05 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 = '93712' 19/10/2024 11:09:05 am >> DELETE FROM ps_document_detail WHERE id_document = '93712' 19/10/2024 11:09:05 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 ( '93712' , '4223' , 'FOGLIETTI LA DOMENICA SAN PAOLO' , '3' , '-3' , '4' , '0.70' , '0.7' , '0' , '0' , '2.10' ) 19/10/2024 11:09:05 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 ( '93712' , '19468' , 'CORONA DELLE ROSE BIGLIETTO - 31111' , '1' , '-1' , '1' , '0.20' , '0.16393442622951' , '22' , '0' , '0.20' ) 19/10/2024 11:09:05 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 ( '93712' , '17006' , 'SEGNALIBRO PR' , '4' , '-4' , '1' , '0.40' , '0.32786885245902' , '22' , '0' , '1.60' ) 19/10/2024 11:09:05 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 ( '93712' , '10145' , 'SPIRITO SANTO - 263 ' , '1' , '-1' , '1' , '0.15' , '0.12295081967213' , '22' , '0' , '0.15' ) 19/10/2024 11:09:05 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 ( '93712' , '20758' , 'SEGNALIBRO 5X15' , '8' , '-8' , '1' , '0.20' , '0.16393442622951' , '22' , '0' , '1.60' ) 19/10/2024 11:09:05 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 ( '93712' , '17004' , 'BIGLIETTO AUGURALE PICCOLO' , '1' , '-1' , '1' , '0.80' , '0.65573770491803' , '22' , '0' , '0.80' ) 19/10/2024 11:13:38 am >> SELECT document_num FROM ps_document WHERE document_num = '3105' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-10-19') 19/10/2024 11:13:38 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' , '3105' , '2024-10-19' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '40.00' , '40.00' , NOW() , NOW() ) 19/10/2024 11:13:38 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 = '93713' 19/10/2024 11:13:38 am >> DELETE FROM ps_document_detail WHERE id_document = '93713' 19/10/2024 11:13: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 ( '93713' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '40' , '40' , '0' , '0' , '40.00' ) 19/10/2024 11:20:05 am >> SELECT document_num FROM ps_document WHERE document_num = '3106' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-10-19') 19/10/2024 11:20:05 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' , '3106' , '2024-10-19' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '98.00' , '80.33' , NOW() , NOW() ) 19/10/2024 11:20:05 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 = '93714' 19/10/2024 11:20:05 am >> DELETE FROM ps_document_detail WHERE id_document = '93714' 19/10/2024 11:20:05 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 ( '93714' , '23052' , 'DALMATICA MORELLO' , '1' , '-1' , '1' , '98' , '80.327868852459' , '22' , '0' , '98.00' ) 19/10/2024 11:41:25 am >> SELECT document_num FROM ps_document WHERE document_num = '3107' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-10-19') 19/10/2024 11:41: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' , '3107' , '2024-10-19' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '300.00' , '246.84' , NOW() , NOW() ) 19/10/2024 11:41: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 = '93715' 19/10/2024 11:41:25 am >> DELETE FROM ps_document_detail WHERE id_document = '93715' 19/10/2024 11:41: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 ( '93715' , '14725' , 'STOLA LANA/SETA/VISC. - ART. 1125' , '2' , '-2' , '1' , '130.39' , '106.87704918033' , '22' , '0' , '260.78' ) 19/10/2024 11:41: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 ( '93715' , '14114' , 'CINGOLO ORO - CING08ORO' , '1' , '-1' , '1' , '34.00' , '27.868852459016' , '22' , '0' , '34.00' ) 19/10/2024 11:41: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 ( '93715' , '5559' , 'LASCIATE CHE I BAMBINI VENGANO A ME' , '1' , '-1' , '4' , '5.22' , '5.22' , '0' , '' , '5.22' ) 19/10/2024 11:45:41 am >> SELECT document_num FROM ps_document WHERE document_num = '165' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2024-10-19') 19/10/2024 11:45:41 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 ( '21' , '165' , '2024-10-19' , '' , '2843' , '0' , '4673405' , 'V. PICENZA, 63 BIS 84131 SALERNO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '1' , '0' , '91.43' , '89.63' , NOW() , NOW() ) 19/10/2024 11:45:41 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 = '93716' 19/10/2024 11:45:41 am >> DELETE FROM ps_document_detail WHERE id_document = '93716' 19/10/2024 11:45:41 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 ( '93716' , '12819' , 'REGISTRO DEL CATECHISTA ' , '10' , '-10' , '1' , '1.00' , '0.81967213114754' , '22' , '0' , '10.00' ) 19/10/2024 11:45:41 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 ( '93716' , '8488' , 'PRIMA CONFESSIONE E MESSA PRIMA COMUNIONE' , '2' , '-2' , '4' , '2.40' , '2.4' , '0' , '15' , '4.08' ) 19/10/2024 11:45:41 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 ( '93716' , '5458' , 'IO SONO CON VOI 2 PARTE' , '10' , '-10' , '4' , '2.80' , '2.8' , '0' , '15' , '23.80' ) 19/10/2024 11:45:41 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 ( '93716' , '5457' , 'IO SONO CON VOI 1 PARTE' , '10' , '-10' , '4' , '2.80' , '2.8' , '0' , '15' , '23.80' ) 19/10/2024 11:45:41 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 ( '93716' , '2679' , 'CONOSCERE GESU' , '10' , '-10' , '4' , '3.50' , '3.5' , '0' , '15' , '29.75' ) 19/10/2024 11:50:24 am >> SELECT document_num FROM ps_document WHERE document_num = '3108' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-10-19') 19/10/2024 11:50:24 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' , '3108' , '2024-10-19' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '33.57' , '27.52' , NOW() , NOW() ) 19/10/2024 11:50: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 = '93717' 19/10/2024 11:50:24 am >> DELETE FROM ps_document_detail WHERE id_document = '93717' 19/10/2024 11:50: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 ( '93717' , '19100' , 'INCENSO B' , '1' , '-1' , '1' , '33.57' , '27.516393442623' , '22' , '0' , '33.57' ) 19/10/2024 12:06:32 pm >> SELECT document_num FROM ps_document WHERE document_num = '3109' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-10-19') 19/10/2024 12:06: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' , '3109' , '2024-10-19' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '96.37' , '95.93' , NOW() , NOW() ) 19/10/2024 12:06: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 = '93718' 19/10/2024 12:06:32 pm >> DELETE FROM ps_document_detail WHERE id_document = '93718' 19/10/2024 12:06: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 ( '93718' , '21058' , 'ALLA SCOPERTA DEI SETTE DONI DELLO SPIRITO SANTO' , '1' , '-1' , '4' , '2.50' , '2.5' , '0' , '5' , '2.38' ) 19/10/2024 12:06: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 ( '93718' , '19977' , 'MINISTRANTI IERI, OGGI, DOMANI' , '1' , '-1' , '4' , '2.50' , '2.5' , '0' , '5' , '2.38' ) 19/10/2024 12:06: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 ( '93718' , '17163' , 'SPIRITO SANTO SPIEGATO AI RAGAZZI' , '1' , '-1' , '4' , '2.50' , '2.5' , '0' , '5' , '2.38' ) 19/10/2024 12:06: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 ( '93718' , '4120' , 'FEDE NELLO ZAINETTO' , '1' , '-1' , '4' , '6.00' , '6' , '0' , '5' , '5.70' ) 19/10/2024 12:06: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 ( '93718' , '9675' , 'SARETE MIEI TESTIMONI' , '1' , '-1' , '4' , '3.50' , '3.5' , '0' , '5' , '3.33' ) 19/10/2024 12:06: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 ( '93718' , '10740' , 'TROPPO FORTE - 1/ IL DECOLLO' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' ) 19/10/2024 12:06: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 ( '93718' , '21437' , 'IMPRONTE DI MISERICORDIA - CALENDALBUM 2 - N.E.' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' ) 19/10/2024 12:06: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 ( '93718' , '22804' , 'PANE E VINO - N.E. - SUSSIDIO' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' ) 19/10/2024 12:06: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 ( '93718' , '1882' , 'CELEBRAZIONI PER LANNO CATECHISTICO' , '1' , '-1' , '4' , '10.00' , '10' , '0' , '5' , '9.50' ) 19/10/2024 12:06: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 ( '93718' , '19936' , 'SANTI PER IL CATECHISMO' , '1' , '-1' , '4' , '9.90' , '9.9' , '0' , '0' , '9.90' ) 19/10/2024 12:06: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 ( '93718' , '18564' , 'CONNESSI CON GESU’ - AGENDUM 2' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' ) 19/10/2024 12:06: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 ( '93718' , '8601' , 'SARETE MIEI TESTIMONI 2 - MAGNIFICAT' , '1' , '-1' , '4' , '3.00' , '3' , '0' , '5' , '2.85' ) 19/10/2024 12:06: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 ( '93718' , '9681' , 'SARETE MIEI TESTIMONI - GUIDA 2 - MAGNIFICAT' , '1' , '-1' , '4' , '12.00' , '12' , '0' , '5' , '11.40' ) 19/10/2024 12:06: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 ( '93718' , '23035' , 'PADRE NOSTRO - SPARTITO' , '1' , '-1' , '3' , '12.00' , '11.538461538462' , '4' , '5' , '11.40' ) 19/10/2024 12:06: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 ( '93718' , '13780' , 'RISCOPRIAMO LA BELLEZZA DEL BATTESIMO' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' ) 19/10/2024 12:06: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 ( '93718' , '5176' , 'IN COPPIA CON DIO - P. CURTAZ' , '1' , '-1' , '4' , '12.00' , '12' , '0' , '5' , '11.40' ) 19/10/2024 12:37:51 pm >> SELECT document_num FROM ps_document WHERE document_num = '3110' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-10-19') 19/10/2024 12:37:51 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' , '3110' , '2024-10-19' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '8.90' , '7.30' , NOW() , NOW() ) 19/10/2024 12:37:51 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 = '93719' 19/10/2024 12:37:51 pm >> DELETE FROM ps_document_detail WHERE id_document = '93719' 19/10/2024 12:37:51 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 ( '93719' , '11389' , 'VINO ROSSO DOLCE - 103' , '1' , '-1' , '1' , '8.90' , '7.2950819672131' , '22' , '0' , '8.90' ) 19/10/2024 12:47:28 pm >> SELECT document_num FROM ps_document WHERE document_num = '3111' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-10-19') 19/10/2024 12:47:28 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' , '3111' , '2024-10-19' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '38.50' , '37.02' , NOW() , NOW() ) 19/10/2024 12:47:28 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 = '93720' 19/10/2024 12:47:28 pm >> DELETE FROM ps_document_detail WHERE id_document = '93720' 19/10/2024 12:47:28 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 ( '93720' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '11' , '-11' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '38.50' )