20/05/2025 08: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 ( '31' , '705' , '2025-05-17' , '' , '0' , '36' , '2631' , 'VIA FRIZZONI,56 24048 TREVIOLO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '9' , '0' , '1562.09' , '1280.40' , NOW() , NOW() ) 20/05/2025 08: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 = '97278' 20/05/2025 08:35:16 am >> DELETE FROM ps_document_detail WHERE id_document = '97278' 20/05/2025 08: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 ( '97278' , '1914' , 'CERA DELLA LITURGIA' , '360' , '360' , '1' , '2.2' , '1.8032786885246' , '22' , '3' , '937.2528' ) 20/05/2025 08:35:16 am >> DELETE FROM ps_product_supplier WHERE id_product = '1914' AND id_supplier = '36' 20/05/2025 08:35:16 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '1914' , '36' , '1' ) 20/05/2025 08:35: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 ( '97278' , '6014' , 'LUMINO BIANCO - 10B' , '960' , '960' , '1' , '0.2' , '0.16393442622951' , '22' , '3' , '227.2128' ) 20/05/2025 08:35:17 am >> DELETE FROM ps_product_supplier WHERE id_product = '6014' AND id_supplier = '36' 20/05/2025 08:35:17 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '6014' , '36' , '1' ) 20/05/2025 08:35: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 ( '97278' , '16796' , 'LUMINO 5B BIANCO' , '3360' , '3360' , '1' , '0.1' , '0.081967213114754' , '22' , '3' , '397.6224' ) 20/05/2025 08:35:17 am >> DELETE FROM ps_product_supplier WHERE id_product = '16796' AND id_supplier = '36' 20/05/2025 08:35:17 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16796' , '36' , '1' ) 20/05/2025 09:06:10 am >> SELECT document_num FROM ps_document WHERE document_num = '1749' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-05-20') 20/05/2025 09:06:10 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' , '1749' , '2025-05-20' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '7.20' , '5.90' , NOW() , NOW() ) 20/05/2025 09:06:10 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 = '97279' 20/05/2025 09:06:10 am >> DELETE FROM ps_document_detail WHERE id_document = '97279' 20/05/2025 09:06:10 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 ( '97279' , '23385' , 'DECINA LEGNO - FR18' , '12' , '-12' , '1' , '0.60' , '0.49180327868852' , '22' , '0' , '7.20' ) 20/05/2025 09:07:47 am >> SELECT document_num FROM ps_document WHERE document_num = '1750' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-05-20') 20/05/2025 09:07:47 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' , '1750' , '2025-05-20' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '1.20' , '0.98' , NOW() , NOW() ) 20/05/2025 09:07:47 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 = '97280' 20/05/2025 09:07:47 am >> DELETE FROM ps_document_detail WHERE id_document = '97280' 20/05/2025 09:07:47 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 ( '97280' , '1713' , 'CARD DELLA GUARIGIONE SAN GERARDO' , '1' , '-1' , '1' , '1.20' , '0.98360655737705' , '22' , '0' , '1.20' ) 20/05/2025 09:10:29 am >> SELECT document_num FROM ps_document WHERE document_num = '1751' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-05-20') 20/05/2025 09:10:29 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' , '1751' , '2025-05-20' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '10.00' , '8.20' , NOW() , NOW() ) 20/05/2025 09:10: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 = '97281' 20/05/2025 09:10:29 am >> DELETE FROM ps_document_detail WHERE id_document = '97281' 20/05/2025 09:10: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 ( '97281' , '19786' , 'ROSARIO MADREPERLA MM5 - 10M5' , '1' , '-1' , '1' , '7.9' , '6.4754098360656' , '22' , '0' , '7.90' ) 20/05/2025 09:10: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 ( '97281' , '17052' , 'CROCETTA S. BENEDETTO METALLO OX CM5X3,3 - PG382' , '3' , '-3' , '1' , '0.70' , '0.57377049180328' , '22' , '0' , '2.10' ) 20/05/2025 09:13:11 am >> SELECT document_num FROM ps_document WHERE document_num = '1737' AND id_document != '97262' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-05-19') 20/05/2025 09:13:11 am >> UPDATE ps_document SET id_document_type = '11', document_num = '1737', document_date = '2025-05-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 = '2.35', price_tax_excluded = '1.93', date_upd = NOW() WHERE id_document = '97262' 20/05/2025 09:13:11 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '97262' 20/05/2025 09:13:11 am >> DELETE FROM ps_document_detail WHERE id_document = '97262' 20/05/2025 09:13:11 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97262' , '6355' , 'MEDAGLIA S. PIO MM 22 - METALLO OX ' , '1' , '-1' , '1' , '0.15' , '0.12295081967213' , '22' , '0' , '0.15' ) 20/05/2025 09:13:11 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97262' , '10464' , 'TAVOLETTA PAPA FRANCESCO - OGGETTI' , '1' , '-1' , '1' , '2.2000' , '1.8032786885246' , '22' , '0' , '2.20' ) 20/05/2025 09:13:56 am >> SELECT document_num FROM ps_document WHERE document_num = '1668' AND id_document != '97184' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-05-14') 20/05/2025 09:13:56 am >> UPDATE ps_document SET id_document_type = '11', document_num = '1668', document_date = '2025-05-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 = '29.50', price_tax_excluded = '24.18', date_upd = NOW() WHERE id_document = '97184' 20/05/2025 09:13:56 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 = '97184' 20/05/2025 09:13:56 am >> DELETE FROM ps_document_detail WHERE id_document = '97184' 20/05/2025 09:13:56 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 ( '97184' , '20824' , 'BRUCIA INCENSO CM 14' , '1' , '-1' , '1' , '25.0000' , '20.491803278689' , '22' , '0' , '25.00' ) 20/05/2025 09:13:56 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 ( '97184' , '6355' , 'MEDAGLIA S. PIO MM 22 - METALLO OX ' , '2' , '-2' , '1' , '0.2' , '0.16393442622951' , '22' , '0' , '0.40' ) 20/05/2025 09:13:56 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 ( '97184' , '22547' , 'ROSARIO LEGNO COLORATO - R07' , '1' , '-1' , '1' , '1.3000' , '1.0655737704918' , '22' , '0' , '1.30' ) 20/05/2025 09:13:56 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 ( '97184' , '17052' , 'CROCETTA S. BENEDETTO METALLO OX CM5X3,3 - PG382' , '4' , '-4' , '1' , '0.70' , '0.57377049180328' , '22' , '0' , '2.80' ) 20/05/2025 09:14:42 am >> SELECT document_num FROM ps_document WHERE document_num = '1703' AND id_document != '97224' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-05-16') 20/05/2025 09:14:42 am >> UPDATE ps_document SET id_document_type = '11', document_num = '1703', document_date = '2025-05-16', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '33.35', price_tax_excluded = '28.97', date_upd = NOW() WHERE id_document = '97224' 20/05/2025 09:14: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 = '97224' 20/05/2025 09:14:42 am >> DELETE FROM ps_document_detail WHERE id_document = '97224' 20/05/2025 09:14: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 ( '97224' , '1914' , 'CERA DELLA LITURGIA' , '4' , '-4' , '1' , '4.9000' , '4.016393442623' , '22' , '0' , '19.60' ) 20/05/2025 09:14: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 ( '97224' , '7311' , 'OSTIA SOTTILE 74MM' , '1' , '-1' , '3' , '2.0000' , '1.9230769230769' , '4' , '0' , '2.00' ) 20/05/2025 09:14: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 ( '97224' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '1' , '-1' , '3' , '3.5000' , '3.3653846153846' , '4' , '0' , '3.50' ) 20/05/2025 09:14: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 ( '97224' , '23689' , 'SULLA TUA PAROLA - LUG/AGO 25' , '1' , '-1' , '4' , '5.0000' , '5' , '0' , '5' , '4.75' ) 20/05/2025 09:14: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 ( '97224' , '17052' , 'CROCETTA S. BENEDETTO METALLO OX CM5X3,3 - PG382' , '5' , '-5' , '1' , '0.70' , '0.57377049180328' , '22' , '0' , '3.50' ) 20/05/2025 09:15:44 am >> SELECT document_num FROM ps_document WHERE document_num = '1198' AND id_document != '96637' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-04-11') 20/05/2025 09:15:44 am >> UPDATE ps_document SET id_document_type = '11', document_num = '1198', document_date = '2025-04-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 = '90.06', price_tax_excluded = '78.43', date_upd = NOW() WHERE id_document = '96637' 20/05/2025 09:15:44 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 = '96637' 20/05/2025 09:15:44 am >> DELETE FROM ps_document_detail WHERE id_document = '96637' 20/05/2025 09:15:45 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 ( '96637' , '23112' , 'CONOSCI TE STESSO - C. AMIRANTE' , '1' , '-1' , '4' , '12.9000' , '12.9' , '0' , '5' , '12.26' ) 20/05/2025 09:15:45 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 ( '96637' , '22129' , 'PADRE NOSTRO - L. EPICOCO' , '1' , '-1' , '4' , '14.0000' , '14' , '0' , '5' , '13.30' ) 20/05/2025 09:15:45 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 ( '96637' , '19147' , 'CANDELINE NON GOCCIOLANTI GRECHE' , '3' , '-3' , '1' , '17.9000' , '14.672131147541' , '22' , '0' , '53.70' ) 20/05/2025 09:15:45 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 ( '96637' , '19867' , 'CINGOLO NODO BIANCO - F9756' , '2' , '-2' , '1' , '2.5000' , '2.0491803278689' , '22' , '0' , '5.00' ) 20/05/2025 09:15:45 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 ( '96637' , '6355' , 'MEDAGLIA S. PIO MM 22 - METALLO OX ' , '10' , '-10' , '1' , '0.25' , '0.20491803278689' , '22' , '0' , '2.50' ) 20/05/2025 09:15:45 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 ( '96637' , '6325' , 'MEDAGLIA MIRACOLOSA MM 22 - METALLO OX' , '10' , '-10' , '1' , '0.25' , '0.20491803278689' , '22' , '0' , '2.50' ) 20/05/2025 09:15:45 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 ( '96637' , '20516' , 'CROCE COMUNIONE - 42/08' , '1' , '-1' , '1' , '0.8' , '0.65573770491803' , '22' , '0' , '0.80' ) 20/05/2025 09:45:21 am >> SELECT document_num FROM ps_document WHERE document_num = '1752' AND id_document != '' AND id_document_type LIKE '12' AND YEAR(document_date) = YEAR('2025-05-20') 20/05/2025 09:45:21 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' , '1752' , '2025-05-20' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '26.60' , '26.60' , NOW() , NOW() ) 20/05/2025 09:45:21 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 = '97282' 20/05/2025 09:45:21 am >> DELETE FROM ps_document_detail WHERE id_document = '97282' 20/05/2025 09:45:21 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 ( '97282' , '13830' , 'VANGELO E ATTI - ECOPELLE BIANCA - 8592' , '7' , '-7' , '4' , '4.00' , '4' , '0' , '5' , '26.60' ) 20/05/2025 09:53:36 am >> SELECT document_num FROM ps_document WHERE document_num = '1753' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-05-20') 20/05/2025 09:53:36 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' , '1753' , '2025-05-20' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '18.50' , '15.16' , NOW() , NOW() ) 20/05/2025 09:53:36 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 = '97283' 20/05/2025 09:53:36 am >> DELETE FROM ps_document_detail WHERE id_document = '97283' 20/05/2025 09:53:36 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 ( '97283' , '791' , 'ASSISI IN BUSTA BATTESIMO - 20X270 - BAAS' , '3' , '-3' , '1' , '1.50' , '1.2295081967213' , '22' , '0' , '4.50' ) 20/05/2025 09:53:36 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 ( '97283' , '1750' , 'CARTUCCIA TRASPARENTE DIAM. 3,2 - 454' , '1' , '-1' , '1' , '14.00' , '11.475409836066' , '22' , '0' , '14.00' ) 20/05/2025 10:00:38 am >> SELECT document_num FROM ps_document WHERE document_num = '1685' AND id_document != '97204' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-05-15') 20/05/2025 10:00:38 am >> UPDATE ps_document SET id_document_type = '11', document_num = '1685', document_date = '2025-05-15', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '17.90', price_tax_excluded = '14.67', date_upd = NOW() WHERE id_document = '97204' 20/05/2025 10:00: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 = '97204' 20/05/2025 10:00:38 am >> DELETE FROM ps_document_detail WHERE id_document = '97204' 20/05/2025 10:00: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 ( '97204' , '21155' , 'BRACCIALE TENNIS + MEDAGLIA - 209' , '1' , '-1' , '1' , '2.9000' , '2.3770491803279' , '22' , '0' , '2.90' ) 20/05/2025 10:00: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 ( '97204' , '17617' , 'IMMAGINI ISONZO X 100' , '3' , '-3' , '1' , '3.5' , '2.8688524590164' , '22' , '0' , '10.50' ) 20/05/2025 10:00: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 ( '97204' , '18276' , 'CINGOLO CON NODI - 3280' , '1' , '-1' , '1' , '3.00' , '2.4590163934426' , '22' , '0' , '3.00' ) 20/05/2025 10:00: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 ( '97204' , '20516' , 'CROCE COMUNIONE - 42/08' , '1' , '-1' , '1' , '1.20' , '0.98360655737705' , '22' , '0' , '1.20' ) 20/05/2025 10:00: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 ( '97204' , '18618' , 'MEDAGLIA SAN MICHELE - OV22/MC' , '1' , '-1' , '1' , '0.25' , '0.20491803278689' , '22' , '0' , '0.25' ) 20/05/2025 10:00: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 ( '97204' , '5538' , 'LACCIO MARRONE' , '1' , '-1' , '1' , '0.05' , '0.040983606557377' , '22' , '0' , '0.05' ) 20/05/2025 10:16:24 am >> SELECT document_num FROM ps_document WHERE document_num = '1754' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-05-20') 20/05/2025 10:16: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' , '1754' , '2025-05-20' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '11.40' , '11.40' , NOW() , NOW() ) 20/05/2025 10:16: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 = '97284' 20/05/2025 10:16:24 am >> DELETE FROM ps_document_detail WHERE id_document = '97284' 20/05/2025 10:16: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 ( '97284' , '23516' , 'MESSALINO QUOTIDIANO - MAG/GIU/LUG 25' , '2' , '-2' , '4' , '6.00' , '6' , '0' , '5' , '11.40' ) 20/05/2025 10:36:47 am >> SELECT document_num FROM ps_document WHERE document_num = '1755' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-05-20') 20/05/2025 10:36:47 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' , '1755' , '2025-05-20' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '14.00' , '14.00' , NOW() , NOW() ) 20/05/2025 10:36:47 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 = '97285' 20/05/2025 10:36:47 am >> DELETE FROM ps_document_detail WHERE id_document = '97285' 20/05/2025 10:36:47 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 ( '97285' , '23205' , 'STRADE DEGLI UOMINI SENTIERI DI DIO - P. ZAGO' , '1' , '-1' , '4' , '14.00' , '14' , '0' , '0' , '14.00' ) 20/05/2025 11:14:49 am >> SELECT document_num FROM ps_document WHERE document_num = '1756' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-05-20') 20/05/2025 11:14:49 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' , '1756' , '2025-05-20' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '30.80' , '25.25' , NOW() , NOW() ) 20/05/2025 11:14:49 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '97286' 20/05/2025 11:14:49 am >> DELETE FROM ps_document_detail WHERE id_document = '97286' 20/05/2025 11:14:49 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97286' , '22601' , 'CATENINA CON CROCE - BKSS-0072SI' , '1' , '-1' , '1' , '29.00' , '23.770491803279' , '22' , '0' , '29.00' ) 20/05/2025 11:14:49 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97286' , '21597' , 'BIGLIETTI AUGURI SAN PAOLO' , '1' , '-1' , '1' , '1.00' , '0.81967213114754' , '22' , '0' , '1.00' ) 20/05/2025 11:14:49 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97286' , '17004' , 'BIGLIETTO AUGURALE PICCOLO' , '1' , '-1' , '1' , '0.80' , '0.65573770491803' , '22' , '0' , '0.80' ) 20/05/2025 11:15:47 am >> SELECT document_num FROM ps_document WHERE document_num = '1757' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-05-20') 20/05/2025 11:15:47 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' , '1757' , '2025-05-20' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '6.20' , '5.08' , NOW() , NOW() ) 20/05/2025 11:15:47 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 = '97287' 20/05/2025 11:15:47 am >> DELETE FROM ps_document_detail WHERE id_document = '97287' 20/05/2025 11:15:47 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 ( '97287' , '17277' , 'BRACCIALE PIETRE DURE - 4633' , '1' , '-1' , '1' , '6.20' , '5.0819672131148' , '22' , '0' , '6.20' ) 20/05/2025 12:03:58 pm >> SELECT document_num FROM ps_document WHERE document_num = '1725' AND id_document != '97246' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-05-17') 20/05/2025 12:03:58 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '1725', document_date = '2025-05-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 = '27.00', price_tax_excluded = '22.67', date_upd = NOW() WHERE id_document = '97246' 20/05/2025 12:03:58 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '97246' 20/05/2025 12:03:58 pm >> DELETE FROM ps_document_detail WHERE id_document = '97246' 20/05/2025 12:03:58 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97246' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '24.0000' , '19.672131147541' , '22' , '0' , '24.00' ) 20/05/2025 12:03:58 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97246' , '23492' , 'AMEN - GIU 25' , '1' , '-1' , '4' , '3' , '3' , '0' , '0' , '3.00' ) 20/05/2025 12:11:40 pm >> SELECT document_num FROM ps_document WHERE document_num = '1758' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-05-20') 20/05/2025 12:11:40 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' , '1758' , '2025-05-20' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '12.40' , '10.16' , NOW() , NOW() ) 20/05/2025 12:11:40 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 = '97288' 20/05/2025 12:11:40 pm >> DELETE FROM ps_document_detail WHERE id_document = '97288' 20/05/2025 12:11:40 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 ( '97288' , '20516' , 'CROCE COMUNIONE - 42/08' , '2' , '-2' , '1' , '1.3' , '1.0655737704918' , '22' , '0' , '2.60' ) 20/05/2025 12:11:40 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 ( '97288' , '1914' , 'CERA DELLA LITURGIA' , '2' , '-2' , '1' , '4.90' , '4.016393442623' , '22' , '0' , '9.80' ) 20/05/2025 12:33:47 pm >> SELECT document_num FROM ps_document WHERE document_num = '1759' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-05-20') 20/05/2025 12:33:48 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' , '1759' , '2025-05-20' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '9.99' , '8.19' , NOW() , NOW() ) 20/05/2025 12:33:48 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 = '97289' 20/05/2025 12:33:48 pm >> DELETE FROM ps_document_detail WHERE id_document = '97289' 20/05/2025 12:33:48 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 ( '97289' , '17617' , 'IMMAGINI ISONZO X 100' , '3' , '-3' , '1' , '3.33' , '2.7295081967213' , '22' , '0' , '9.99' ) 20/05/2025 03:20:30 pm >> SELECT document_num FROM ps_document WHERE document_num = '1760' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-05-20') 20/05/2025 03:20: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' , '1760' , '2025-05-20' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '25.20' , '21.41' , NOW() , NOW() ) 20/05/2025 03:20: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 = '97290' 20/05/2025 03:20:30 pm >> DELETE FROM ps_document_detail WHERE id_document = '97290' 20/05/2025 03:20: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 ( '97290' , '18891' , 'ROSARIO LEGNO - R984' , '21' , '-21' , '1' , '1.00' , '0.81967213114754' , '22' , '0' , '21.00' ) 20/05/2025 03:20: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 ( '97290' , '11151' , 'LIBRI' , '21' , '-21' , '4' , '0.2' , '0.2' , '0' , '0' , '4.20' ) 20/05/2025 03:35:10 pm >> SELECT document_num FROM ps_document WHERE document_num = '1761' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-05-20') 20/05/2025 03:35:10 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' , '1761' , '2025-05-20' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '16.00' , '13.11' , NOW() , NOW() ) 20/05/2025 03:35:10 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 = '97291' 20/05/2025 03:35:10 pm >> DELETE FROM ps_document_detail WHERE id_document = '97291' 20/05/2025 03:35:10 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 ( '97291' , '2085' , 'CINTURA MISTO COTONE AVORIO - OGGETTI' , '1' , '-1' , '1' , '10.00' , '8.1967213114754' , '22' , '0' , '10.00' ) 20/05/2025 03:35:10 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 ( '97291' , '7916' , 'PERGAMENE - 1A RICONCILIAZIONE MOD. A' , '5' , '-5' , '1' , '0.50' , '0.40983606557377' , '22' , '0' , '2.50' ) 20/05/2025 03:35:10 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 ( '97291' , '17617' , 'IMMAGINI ISONZO X 100' , '1' , '-1' , '1' , '3.5' , '2.8688524590164' , '22' , '0' , '3.50' ) 20/05/2025 04:03:59 pm >> SELECT document_num FROM ps_document WHERE document_num = '1094' AND id_document != '96520' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-04-04') 20/05/2025 04:03:59 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '1094', document_date = '2025-04-04', 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 = '39.50', price_tax_excluded = '32.38', date_upd = NOW() WHERE id_document = '96520' 20/05/2025 04:03: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 = '96520' 20/05/2025 04:03:59 pm >> DELETE FROM ps_document_detail WHERE id_document = '96520' 20/05/2025 04:03: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 ( '96520' , '19594' , 'POLO JERSEY COTONE 100%' , '1' , '-1' , '1' , '39.5' , '32.377049180328' , '22' , '0' , '39.50' ) 20/05/2025 04:35:39 pm >> SELECT document_num FROM ps_document WHERE document_num = '1320' AND id_document != '96776' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-04-19') 20/05/2025 04:35:39 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '1320', document_date = '2025-04-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 = '34.00', price_tax_excluded = '27.87', date_upd = NOW() WHERE id_document = '96776' 20/05/2025 04:35:39 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 = '96776' 20/05/2025 04:35:39 pm >> DELETE FROM ps_document_detail WHERE id_document = '96776' 20/05/2025 04:35:39 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 ( '96776' , '18617' , 'MEDAGLIA MIRACOLOSA - OV22/M' , '4' , '-4' , '1' , '0.25' , '0.20491803278689' , '22' , '0' , '1.00' ) 20/05/2025 04:35:39 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 ( '96776' , '13338' , 'CORONA MM 6 VETRO CON SCATOLA - 0522' , '11' , '-11' , '1' , '3.00' , '2.4590163934426' , '22' , '0' , '33.00' ) 20/05/2025 04:36:19 pm >> SELECT document_num FROM ps_document WHERE document_num = '1371' AND id_document != '96835' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-04-24') 20/05/2025 04:36:19 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '1371', document_date = '2025-04-24', 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 = '35.00', price_tax_excluded = '28.69', date_upd = NOW() WHERE id_document = '96835' 20/05/2025 04:36:19 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 = '96835' 20/05/2025 04:36:19 pm >> DELETE FROM ps_document_detail WHERE id_document = '96835' 20/05/2025 04:36:19 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 ( '96835' , '13338' , 'CORONA MM 6 VETRO CON SCATOLA - 0522' , '5' , '-5' , '1' , '3.00' , '2.4590163934426' , '22' , '0' , '15.00' ) 20/05/2025 04:36:19 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 ( '96835' , '13363' , 'CORONA MM 6 pietra colorata' , '10' , '-10' , '1' , '2' , '1.6393442622951' , '22' , '0' , '20.00' ) 20/05/2025 04:37:14 pm >> SELECT document_num FROM ps_document WHERE document_num = '1512' AND id_document != '97004' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-05-05') 20/05/2025 04:37:14 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '1512', document_date = '2025-05-05', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '45.00', price_tax_excluded = '36.89', date_upd = NOW() WHERE id_document = '97004' 20/05/2025 04:37:14 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 = '97004' 20/05/2025 04:37:14 pm >> DELETE FROM ps_document_detail WHERE id_document = '97004' 20/05/2025 04:37:14 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 ( '97004' , '13364' , 'CORONA MM 6 ' , '2' , '-2' , '1' , '2.5' , '2.0491803278689' , '22' , '0' , '5.00' ) 20/05/2025 04:37:14 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 ( '97004' , '13364' , 'CORONA MM 6 ' , '20' , '-20' , '1' , '2' , '1.6393442622951' , '22' , '0' , '40.00' ) 20/05/2025 04:58:34 pm >> SELECT document_num FROM ps_document WHERE document_num = '1762' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-05-20') 20/05/2025 04:58:34 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' , '1762' , '2025-05-20' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '65.00' , '53.28' , NOW() , NOW() ) 20/05/2025 04:58:34 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 = '97292' 20/05/2025 04:58:34 pm >> DELETE FROM ps_document_detail WHERE id_document = '97292' 20/05/2025 04:58:34 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 ( '97292' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '65' , '53.27868852459' , '22' , '0' , '65.00' ) 20/05/2025 05:06:50 pm >> SELECT document_num FROM ps_document WHERE document_num = '1763' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-05-20') 20/05/2025 05:06:50 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' , '1763' , '2025-05-20' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '17.50' , '17.50' , NOW() , NOW() ) 20/05/2025 05:06:50 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 = '97293' 20/05/2025 05:06:50 pm >> DELETE FROM ps_document_detail WHERE id_document = '97293' 20/05/2025 05:06:50 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 ( '97293' , '23536' , 'SULLA TUA PAROLA - MAG/GIU 25' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' ) 20/05/2025 05:06:50 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 ( '97293' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '12.75' , '12.75' , '0' , '0' , '12.75' ) 20/05/2025 06:03:22 pm >> SELECT document_num FROM ps_document WHERE document_num = '1764' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-05-20') 20/05/2025 06:03:22 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' , '1764' , '2025-05-20' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '29.00' , '23.77' , NOW() , NOW() ) 20/05/2025 06:03:22 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 = '97294' 20/05/2025 06:03:22 pm >> DELETE FROM ps_document_detail WHERE id_document = '97294' 20/05/2025 06:03:22 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 ( '97294' , '18615' , 'SAN ROCCO CM 20 - 340' , '1' , '-1' , '1' , '29.00' , '23.770491803279' , '22' , '0' , '29.00' ) 20/05/2025 06:21:17 pm >> SELECT document_num FROM ps_document WHERE document_num = '1765' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-05-20') 20/05/2025 06:21:17 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' , '1765' , '2025-05-20' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '37.05' , '37.05' , NOW() , NOW() ) 20/05/2025 06:21: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 = '97295' 20/05/2025 06:21:17 pm >> DELETE FROM ps_document_detail WHERE id_document = '97295' 20/05/2025 06:21: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 ( '97295' , '7182' , 'NUOVO TESTAMENTO - CAR. GRANDI' , '1' , '-1' , '4' , '39.00' , '39' , '0' , '5' , '37.05' ) 20/05/2025 06:22:25 pm >> SELECT document_num FROM ps_document WHERE document_num = '1766' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-05-20') 20/05/2025 06:22:25 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' , '1766' , '2025-05-20' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '19.00' , '19.00' , NOW() , NOW() ) 20/05/2025 06:22:25 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 = '97296' 20/05/2025 06:22:25 pm >> DELETE FROM ps_document_detail WHERE id_document = '97296' 20/05/2025 06:22:25 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97296' , '23689' , 'SULLA TUA PAROLA - LUG/AGO 25' , '4' , '-4' , '4' , '5.00' , '5' , '0' , '5' , '19.00' )