21/03/2024 08:35:38 am >> SELECT document_num FROM ps_document WHERE document_num = '356' AND id_document != '90226' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-02-03') 21/03/2024 08:35:38 am >> UPDATE ps_document SET id_document_type = '11', document_num = '356', document_date = '2024-02-03', 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 = '495.00', price_tax_excluded = '405.74', date_upd = NOW() WHERE id_document = '90226' 21/03/2024 08:35: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 = '90226' 21/03/2024 08:35:38 am >> DELETE FROM ps_document_detail WHERE id_document = '90226' 21/03/2024 08:35: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 ( '90226' , '19706' , 'PALLA 75/1634' , '1' , '-1' , '1' , '89.0000' , '72.950819672131' , '22' , '0' , '89.00' ) 21/03/2024 08:35: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 ( '90226' , '13159' , 'CASULA MOD. 3 CROCI' , '1' , '-1' , '1' , '240.0000' , '196.72131147541' , '22' , '0' , '240.00' ) 21/03/2024 08:35: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 ( '90226' , '13544' , 'SCATOLINA CORONCINA CONFESSIONE - 2361/J10' , '11' , '-11' , '1' , '3.3000' , '2.7049180327869' , '22' , '0' , '36.30' ) 21/03/2024 08:35: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 ( '90226' , '14949' , 'STOLA MISTO SETA LUREX - ART 1020' , '1' , '-1' , '1' , '129.7' , '106.31147540984' , '22' , '0' , '129.70' ) 21/03/2024 08:36:23 am >> SELECT document_num FROM ps_document WHERE document_num = '381' AND id_document != '90262' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-02-06') 21/03/2024 08:36:23 am >> UPDATE ps_document SET id_document_type = '11', document_num = '381', document_date = '2024-02-06', 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 = '190.80', price_tax_excluded = '160.34', date_upd = NOW() WHERE id_document = '90262' 21/03/2024 08:36: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 = '90262' 21/03/2024 08:36:23 am >> DELETE FROM ps_document_detail WHERE id_document = '90262' 21/03/2024 08:36: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 ( '90262' , '7311' , 'OSTIA SOTTILE 74MM' , '3' , '-3' , '3' , '2.0000' , '1.9230769230769' , '4' , '0' , '6.00' ) 21/03/2024 08:36: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 ( '90262' , '16691' , 'PARTICOLE PER CELIACI 25pz' , '1' , '-1' , '3' , '4.3000' , '4.1346153846154' , '4' , '0' , '4.30' ) 21/03/2024 08:36: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 ( '90262' , '20433' , 'PARTICOLA MORREALE 38MM - PTC38S' , '5' , '-5' , '3' , '3.5000' , '3.3653846153846' , '4' , '0' , '17.50' ) 21/03/2024 08:36: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 ( '90262' , '1710' , 'CARBONCINI PER TURIBOLO BIANCHI - PZ 120' , '1' , '-1' , '1' , '13.0000' , '10.655737704918' , '22' , '0' , '13.00' ) 21/03/2024 08:36: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 ( '90262' , '5903' , 'LITURGICO ART. 60LT ROSSO SUPER' , '7' , '-7' , '1' , '3' , '2.4590163934426' , '22' , '0' , '21.00' ) 21/03/2024 08:36: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 ( '90262' , '14949' , 'STOLA MISTO SETA LUREX - ART 1020' , '1' , '-1' , '1' , '129' , '105.73770491803' , '22' , '0' , '129.00' ) 21/03/2024 08:38:17 am >> SELECT document_num FROM ps_document WHERE document_num = '751' AND id_document != '90758' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-03-14') 21/03/2024 08:38:17 am >> UPDATE ps_document SET id_document_type = '11', document_num = '751', document_date = '2024-03-14', 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 = '260.00', price_tax_excluded = '213.11', date_upd = NOW() WHERE id_document = '90758' 21/03/2024 08:38: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 = '90758' 21/03/2024 08:38:17 am >> DELETE FROM ps_document_detail WHERE id_document = '90758' 21/03/2024 08:38: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 ( '90758' , '22317' , 'CASULA PERSONALIZZATA' , '2' , '-2' , '1' , '100' , '81.967213114754' , '22' , '0' , '200.00' ) 21/03/2024 08:38: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 ( '90758' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '60' , '49.180327868852' , '22' , '0' , '60.00' ) 21/03/2024 09:12:43 am >> SELECT document_num FROM ps_document WHERE document_num = '838' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-03-21') 21/03/2024 09:12:43 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' , '838' , '2024-03-21' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '18.00' , '18.00' , NOW() , NOW() ) 21/03/2024 09:12:43 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 = '90869' 21/03/2024 09:12:43 am >> DELETE FROM ps_document_detail WHERE id_document = '90869' 21/03/2024 09:12:43 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 ( '90869' , '20778' , 'PASSIO N.E.' , '3' , '-3' , '4' , '6.00' , '6' , '0' , '0' , '18.00' ) 21/03/2024 09:20:16 am >> SELECT document_num FROM ps_document WHERE document_num = '13/A' AND id_document != '90153' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2024-01-30') 21/03/2024 09:20:16 am >> UPDATE ps_document SET id_document_type = '24', document_num = '13/A', document_date = '2024-01-30', document_letter = 'A', id_customer = '2332', id_supplier = '', id_address = '4679092', address1 = 'P.ZZA S. ROCCO 84088 SIANO', 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 = '425.85', price_tax_excluded = '356.42', date_upd = NOW() WHERE id_document = '90153' 21/03/2024 09:20: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 = '90153' 21/03/2024 09:20:16 am >> DELETE FROM ps_document_detail WHERE id_document = '90153' 21/03/2024 09:20: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 ( '90153' , '14362' , 'CAMICE SVASATO - 434/TPA' , '1' , '-1' , '1' , '65.0000' , '53.27868852459' , '22' , '0' , '65.00' ) 21/03/2024 09:20: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 ( '90153' , '20791' , 'BOTTIGLIE PER ACQUA BENEDETTA - CONF. 100 PZ' , '10' , '-10' , '1' , '22.0000' , '18.032786885246' , '22' , '0' , '220.00' ) 21/03/2024 09:20: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 ( '90153' , '19107' , 'INCENSO GRANI 3A - BUSTA' , '1' , '-1' , '1' , '30.0000' , '24.590163934426' , '22' , '0' , '30.00' ) 21/03/2024 09:20: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 ( '90153' , '1626' , 'CANDELE VOTIVE KG 10 - 13X26 - CIRCA 300 PZ' , '1' , '-1' , '1' , '70.0000' , '57.377049180328' , '22' , '0' , '70.00' ) 21/03/2024 09:20: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 ( '90153' , '22281' , 'CARDIOLOGO VISITA GESU - F. SERAFINI' , '1' , '-1' , '4' , '23.0000' , '23' , '0' , '5' , '21.85' ) 21/03/2024 09:20: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 ( '90153' , '18289' , 'SANTA MESSA DEGLI SPOSI - N.E.' , '10' , '-10' , '4' , '1.90' , '1.9' , '0' , '0' , '19.00' ) 21/03/2024 09:41:04 am >> SELECT document_num FROM ps_document WHERE document_num = '839' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-03-21') 21/03/2024 09:41:04 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' , '839' , '2024-03-21' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '17.10' , '17.10' , NOW() , NOW() ) 21/03/2024 09:41:04 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 = '90870' 21/03/2024 09:41:04 am >> DELETE FROM ps_document_detail WHERE id_document = '90870' 21/03/2024 09:41:04 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 ( '90870' , '22224' , 'PASSIONE DI NOSTRO SIGNORE GESU CRISTO' , '3' , '-3' , '4' , '6.00' , '6' , '0' , '5' , '17.10' ) 21/03/2024 10:02:32 am >> SELECT document_num FROM ps_document WHERE document_num = '840' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-03-21') 21/03/2024 10:02: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' , '840' , '2024-03-21' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '214.38' , '196.98' , NOW() , NOW() ) 21/03/2024 10:02: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 = '90871' 21/03/2024 10:02:32 am >> DELETE FROM ps_document_detail WHERE id_document = '90871' 21/03/2024 10:02: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 ( '90871' , '22290' , 'CHIESA IN PREGHIERA' , '1' , '-1' , '4' , '8.50' , '8.5' , '0' , '5' , '8.08' ) 21/03/2024 10:02: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 ( '90871' , '1090' , 'BIBBIA' , '10' , '-10' , '4' , '9.90' , '9.9' , '0' , '5' , '94.10' ) 21/03/2024 10:02: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 ( '90871' , '16834' , 'LITURGICO CARTA 8GG' , '24' , '-24' , '1' , '3.3' , '2.7049180327869' , '22' , '0' , '79.20' ) 21/03/2024 10:02: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 ( '90871' , '19102' , 'CARBONCINI MM 40' , '1' , '-1' , '1' , '13.00' , '10.655737704918' , '22' , '0' , '13.00' ) 21/03/2024 10:02: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 ( '90871' , '16689' , 'OSTIA PAN DI CENA mm80' , '10' , '-10' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '20.00' ) 21/03/2024 10:06:30 am >> SELECT document_num FROM ps_document WHERE document_num = '841' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-03-21') 21/03/2024 10:06: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' , '841' , '2024-03-21' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '3' , '0' , '529.00' , '433.61' , NOW() , NOW() ) 21/03/2024 10:06: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 = '90872' 21/03/2024 10:06:30 am >> DELETE FROM ps_document_detail WHERE id_document = '90872' 21/03/2024 10:06: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 ( '90872' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '529' , '433.60655737705' , '22' , '0' , '529.00' ) 21/03/2024 10:44:00 am >> SELECT document_num FROM ps_document WHERE document_num = '842' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-03-21') 21/03/2024 10:44: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' , '842' , '2024-03-21' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '22.00' , '18.03' , NOW() , NOW() ) 21/03/2024 10:44: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 = '90873' 21/03/2024 10:44:00 am >> DELETE FROM ps_document_detail WHERE id_document = '90873' 21/03/2024 10:44: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 ( '90873' , '1427' , 'BUSTE PER PALMA BENEDETTA - PZ 200 ' , '2' , '-2' , '1' , '11.00' , '9.016393442623' , '22' , '0' , '22.00' ) 21/03/2024 11:10:50 am >> SELECT document_num FROM ps_document WHERE document_num = '843' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-03-21') 21/03/2024 11:10: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' , '843' , '2024-03-21' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '30.00' , '30.00' , NOW() , NOW() ) 21/03/2024 11:10: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 = '90874' 21/03/2024 11:10:50 am >> DELETE FROM ps_document_detail WHERE id_document = '90874' 21/03/2024 11:10: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 ( '90874' , '11151' , 'LIBRI' , '2' , '-2' , '4' , '15' , '15' , '0' , '0' , '30.00' ) 21/03/2024 11:51:48 am >> SELECT document_num FROM ps_document WHERE document_num = '844' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-03-21') 21/03/2024 11:51:48 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' , '844' , '2024-03-21' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '25.00' , '24.60' , NOW() , NOW() ) 21/03/2024 11:51:48 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 = '90875' 21/03/2024 11:51:48 am >> DELETE FROM ps_document_detail WHERE id_document = '90875' 21/03/2024 11:51:48 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 ( '90875' , '7703' , 'PASSIONE DI NOSTRO SIGNORE' , '3' , '-3' , '4' , '8.00' , '8' , '0' , '5' , '22.80' ) 21/03/2024 11:51:48 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 ( '90875' , '18122' , 'ROCCA STOPPINO M. 100 - 469/100' , '2' , '-2' , '1' , '1.10' , '0.9016393442623' , '22' , '0' , '2.20' ) 21/03/2024 11:58:58 am >> SELECT document_num FROM ps_document WHERE document_num = '845' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-03-21') 21/03/2024 11:58: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' , '845' , '2024-03-21' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '18.00' , '14.75' , NOW() , NOW() ) 21/03/2024 11:58: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 = '90876' 21/03/2024 11:58:58 am >> DELETE FROM ps_document_detail WHERE id_document = '90876' 21/03/2024 11:58: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 ( '90876' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '18' , '14.754098360656' , '22' , '0' , '18.00' ) 21/03/2024 12:30:47 pm >> SELECT document_num FROM ps_document WHERE document_num = '846' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-03-21') 21/03/2024 12:30:47 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' , '846' , '2024-03-21' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '19.60' , '16.07' , NOW() , NOW() ) 21/03/2024 12:30:47 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 = '90877' 21/03/2024 12:30:47 pm >> DELETE FROM ps_document_detail WHERE id_document = '90877' 21/03/2024 12:30:47 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 ( '90877' , '1914' , 'CERA DELLA LITURGIA' , '4' , '-4' , '1' , '4.90' , '4.016393442623' , '22' , '0' , '19.60' ) 21/03/2024 01:02:52 pm >> SELECT document_num FROM ps_document WHERE document_num = '847' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-03-21') 21/03/2024 01:02:52 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' , '847' , '2024-03-21' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '87.60' , '71.80' , NOW() , NOW() ) 21/03/2024 01:02:52 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 = '90878' 21/03/2024 01:02:52 pm >> DELETE FROM ps_document_detail WHERE id_document = '90878' 21/03/2024 01:02:52 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 ( '90878' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '35' , '28.688524590164' , '22' , '0' , '35.00' ) 21/03/2024 01:02:52 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 ( '90878' , '20791' , 'BOTTIGLIE PER ACQUA BENEDETTA - CONF. 100 PZ' , '2' , '-2' , '1' , '25.00' , '20.491803278689' , '22' , '0' , '50.00' ) 21/03/2024 01:02:52 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 ( '90878' , '14773' , 'BRACCIALE RIGATO - 0825N' , '2' , '-2' , '1' , '1.30' , '1.0655737704918' , '22' , '0' , '2.60' ) 21/03/2024 03:19:17 pm >> SELECT document_num FROM ps_document WHERE document_num = '411' AND id_document != '90304' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-02-09') 21/03/2024 03:19:17 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '411', document_date = '2024-02-09', 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 = '315.00', price_tax_excluded = '261.25', date_upd = NOW() WHERE id_document = '90304' 21/03/2024 03:19:17 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 = '90304' 21/03/2024 03:19:17 pm >> DELETE FROM ps_document_detail WHERE id_document = '90304' 21/03/2024 03:19:17 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 ( '90304' , '12816' , 'LIBRO DEI DEFUNTI' , '1' , '-1' , '1' , '40.0000' , '32.786885245902' , '22' , '10' , '36.00' ) 21/03/2024 03:19:17 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 ( '90304' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '5' , '-5' , '3' , '3.5000' , '3.3653846153846' , '4' , '0' , '17.50' ) 21/03/2024 03:19:17 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 ( '90304' , '16689' , 'OSTIA PAN DI CENA mm80' , '2' , '-2' , '3' , '2.0000' , '1.9230769230769' , '4' , '0' , '4.00' ) 21/03/2024 03:19:17 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 ( '90304' , '5903' , 'LITURGICO ART. 60LT ROSSO SUPER' , '30' , '-30' , '1' , '3.0000' , '2.4590163934426' , '22' , '0' , '90.00' ) 21/03/2024 03:19:17 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 ( '90304' , '17160' , 'CARBONCINI ROSSI - CARRO' , '1' , '-1' , '1' , '10.0000' , '8.1967213114754' , '22' , '0' , '10.00' ) 21/03/2024 03:19:17 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 ( '90304' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '4.8' , '3.9344262295082' , '22' , '0' , '4.80' ) 21/03/2024 03:19:17 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 ( '90304' , '18770' , 'STOLA DIACONALE MARIANA - 36006' , '1' , '-1' , '1' , '140.0000' , '114.75409836066' , '22' , '0' , '140.00' ) 21/03/2024 03:19:17 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 ( '90304' , '13110' , 'S. PAOLO BABY - 023 SGD 9 BB' , '1' , '-1' , '1' , '9.00' , '7.3770491803279' , '22' , '0' , '9.00' ) 21/03/2024 03:19:17 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 ( '90304' , '15403' , 'CROCE IN RESINA CM 9 - 3806/G052' , '1' , '-1' , '1' , '3.70' , '3.0327868852459' , '22' , '0' , '3.70' ) 21/03/2024 03:41:31 pm >> SELECT document_num FROM ps_document WHERE document_num = '848' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-03-21') 21/03/2024 03:41: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' , '848' , '2024-03-21' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '9.50' , '9.50' , NOW() , NOW() ) 21/03/2024 03:41: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 = '90879' 21/03/2024 03:41:31 pm >> DELETE FROM ps_document_detail WHERE id_document = '90879' 21/03/2024 03:41: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 ( '90879' , '18529' , 'SAN CESARE DE BUS - FUMETTO' , '2' , '-2' , '4' , '5.00' , '5' , '0' , '5' , '9.50' ) 21/03/2024 03:44:55 pm >> SELECT document_num FROM ps_document WHERE document_num = '39/A' AND id_document != '' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2024-03-21') 21/03/2024 03:44:55 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 ( '24' , '39/A' , '2024-03-21' , 'A' , '3865' , '0' , '4673708' , 'VIA CROCE 1 - FRAZ. SALITTO 84062 OLEVANO SUL TUSCIANO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '173.00' , '141.80' , NOW() , NOW() ) 21/03/2024 03:44:55 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 = '90880' 21/03/2024 03:44:55 pm >> DELETE FROM ps_document_detail WHERE id_document = '90880' 21/03/2024 03:44:55 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 ( '90880' , '1544' , 'CAMICE RAGLAN - CM 150 - ART.54' , '1' , '-1' , '1' , '45' , '36.885245901639' , '22' , '0' , '45.00' ) 21/03/2024 03:44:55 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 ( '90880' , '7202' , 'ARTICOLI RELIGIOSI' , '2' , '-2' , '1' , '45' , '36.885245901639' , '22' , '0' , '90.00' ) 21/03/2024 03:44:55 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 ( '90880' , '12202' , 'VETRO ANTIVENTO PER F. CAND. DIAM. 4 - 73/40' , '2' , '-2' , '1' , '19.00' , '15.573770491803' , '22' , '0' , '38.00' ) 21/03/2024 05:10:59 pm >> SELECT document_num FROM ps_document WHERE document_num = '849' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-03-21') 21/03/2024 05:10:59 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' , '849' , '2024-03-21' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '19.95' , '19.95' , NOW() , NOW() ) 21/03/2024 05:10:59 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 = '90881' 21/03/2024 05:10:59 pm >> DELETE FROM ps_document_detail WHERE id_document = '90881' 21/03/2024 05:10:59 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 ( '90881' , '7704' , 'PASSIONE DI NOSTRO SIGNORE GESÙ CRISTO - 8671' , '3' , '-3' , '4' , '7.00' , '7' , '0' , '5' , '19.95' ) 21/03/2024 06:01:37 pm >> SELECT document_num FROM ps_document WHERE document_num = '850' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-03-21') 21/03/2024 06:01:37 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' , '850' , '2024-03-21' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '7.20' , '5.90' , NOW() , NOW() ) 21/03/2024 06:01:37 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 = '90882' 21/03/2024 06:01:37 pm >> DELETE FROM ps_document_detail WHERE id_document = '90882' 21/03/2024 06:01:37 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 ( '90882' , '17617' , 'IMMAGINI ISONZO X 100' , '2' , '-2' , '1' , '3.60' , '2.9508196721311' , '22' , '0' , '7.20' ) 21/03/2024 06:34:02 pm >> SELECT document_num FROM ps_document WHERE document_num = '39/A' AND id_document != '90880' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2024-03-21') 21/03/2024 06:34:02 pm >> UPDATE ps_document SET id_document_type = '24', document_num = '39/A', document_date = '2024-03-21', document_letter = 'A', id_customer = '3865', id_supplier = '', id_address = '4673708', address1 = 'VIA CROCE 1 - FRAZ. SALITTO 84062 OLEVANO SUL TUSCIANO', 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 = '178.00', price_tax_excluded = '146.80', date_upd = NOW() WHERE id_document = '90880' 21/03/2024 06:34: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 = '90880' 21/03/2024 06:34:02 pm >> DELETE FROM ps_document_detail WHERE id_document = '90880' 21/03/2024 06:34: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 ( '90880' , '1544' , 'CAMICE RAGLAN - CM 150 - ART.54' , '1' , '-1' , '1' , '45.0000' , '36.885245901639' , '22' , '0' , '45.00' ) 21/03/2024 06:34: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 ( '90880' , '7202' , 'ARTICOLI RELIGIOSI' , '2' , '-2' , '1' , '45.0000' , '36.885245901639' , '22' , '0' , '90.00' ) 21/03/2024 06:34: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 ( '90880' , '12202' , 'VETRO ANTIVENTO PER F. CAND. DIAM. 4 - 73/40' , '2' , '-2' , '1' , '19.0000' , '15.573770491803' , '22' , '0' , '38.00' ) 21/03/2024 06:34: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 ( '90880' , '22023' , 'SULLA TUA PAROLA - MAR/APR 2024 - 521' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '0' , '5.00' ) 21/03/2024 06:45:35 pm >> SELECT document_num FROM ps_document WHERE document_num = '57' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2024-03-21') 21/03/2024 06: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 ( '21' , '57' , '2024-03-21' , '' , '3029' , '0' , '4669124' , 'VIA G. AMENDOLA, 94 84084 PENTA DI FISCIANO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '160.00' , '131.15' , NOW() , NOW() ) 21/03/2024 06: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 = '90883' 21/03/2024 06:45:35 pm >> DELETE FROM ps_document_detail WHERE id_document = '90883' 21/03/2024 06: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 ( '90883' , '15210' , 'CERO PASQUALE API 80X120' , '1' , '-1' , '1' , '160' , '131.14754098361' , '22' , '0' , '160.00' ) 21/03/2024 07:29:30 pm >> SELECT document_num FROM ps_document WHERE document_num = '851' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-03-21') 21/03/2024 07:29:30 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' , '851' , '2024-03-21' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '180.00' , '147.54' , NOW() , NOW() ) 21/03/2024 07:29: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 = '90884' 21/03/2024 07:29:30 pm >> DELETE FROM ps_document_detail WHERE id_document = '90884' 21/03/2024 07:29: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 ( '90884' , '15210' , 'CERO PASQUALE API 80X120' , '1' , '-1' , '1' , '140' , '114.75409836066' , '22' , '0' , '140.00' ) 21/03/2024 07:29: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 ( '90884' , '20791' , 'BOTTIGLIE PER ACQUA BENEDETTA - CONF. 100 PZ' , '1' , '-1' , '1' , '25.00' , '20.491803278689' , '22' , '0' , '25.00' ) 21/03/2024 07:29: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 ( '90884' , '1041' , 'BENEDIZIONI' , '100' , '-100' , '1' , '0.15' , '0.12295081967213' , '22' , '0' , '15.00' ) 21/03/2024 07:55:44 pm >> SELECT document_num FROM ps_document WHERE document_num = '852' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-03-21') 21/03/2024 07:55:44 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' , '852' , '2024-03-21' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '140.00' , '114.75' , NOW() , NOW() ) 21/03/2024 07:55:44 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 = '90885' 21/03/2024 07:55:44 pm >> DELETE FROM ps_document_detail WHERE id_document = '90885' 21/03/2024 07:55:44 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 ( '90885' , '15210' , 'CERO PASQUALE API 80X120' , '1' , '-1' , '1' , '140' , '114.75409836066' , '22' , '0' , '140.00' )