06/09/2025 08:59:55 am >> SELECT document_num FROM ps_document WHERE document_num = '24/L' AND id_document != '98621' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2025-09-05') 06/09/2025 08:59:56 am >> UPDATE ps_document SET id_document_type = '23', document_num = '24/L', document_date = '2025-09-05', document_letter = 'L', id_customer = '2379', id_supplier = '', id_address = '4671437', address1 = 'R.NE PESCARA 84025 EBOLI', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '1', id_causal = '0', price_tax_included = '618.30', price_tax_excluded = '615.41', date_upd = NOW() WHERE id_document = '98621' 06/09/2025 08:59: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 = '98621' 06/09/2025 08:59:56 am >> DELETE FROM ps_document_detail WHERE id_document = '98621' 06/09/2025 08:59: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 ( '98621' , '8509' , 'PRIMI PASSI CON GESÙ - ANNO A' , '20' , '-20' , '4' , '3.5000' , '3.5' , '0' , '20' , '56.00' ) 06/09/2025 08:59: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 ( '98621' , '8598' , 'IO SONO CON VOI 1 - MAGNIFICAT' , '20' , '-20' , '4' , '3.0000' , '3' , '0' , '10' , '54.00' ) 06/09/2025 08:59: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 ( '98621' , '8599' , 'IO SONO CON VOI 2 - MAGNIFICAT' , '30' , '-30' , '4' , '3.0000' , '3' , '0' , '10' , '81.00' ) 06/09/2025 08:59: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 ( '98621' , '8602' , 'VENITE CON ME 1 - MAGNIFICAT' , '40' , '-40' , '4' , '3.0000' , '3' , '0' , '10' , '108.00' ) 06/09/2025 08:59: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 ( '98621' , '8603' , 'VENITE CON ME 2 - MAGNIFICAT' , '30' , '-30' , '4' , '3.0000' , '3' , '0' , '10' , '81.00' ) 06/09/2025 08:59: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 ( '98621' , '8600' , 'SARETE MIEI TESTIMONI 1 - MAGNIFICAT' , '20' , '-20' , '4' , '3.0000' , '3' , '0' , '10' , '54.00' ) 06/09/2025 08:59: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 ( '98621' , '10740' , 'TROPPO FORTE - 1/ IL DECOLLO' , '20' , '-20' , '4' , '5.0000' , '5' , '0' , '10' , '90.00' ) 06/09/2025 08:59: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 ( '98621' , '10741' , 'TROPPO FORTE - 2/ LA DIREZIONE' , '15' , '-15' , '4' , '5.0000' , '5' , '0' , '10' , '67.50' ) 06/09/2025 08:59: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 ( '98621' , '5451' , 'IO SONO CON VOI - GUIDA 2 - MAGNIFICAT' , '1' , '-1' , '4' , '12.0000' , '12' , '0' , '10' , '10.80' ) 06/09/2025 08:59: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 ( '98621' , '12819' , 'REGISTRO DEL CATECHISTA ' , '20' , '-20' , '1' , '1.0000' , '0.81967213114754' , '22' , '20' , '16.00' ) 06/09/2025 09:00:14 am >> SELECT document_num FROM ps_document WHERE document_num = '23/L' AND id_document != '98614' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2025-09-05') 06/09/2025 09:00:14 am >> UPDATE ps_document SET id_document_type = '23', document_num = '23/L', document_date = '2025-09-05', document_letter = 'L', id_customer = '3479', id_supplier = '', id_address = '4673306', address1 = 'VIA SAN GREGORIO VII 28 84091 BATTIPAGLIA', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '3', id_causal = '0', price_tax_included = '456.00', price_tax_excluded = '421.74', date_upd = NOW() WHERE id_document = '98614' 06/09/2025 09:00:14 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 = '98614' 06/09/2025 09:00:14 am >> DELETE FROM ps_document_detail WHERE id_document = '98614' 06/09/2025 09:00:14 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 ( '98614' , '23719' , 'STOLA RICAMO CROCE - 796MTP' , '2' , '-2' , '1' , '95.0000' , '77.868852459016' , '22' , '0' , '190.00' ) 06/09/2025 09:00:14 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 ( '98614' , '23966' , 'ARMARSI CON CINQUE CIOTTOLI - R. FACCENDA' , '20' , '-20' , '4' , '14.0000' , '14' , '0' , '5' , '266.00' ) 06/09/2025 09:42:30 am >> SELECT document_num FROM ps_document WHERE document_num = '2891' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-09-06') 06/09/2025 09:42: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' , '2891' , '2025-09-06' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '35.00' , '28.69' , NOW() , NOW() ) 06/09/2025 09:42: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 = '98637' 06/09/2025 09:42:30 am >> DELETE FROM ps_document_detail WHERE id_document = '98637' 06/09/2025 09:42: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 ( '98637' , '22440' , 'ROSARIO ARGENTO/LAVA - 7692/50' , '1' , '-1' , '1' , '35.00' , '28.688524590164' , '22' , '0' , '35.00' ) 06/09/2025 10:26:09 am >> SELECT document_num FROM ps_document WHERE document_num = '2892' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-09-06') 06/09/2025 10:26: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' , '2892' , '2025-09-06' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '20.60' , '20.10' , NOW() , NOW() ) 06/09/2025 10:26: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 = '98638' 06/09/2025 10:26:10 am >> DELETE FROM ps_document_detail WHERE id_document = '98638' 06/09/2025 10:26: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 ( '98638' , '6325' , 'MEDAGLIA MIRACOLOSA MM 22 - METALLO OX' , '4' , '-4' , '1' , '0.25' , '0.20491803278689' , '22' , '0' , '1.00' ) 06/09/2025 10:26: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 ( '98638' , '9127' , 'ROSARIO LACCATO' , '1' , '-1' , '1' , '1.80' , '1.4754098360656' , '22' , '0' , '1.80' ) 06/09/2025 10:26: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 ( '98638' , '23807' , 'CALENDARIO LITURGICO 2026' , '1' , '-1' , '4' , '0.80' , '0.8' , '0' , '0' , '0.80' ) 06/09/2025 10:26: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 ( '98638' , '23959' , 'SEME NEL DESERTO CHARLES DE FOUCAULD - PRONZATO A.' , '1' , '-1' , '4' , '17.00' , '17' , '0' , '0' , '17.00' ) 06/09/2025 10:37:16 am >> SELECT document_num FROM ps_document WHERE document_num = '2893' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-09-06') 06/09/2025 10:37:16 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2893' , '2025-09-06' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '98.01' , '81.69' , NOW() , NOW() ) 06/09/2025 10:37: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 = '98639' 06/09/2025 10:37:16 am >> DELETE FROM ps_document_detail WHERE id_document = '98639' 06/09/2025 10:37: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 ( '98639' , '11384' , 'VINO BIANCO DOLCE - 102' , '6' , '-6' , '1' , '8.5' , '6.9672131147541' , '22' , '0' , '51.00' ) 06/09/2025 10:37: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 ( '98639' , '12895' , 'PASSI VERSO LA CRESIMA' , '1' , '-1' , '4' , '7.90' , '7.9' , '0' , '5' , '7.51' ) 06/09/2025 10:37: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 ( '98639' , '2178' , 'CLERGY BASIC EXTRA - MM - B&P' , '1' , '-1' , '1' , '39.50' , '32.377049180328' , '22' , '0' , '39.50' ) 06/09/2025 11:13:49 am >> SELECT document_num FROM ps_document WHERE document_num = '2894' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-09-06') 06/09/2025 11:13: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' , '2894' , '2025-09-06' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '112.21' , '96.71' , NOW() , NOW() ) 06/09/2025 11:13: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 = '98640' 06/09/2025 11:13:49 am >> DELETE FROM ps_document_detail WHERE id_document = '98640' 06/09/2025 11:13: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 ( '98640' , '19560' , 'PERGAMENA COMUNIONE 17X25' , '5' , '-5' , '1' , '0.70' , '0.57377049180328' , '22' , '0' , '3.50' ) 06/09/2025 11:13: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 ( '98640' , '16691' , 'PARTICOLE PER CELIACI 25pz' , '1' , '-1' , '3' , '4.50' , '4.3269230769231' , '4' , '0' , '4.50' ) 06/09/2025 11:13: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 ( '98640' , '11756' , 'VINO BIANCO SECCO - 14%' , '1' , '-1' , '1' , '6.90' , '5.655737704918' , '22' , '0' , '6.90' ) 06/09/2025 11:13: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 ( '98640' , '17617' , 'IMMAGINI ISONZO X 100' , '1' , '-1' , '1' , '3.60' , '2.9508196721311' , '22' , '0' , '3.60' ) 06/09/2025 11:13: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 ( '98640' , '17005' , 'BIGLIETTO AUGURALE medio' , '1' , '-1' , '1' , '1.00' , '0.81967213114754' , '22' , '0' , '1.00' ) 06/09/2025 11:13: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 ( '98640' , '23590' , 'SAN CARLO ACUTIS - U. DE VANNA' , '1' , '-1' , '4' , '9.90' , '9.9' , '0' , '5' , '9.41' ) 06/09/2025 11:13: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 ( '98640' , '19876' , 'CROCE CM 34 MARM/BI - 4989/833' , '1' , '-1' , '1' , '70' , '57.377049180328' , '22' , '0' , '70.00' ) 06/09/2025 11:13: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 ( '98640' , '23966' , 'ARMARSI CON CINQUE CIOTTOLI - R. FACCENDA' , '1' , '-1' , '4' , '14.00' , '14' , '0' , '5' , '13.30' ) 06/09/2025 11:14:51 am >> SELECT document_num FROM ps_document WHERE document_num = '2895' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-09-06') 06/09/2025 11:14:51 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' , '2895' , '2025-09-06' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '4.75' , '4.75' , NOW() , NOW() ) 06/09/2025 11:14:51 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 = '98641' 06/09/2025 11:14:51 am >> DELETE FROM ps_document_detail WHERE id_document = '98641' 06/09/2025 11:14:51 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 ( '98641' , '23714' , 'SULLA TUA PAROLA - SETT/OTT 25' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' ) 06/09/2025 11:24:53 am >> SELECT document_num FROM ps_document WHERE document_num = '91' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2025-09-06') 06/09/2025 11:24:53 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '21' , '91' , '2025-09-06' , '' , '4113' , '0' , '4679349' , 'VIA GERMONIO 6 10095 GRUGLIASCO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '3' , '0' , '193.38' , '193.38' , NOW() , NOW() ) 06/09/2025 11:24:53 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 = '98642' 06/09/2025 11:24:53 am >> DELETE FROM ps_document_detail WHERE id_document = '98642' 06/09/2025 11:24:53 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 ( '98642' , '2679' , 'CONOSCERE GESU\'' , '15' , '-15' , '4' , '3.50' , '3.5' , '0' , '15' , '44.63' ) 06/09/2025 11:24:53 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 ( '98642' , '4154' , 'FESTA DEL PERDONO' , '15' , '-15' , '4' , '3.00' , '3' , '0' , '15' , '38.25' ) 06/09/2025 11:24:53 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 ( '98642' , '8408' , 'PRENDETE E MANGIATE' , '25' , '-25' , '4' , '3.00' , '3' , '0' , '15' , '63.75' ) 06/09/2025 11:24:53 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 ( '98642' , '8409' , 'PRENDETE E MANGIATE - GUIDA' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '15' , '4.25' ) 06/09/2025 11:24:53 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 ( '98642' , '2880' , 'CRESIMA: UN DONO E UN PROGETTO' , '20' , '-20' , '4' , '2.50' , '2.5' , '0' , '15' , '42.50' ) 06/09/2025 11:26:52 am >> SELECT document_num FROM ps_document WHERE document_num = '2896' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-09-06') 06/09/2025 11:26:52 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' , '2896' , '2025-09-06' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '20.00' , '16.39' , NOW() , NOW() ) 06/09/2025 11:26:52 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 = '98643' 06/09/2025 11:26:52 am >> DELETE FROM ps_document_detail WHERE id_document = '98643' 06/09/2025 11:26:52 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 ( '98643' , '17617' , 'IMMAGINI ISONZO X 100' , '2' , '-2' , '1' , '3.5' , '2.8688524590164' , '22' , '0' , '7.00' ) 06/09/2025 11:26:53 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 ( '98643' , '17617' , 'IMMAGINI ISONZO X 100' , '1' , '-1' , '1' , '3' , '2.4590163934426' , '22' , '0' , '3.00' ) 06/09/2025 11:26:53 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 ( '98643' , '23099' , 'TELA 18X25 ACUTIS - 2963/S0342NC' , '1' , '-1' , '1' , '10.00' , '8.1967213114754' , '22' , '0' , '10.00' ) 06/09/2025 11:56:00 am >> SELECT document_num FROM ps_document WHERE document_num = '2897' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-09-06') 06/09/2025 11:56: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' , '2897' , '2025-09-06' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '15.00' , '15.00' , NOW() , NOW() ) 06/09/2025 11:56: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 = '98644' 06/09/2025 11:56:00 am >> DELETE FROM ps_document_detail WHERE id_document = '98644' 06/09/2025 11:56: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 ( '98644' , '23659' , 'MARIA NELLE SUE APPARIZIONI' , '1' , '-1' , '4' , '15.00' , '15' , '0' , '0' , '15.00' ) 06/09/2025 12:03:35 pm >> SELECT document_num FROM ps_document WHERE document_num = '2898' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-09-06') 06/09/2025 12:03:35 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2898' , '2025-09-06' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '11.50' , '9.43' , NOW() , NOW() ) 06/09/2025 12:03: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 = '98645' 06/09/2025 12:03:35 pm >> DELETE FROM ps_document_detail WHERE id_document = '98645' 06/09/2025 12:03: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 ( '98645' , '18199' , 'QUADRETTO EFFETTO PIETRA SANTA RITA - 2952' , '1' , '-1' , '1' , '4.00' , '3.2786885245902' , '22' , '0' , '4.00' ) 06/09/2025 12:03: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 ( '98645' , '15088' , 'QUADRETTO EFFETTO PIETRA - MIRACOLOSA - 2952' , '1' , '-1' , '1' , '4.00' , '3.2786885245902' , '22' , '0' , '4.00' ) 06/09/2025 12:03:36 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 ( '98645' , '18174' , 'MEDAGLIA OVALE - SMALTINO - M022A' , '5' , '-5' , '1' , '0.70' , '0.57377049180328' , '22' , '0' , '3.50' ) 06/09/2025 12:29:52 pm >> SELECT document_num FROM ps_document WHERE document_num = '2899' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-09-06') 06/09/2025 12:29: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' , '2899' , '2025-09-06' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '10.00' , '8.20' , NOW() , NOW() ) 06/09/2025 12:29: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 = '98646' 06/09/2025 12:29:52 pm >> DELETE FROM ps_document_detail WHERE id_document = '98646' 06/09/2025 12:29: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 ( '98646' , '23099' , 'TELA 18X25 ACUTIS - 2963/S0342NC' , '1' , '-1' , '1' , '10.00' , '8.1967213114754' , '22' , '0' , '10.00' )