06/08/2025 08:57:22 am >> SELECT document_num FROM ps_document WHERE document_num = '21' AND id_document != '98330' AND id_document_type LIKE '24' AND YEAR(document_date) = YEAR('2025-08-01') 06/08/2025 08:57:22 am >> UPDATE ps_document SET id_document_type = '24', document_num = '21', document_date = '2025-08-01', document_letter = '', id_customer = '3000', id_supplier = '', id_address = '4669629', address1 = 'VIA DEI CASTANI, 116 00172 ROMA', address2 = '', note = 'EDIZIONI', 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 = '1700.00', price_tax_excluded = '1700.00', date_upd = NOW() WHERE id_document = '98330' 06/08/2025 08:57:22 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 = '98330' 06/08/2025 08:57:22 am >> DELETE FROM ps_document_detail WHERE id_document = '98330' 06/08/2025 08:57:22 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 ( '98330' , '23870' , 'RAGAZZO DEL LENZUOLO - M. VIANI' , '100' , '-100' , '4' , '10.0000' , '10' , '0' , '0' , '1000.00' ) 06/08/2025 08:57:22 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 ( '98330' , '23677' , 'RICETTE DI MAMMA ROSA' , '35' , '-35' , '4' , '20.0000' , '20' , '0' , '0' , '700.00' ) 06/08/2025 09:05:37 am >> SELECT document_num FROM ps_document WHERE document_num = '107/A' AND id_document != '' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2025-08-06') 06/08/2025 09:05:38 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '24' , '107/A' , '2025-08-06' , 'A' , '2332' , '0' , '4679092' , 'P.ZZA S. ROCCO 84088 SIANO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '1209.60' , '991.48' , NOW() , NOW() ) 06/08/2025 09:05: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 = '98375' 06/08/2025 09:05:38 am >> DELETE FROM ps_document_detail WHERE id_document = '98375' 06/08/2025 09:05: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 ( '98375' , '23897' , 'QUADRETTO CON FIOCCO S. ROCCO - 12/39-C' , '25' , '-25' , '1' , '3.30' , '2.7049180327869' , '22' , '0' , '82.50' ) 06/08/2025 09:05: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 ( '98375' , '23898' , 'QUADRETTO CON FIOCCO S. ROCCO - 12/39-R' , '24' , '-24' , '1' , '3.30' , '2.7049180327869' , '22' , '0' , '79.20' ) 06/08/2025 09:05: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 ( '98375' , '23903' , 'BRACCIALE CON MEDAGLIA SAN ROCCO - 800/W2158-RH' , '12' , '-12' , '1' , '3.00' , '2.4590163934426' , '22' , '0' , '36.00' ) 06/08/2025 09:05: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 ( '98375' , '23902' , 'BRACCIALE SAN ROCCO - 800/CA4' , '36' , '-36' , '1' , '3.00' , '2.4590163934426' , '22' , '0' , '108.00' ) 06/08/2025 09:05: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 ( '98375' , '22656' , 'PORTACHIAVI SAN ROCCO' , '183' , '-183' , '1' , '1.4' , '1.1475409836066' , '22' , '0' , '256.20' ) 06/08/2025 09:05: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 ( '98375' , '22653' , 'GIROCOLLO PERSONALIZZATO SAN ROCCO' , '48' , '-48' , '1' , '3' , '2.4590163934426' , '22' , '0' , '144.00' ) 06/08/2025 09:05: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 ( '98375' , '23901' , 'MEDAGLIA SAN ROCCO SMALTATA - 400/6573M' , '200' , '-200' , '1' , '0.40' , '0.32786885245902' , '22' , '0' , '80.00' ) 06/08/2025 09:05: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 ( '98375' , '23896' , 'MAGNETE SAN ROCCO - 1181-0' , '109' , '-109' , '1' , '1.30' , '1.0655737704918' , '22' , '0' , '141.70' ) 06/08/2025 09:05: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 ( '98375' , '23899' , 'ROSARIO SAN ROCCO - 163/8' , '36' , '-36' , '1' , '4.50' , '3.6885245901639' , '22' , '0' , '162.00' ) 06/08/2025 09:05: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 ( '98375' , '23900' , 'BRACCIALE 1/2 CRISTALLO - 20/6-B' , '48' , '-48' , '1' , '2.50' , '2.0491803278689' , '22' , '0' , '120.00' ) 06/08/2025 09:49:39 am >> SELECT document_num FROM ps_document WHERE document_num = '108/A' AND id_document != '' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2025-08-06') 06/08/2025 09:49:39 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '24' , '108/A' , '2025-08-06' , 'A' , '2332' , '0' , '4679092' , 'P.ZZA S. ROCCO 84088 SIANO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '182.20' , '149.34' , NOW() , NOW() ) 06/08/2025 09:49:39 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '98376' 06/08/2025 09:49:39 am >> DELETE FROM ps_document_detail WHERE id_document = '98376' 06/08/2025 09:49:39 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '98376' , '1914' , 'CERA DELLA LITURGIA' , '36' , '-36' , '1' , '4.7' , '3.8524590163934' , '22' , '0' , '169.20' ) 06/08/2025 09:49:39 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '98376' , '19102' , 'CARBONCINI MM 40' , '1' , '-1' , '1' , '13.00' , '10.655737704918' , '22' , '0' , '13.00' ) 06/08/2025 10:47:36 am >> SELECT document_num FROM ps_document WHERE document_num = '2670' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-08-06') 06/08/2025 10:47: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' , '2670' , '2025-08-06' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '25.90' , '22.65' , NOW() , NOW() ) 06/08/2025 10:47: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 = '98377' 06/08/2025 10:47:36 am >> DELETE FROM ps_document_detail WHERE id_document = '98377' 06/08/2025 10:47: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 ( '98377' , '16409' , 'RICAMBIO VETRO - 32/V' , '1' , '-1' , '1' , '15.90' , '13.032786885246' , '22' , '0' , '15.90' ) 06/08/2025 10:47: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 ( '98377' , '16691' , 'PARTICOLE PER CELIACI 25pz' , '1' , '-1' , '3' , '4.50' , '4.3269230769231' , '4' , '0' , '4.50' ) 06/08/2025 10:47: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 ( '98377' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '1' , '-1' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '3.50' ) 06/08/2025 10:47: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 ( '98377' , '7311' , 'OSTIA SOTTILE 74MM' , '1' , '-1' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '2.00' ) 06/08/2025 10:47:45 am >> SELECT document_num FROM ps_document WHERE document_num = '2671' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-08-06') 06/08/2025 10:47:45 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' , '2671' , '2025-08-06' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '4.00' , '4.00' , NOW() , NOW() ) 06/08/2025 10:47:45 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 = '98378' 06/08/2025 10:47:45 am >> DELETE FROM ps_document_detail WHERE id_document = '98378' 06/08/2025 10:47: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 ( '98378' , '13959' , 'SAN DOMENICO' , '1' , '-1' , '4' , '4.00' , '4' , '0' , '0' , '4.00' ) 06/08/2025 10:49:45 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788831551182' AND id_product != '15468' AND ean13 != '' 06/08/2025 10:49:45 am >> UPDATE ps_product SET id_supplier = '7', reference = '7/3', ean13 = '9788831551182', date_upd = NOW() WHERE id_product = '15468' 06/08/2025 10:49:45 am >> UPDATE ps_product_lang SET name = 'ECCOMI - A. CANOPI', description = '' WHERE id_product = '15468' 06/08/2025 10:49:45 am >> UPDATE ps_product SET wholesale_price = '7.37', on_sale = '0', price = '11.0000' WHERE id_product = '15468' 06/08/2025 10:49:45 am >> UPDATE ps_product_shop SET wholesale_price = '7.37', price = '11.0000', id_tax_rules_group = '4', id_category_default = '27', id_argoment_default = '23', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '15468' 06/08/2025 10:49:45 am >> DELETE FROM ps_specific_price WHERE id_product = '15468' 06/08/2025 10:52:17 am >> SELECT document_num FROM ps_document WHERE document_num = '2672' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-08-06') 06/08/2025 10:52:17 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' , '2672' , '2025-08-06' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '20.90' , '20.90' , NOW() , NOW() ) 06/08/2025 10:52: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 = '98379' 06/08/2025 10:52:17 am >> DELETE FROM ps_document_detail WHERE id_document = '98379' 06/08/2025 10:52: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 ( '98379' , '15468' , 'ECCOMI - A.M. CANOPI' , '2' , '-2' , '4' , '11.00' , '11' , '0' , '5' , '20.90' ) 06/08/2025 10:54:01 am >> DELETE FROM ps_document WHERE id_document = '98349' 06/08/2025 10:54:01 am >> DELETE FROM ps_document_detail WHERE id_document = '98349' 06/08/2025 10:54:12 am >> SELECT document_num FROM ps_document WHERE document_num = '2673' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-08-06') 06/08/2025 10:54:12 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' , '2673' , '2025-08-06' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '50.00' , '40.98' , NOW() , NOW() ) 06/08/2025 10:54:12 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 = '98380' 06/08/2025 10:54:12 am >> DELETE FROM ps_document_detail WHERE id_document = '98380' 06/08/2025 10:54:12 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 ( '98380' , '10495' , 'TECA IHS CM 9 - 881' , '1' , '-1' , '1' , '50' , '40.983606557377' , '22' , '0' , '50.00' ) 06/08/2025 10:54:30 am >> SELECT document_num FROM ps_document WHERE document_num = '2674' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-08-06') 06/08/2025 10:54: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' , '2674' , '2025-08-06' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '23.75' , '23.75' , NOW() , NOW() ) 06/08/2025 10:54: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 = '98381' 06/08/2025 10:54:30 am >> DELETE FROM ps_document_detail WHERE id_document = '98381' 06/08/2025 10:54: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 ( '98381' , '21629' , 'MANUALE DI AMMINISTRAZIONE DELLE PARROCCHIE' , '1' , '-1' , '4' , '25.00' , '25' , '0' , '5' , '23.75' ) 06/08/2025 11:09:22 am >> SELECT document_num FROM ps_document WHERE document_num = '2675' AND id_document != '' AND id_document_type LIKE '12' AND YEAR(document_date) = YEAR('2025-08-06') 06/08/2025 11:09:23 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2675' , '2025-08-06' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '11.00' , '9.02' , NOW() , NOW() ) 06/08/2025 11:09: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 = '98382' 06/08/2025 11:09:23 am >> DELETE FROM ps_document_detail WHERE id_document = '98382' 06/08/2025 11:09: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 ( '98382' , '17349' , 'CROCE TRILOBATA H21 - CL56' , '1' , '-1' , '1' , '11.00' , '9.016393442623' , '22' , '0' , '11.00' ) 06/08/2025 11:11:56 am >> SELECT document_num FROM ps_document WHERE document_num = '2676' AND id_document != '' AND id_document_type LIKE '14' AND YEAR(document_date) = YEAR('2025-08-06') 06/08/2025 11:11:56 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' , '2676' , '2025-08-06' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '26.60' , '24.54' , NOW() , NOW() ) 06/08/2025 11:11: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 = '98383' 06/08/2025 11:11:56 am >> DELETE FROM ps_document_detail WHERE id_document = '98383' 06/08/2025 11:11: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 ( '98383' , '23607' , 'MESSA MEDITAZIONE - LUG/AGO 25' , '1' , '-1' , '4' , '8.00' , '8' , '0' , '5' , '7.60' ) 06/08/2025 11:11: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 ( '98383' , '23867' , 'MESSA MEDITAZIONE - SETT/OTT 25' , '1' , '-1' , '4' , '8.00' , '8' , '0' , '5' , '7.60' ) 06/08/2025 11:11: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 ( '98383' , '15484' , 'CROCE - 076BIS ALV.' , '6' , '-6' , '1' , '1.90' , '1.5573770491803' , '22' , '0' , '11.40' ) 06/08/2025 11:20:57 am >> SELECT document_num FROM ps_document WHERE document_num = '2677' AND id_document != '' AND id_document_type LIKE '12' AND YEAR(document_date) = YEAR('2025-08-06') 06/08/2025 11:20:57 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' , '2677' , '2025-08-06' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '49.00' , '40.16' , NOW() , NOW() ) 06/08/2025 11:20:57 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 = '98384' 06/08/2025 11:20:57 am >> DELETE FROM ps_document_detail WHERE id_document = '98384' 06/08/2025 11:20:57 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 ( '98384' , '780' , 'ASPERGES MAXI CON CUSTODIA - 700' , '1' , '-1' , '1' , '49.00' , '40.16393442623' , '22' , '0' , '49.00' ) 06/08/2025 11:28:57 am >> SELECT document_num FROM ps_document WHERE document_num = '109/A' AND id_document != '' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2025-08-06') 06/08/2025 11:28:57 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '24' , '109/A' , '2025-08-06' , 'A' , '0' , '0' , '0' , 'VIA F. WENNER, 37 84080 PELLEZZANO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '983.80' , '815.77' , NOW() , NOW() ) 06/08/2025 11:28:57 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 = '98385' 06/08/2025 11:28:57 am >> DELETE FROM ps_document_detail WHERE id_document = '98385' 06/08/2025 11:28:57 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 ( '98385' , '12540' , 'COMPLETO AMPOLLE 5 PEZZI - ATD729' , '1' , '-1' , '1' , '285.00' , '233.60655737705' , '22' , '0' , '285.00' ) 06/08/2025 11:28:57 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 ( '98385' , '20117' , 'FATIMA CM 55 - 1036' , '1' , '-1' , '1' , '72.00' , '59.016393442623' , '22' , '0' , '72.00' ) 06/08/2025 11:28:57 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 ( '98385' , '12541' , 'COMPLETO CROCE E CANDELIERE - KOL/M' , '1' , '-1' , '1' , '90.00' , '73.770491803279' , '22' , '0' , '90.00' ) 06/08/2025 11:28:57 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 ( '98385' , '19351' , 'SERVIZIO MESSA MISTO LINO - 7050' , '1' , '-1' , '1' , '52.00' , '42.622950819672' , '22' , '0' , '52.00' ) 06/08/2025 11:28:57 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 ( '98385' , '19149' , 'CANDELE STEREATICHE E/10 TRIB' , '1' , '-1' , '1' , '5.50' , '4.5081967213115' , '22' , '0' , '5.50' ) 06/08/2025 11:28:57 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 ( '98385' , '17864' , 'MESSALE QUOTIDIANO GRANDE - N. E. ' , '1' , '-1' , '4' , '52.00' , '52' , '0' , '0' , '52.00' ) 06/08/2025 11:28:57 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 ( '98385' , '19970' , 'CALICE - ART 715' , '1' , '-1' , '1' , '295.00' , '241.80327868852' , '22' , '0' , '295.00' ) 06/08/2025 11:28:57 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 ( '98385' , '7735' , 'PATENA OTTONE - DIAM. 14 - 900' , '1' , '-1' , '1' , '44.00' , '36.065573770492' , '22' , '0' , '44.00' ) 06/08/2025 11:28:57 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 ( '98385' , '16051' , 'PISSIDE OFFERTORIALE CM 12X9 - 1894' , '1' , '-1' , '1' , '85.00' , '69.672131147541' , '22' , '0' , '85.00' ) 06/08/2025 11:28:57 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 ( '98385' , '22962' , 'VINO BIANCO DOLCE MIGNON' , '1' , '-1' , '1' , '3.30' , '2.7049180327869' , '22' , '0' , '3.30' ) 06/08/2025 11:28:57 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 ( '98385' , '13355' , 'ROSARIO CRISTALLO VARI COLORI - 07777' , '1' , '-1' , '1' , '12.50' , '10.245901639344' , '22' , '100' , '0.00' ) 06/08/2025 11:39:23 am >> SELECT document_num FROM ps_document WHERE document_num = '2678' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-08-06') 06/08/2025 11:39:23 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2678' , '2025-08-06' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '36.00' , '29.51' , NOW() , NOW() ) 06/08/2025 11:39: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 = '98386' 06/08/2025 11:39:23 am >> DELETE FROM ps_document_detail WHERE id_document = '98386' 06/08/2025 11:39: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 ( '98386' , '18133' , 'CROCE SAN BENEDETTO CM 11 - CSB2' , '4' , '-4' , '1' , '9' , '7.3770491803279' , '22' , '0' , '36.00' ) 06/08/2025 11:42:39 am >> SELECT document_num FROM ps_document WHERE document_num = '2679' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-08-06') 06/08/2025 11:42:39 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' , '2679' , '2025-08-06' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '96.00' , '85.07' , NOW() , NOW() ) 06/08/2025 11:42:39 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '98387' 06/08/2025 11:42:39 am >> DELETE FROM ps_document_detail WHERE id_document = '98387' 06/08/2025 11:42:39 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '98387' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '10' , '-10' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '35.00' ) 06/08/2025 11:42:39 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '98387' , '16689' , 'OSTIA PAN DI CENA mm80' , '5' , '-5' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '10.00' ) 06/08/2025 11:42:39 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '98387' , '11384' , 'VINO BIANCO DOLCE - 102' , '6' , '-6' , '1' , '8.5' , '6.9672131147541' , '22' , '0' , '51.00' ) 06/08/2025 11:43:10 am >> SELECT document_num FROM ps_document WHERE document_num = '2680' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-08-06') 06/08/2025 11:43: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' , '2680' , '2025-08-06' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '45.00' , '36.89' , NOW() , NOW() ) 06/08/2025 11:43: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 = '98388' 06/08/2025 11:43:10 am >> DELETE FROM ps_document_detail WHERE id_document = '98388' 06/08/2025 11:43: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 ( '98388' , '22199' , 'VINO LIQUOROSO ROSSO ' , '6' , '-6' , '1' , '7.5' , '6.1475409836066' , '22' , '0' , '45.00' ) 06/08/2025 11:57:34 am >> SELECT document_num FROM ps_document WHERE document_num = '2681' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-08-06') 06/08/2025 11:57:34 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' , '2681' , '2025-08-06' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '7.00' , '6.73' , NOW() , NOW() ) 06/08/2025 11:57:34 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 = '98389' 06/08/2025 11:57:34 am >> DELETE FROM ps_document_detail WHERE id_document = '98389' 06/08/2025 11:57:34 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 ( '98389' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '2' , '-2' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '7.00' ) 06/08/2025 11:59: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 ( '31' , '2060/25' , '2025-08-01' , '25' , '0' , '22' , '2617' , 'C.DA GIOPPO, 11 89040 CIRELLA' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '9' , '0' , '280.69' , '269.89' , NOW() , NOW() ) 06/08/2025 11:59: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 = '98390' 06/08/2025 11:59:43 am >> DELETE FROM ps_document_detail WHERE id_document = '98390' 06/08/2025 11:59: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 ( '98390' , '7311' , 'OSTIA SOTTILE 74MM' , '150' , '150' , '3' , '1.16' , '1.1153846153846' , '4' , '3' , '175.5312' ) 06/08/2025 11:59:43 am >> DELETE FROM ps_product_supplier WHERE id_product = '7311' AND id_supplier = '22' 06/08/2025 11:59:43 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7311' , '22' , '1' ) 06/08/2025 11:59: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 ( '98390' , '16691' , 'PARTICOLE PER CELIACI 25pz' , '50' , '50' , '3' , '1.9' , '1.8269230769231' , '4' , '0' , '98.8000' ) 06/08/2025 11:59:43 am >> DELETE FROM ps_product_supplier WHERE id_product = '16691' AND id_supplier = '22' 06/08/2025 11:59:43 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16691' , '22' , '1' ) 06/08/2025 11:59: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 ( '98390' , '18748' , 'OSTIA MAGNA 125 - OM 125' , '3' , '3' , '3' , '2.1' , '2.0192307692308' , '4' , '3' , '6.3554' ) 06/08/2025 11:59:43 am >> DELETE FROM ps_product_supplier WHERE id_product = '18748' AND id_supplier = '22' 06/08/2025 11:59:43 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18748' , '22' , '1' ) 06/08/2025 12:08:54 pm >> SELECT document_num FROM ps_document WHERE document_num = '2437' AND id_document != '98081' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-07-14') 06/08/2025 12:08:54 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '2437', document_date = '2025-07-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 = '15.00', price_tax_excluded = '12.30', date_upd = NOW() WHERE id_document = '98081' 06/08/2025 12:08:54 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 = '98081' 06/08/2025 12:08:54 pm >> DELETE FROM ps_document_detail WHERE id_document = '98081' 06/08/2025 12:08:54 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 ( '98081' , '6304' , 'MATTHAEUS 25G - CINNAMONO - EVE ' , '1' , '-1' , '1' , '1.5000' , '1.2295081967213' , '22' , '0' , '1.50' ) 06/08/2025 12:08:54 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 ( '98081' , '6207' , 'MARCUS 25G - MENTA - EVE ' , '3' , '-3' , '1' , '1.5000' , '1.2295081967213' , '22' , '0' , '4.50' ) 06/08/2025 12:08:54 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 ( '98081' , '22503' , 'ROSARIO PROFUMATO ROSA MIRACOLOSA - 192/RP6' , '1' , '-1' , '1' , '4' , '3.2786885245902' , '22' , '0' , '4.00' ) 06/08/2025 12:08:54 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 ( '98081' , '19599' , 'ROSARIO PER LA PRIMA COMUNIONE - 197/13' , '1' , '-1' , '1' , '2.5' , '2.0491803278689' , '22' , '0' , '2.50' ) 06/08/2025 12:08:54 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 ( '98081' , '20515' , 'DECINA ULIVO - 04/7-D' , '5' , '-5' , '1' , '0.50' , '0.40983606557377' , '22' , '0' , '2.50' ) 06/08/2025 12:13:47 pm >> SELECT document_num FROM ps_document WHERE document_num = '2682' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-08-06') 06/08/2025 12:13: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' , '2682' , '2025-08-06' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '47.50' , '47.50' , NOW() , NOW() ) 06/08/2025 12:13: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 = '98391' 06/08/2025 12:13:47 pm >> DELETE FROM ps_document_detail WHERE id_document = '98391' 06/08/2025 12:13: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 ( '98391' , '23714' , 'SULLA TUA PAROLA - SETT/OTT 25' , '10' , '-10' , '4' , '5.00' , '5' , '0' , '5' , '47.50' ) 06/08/2025 12:22:56 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 ( '32' , '521' , '2025-07-31' , '' , '0' , '60' , '2655' , 'Z.I. PIANE MAVONE 64042 COLLEDARA' , '' , '' , '27.5' , '1' , '0' , '0' , '0' , '' , '0' , '0' , '2349.05' , '1925.45' , NOW() , NOW() ) 06/08/2025 12:22:56 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 = '98392' 06/08/2025 12:22:56 pm >> DELETE FROM ps_document_detail WHERE id_document = '98392' 06/08/2025 12:22:56 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 ( '98392' , '23895' , 'PORTACHIAVI SAN ROCCO - 100/6569P' , '183' , '0' , '1' , '0.6000' , '0.4918' , '22' , '0' , '133.96' ) 06/08/2025 12:22:56 pm >> DELETE FROM ps_product_supplier WHERE id_product = '23895' AND id_supplier = '60' 06/08/2025 12:22:56 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23895' , '60' , '1' ) 06/08/2025 12:22:56 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 ( '98392' , '23896' , 'MAGNETE SAN ROCCO - 1181-0' , '109' , '0' , '1' , '0.5500' , '0.4508' , '22' , '0' , '73.14' ) 06/08/2025 12:22:56 pm >> DELETE FROM ps_product_supplier WHERE id_product = '23896' AND id_supplier = '60' 06/08/2025 12:22:56 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23896' , '60' , '1' ) 06/08/2025 12:22:56 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 ( '98392' , '23897' , 'QUADRETTO CON FIOCCO S. ROCCO - 12/39-C' , '25' , '0' , '1' , '1.4000' , '1.1475' , '22' , '0' , '42.70' ) 06/08/2025 12:22:56 pm >> DELETE FROM ps_product_supplier WHERE id_product = '23897' AND id_supplier = '60' 06/08/2025 12:22:56 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23897' , '60' , '1' ) 06/08/2025 12:22:56 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 ( '98392' , '23898' , 'QUADRETTO CON FIOCCO S. ROCCO - 12/39-R' , '24' , '0' , '1' , '1.4000' , '1.1475' , '22' , '0' , '40.99' ) 06/08/2025 12:22:56 pm >> DELETE FROM ps_product_supplier WHERE id_product = '23898' AND id_supplier = '60' 06/08/2025 12:22:56 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23898' , '60' , '1' ) 06/08/2025 12:22:56 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 ( '98392' , '23899' , 'ROSARIO SAN ROCCO - 163/8' , '36' , '0' , '1' , '2.2000' , '1.8033' , '22' , '0' , '96.62' ) 06/08/2025 12:22:56 pm >> DELETE FROM ps_product_supplier WHERE id_product = '23899' AND id_supplier = '60' 06/08/2025 12:22:56 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23899' , '60' , '1' ) 06/08/2025 12:22:56 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 ( '98392' , '23900' , 'BRACCIALE 1/2 CRISTALLO - 20/6-B' , '48' , '0' , '1' , '1.1000' , '0.9016' , '22' , '0' , '64.42' ) 06/08/2025 12:22:56 pm >> DELETE FROM ps_product_supplier WHERE id_product = '23900' AND id_supplier = '60' 06/08/2025 12:22:56 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23900' , '60' , '1' ) 06/08/2025 12:22:56 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 ( '98392' , '23901' , 'MEDAGLIA SAN ROCCO SMALTATA - 400/6573M' , '200' , '0' , '1' , '0.2100' , '0.1721' , '22' , '0' , '51.24' ) 06/08/2025 12:22:56 pm >> DELETE FROM ps_product_supplier WHERE id_product = '23901' AND id_supplier = '60' 06/08/2025 12:22:56 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23901' , '60' , '1' ) 06/08/2025 12:22:56 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 ( '98392' , '23902' , 'BRACCIALE SAN ROCCO - 800/CA4' , '36' , '0' , '1' , '1.3000' , '1.0656' , '22' , '0' , '57.10' ) 06/08/2025 12:22:56 pm >> DELETE FROM ps_product_supplier WHERE id_product = '23902' AND id_supplier = '60' 06/08/2025 12:22:56 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23902' , '60' , '1' ) 06/08/2025 12:22:56 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 ( '98392' , '23903' , 'BRACCIALE CON MEDAGLIA SAN ROCCO - 800/W2158-RH' , '12' , '0' , '1' , '1.3000' , '1.0656' , '22' , '0' , '19.03' ) 06/08/2025 12:22:56 pm >> DELETE FROM ps_product_supplier WHERE id_product = '23903' AND id_supplier = '60' 06/08/2025 12:22:56 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23903' , '60' , '1' ) 06/08/2025 12:22:56 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 ( '98392' , '22653' , 'GIROCOLLO PERSONALIZZATO SAN ROCCO' , '48' , '0' , '1' , '1.5000' , '1.2295' , '22' , '0' , '87.84' ) 06/08/2025 12:22:57 pm >> DELETE FROM ps_product_supplier WHERE id_product = '22653' AND id_supplier = '60' 06/08/2025 12:22:57 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22653' , '60' , '1' ) 06/08/2025 12:22:57 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 ( '98392' , '23904' , 'ROSARIO CRISTALLO - 194/04-PP6' , '36' , '0' , '1' , '2.0000' , '1.6393' , '22' , '0' , '87.84' ) 06/08/2025 12:22:57 pm >> DELETE FROM ps_product_supplier WHERE id_product = '23904' AND id_supplier = '60' 06/08/2025 12:22:57 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23904' , '60' , '1' ) 06/08/2025 12:22:57 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 ( '98392' , '1310' , 'BRACCIALE CORDA SAN BENEDETTO - 800/N16' , '72' , '0' , '1' , '0.8000' , '0.6557' , '22' , '0' , '70.27' ) 06/08/2025 12:22:57 pm >> DELETE FROM ps_product_supplier WHERE id_product = '1310' AND id_supplier = '60' 06/08/2025 12:22:57 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '1310' , '60' , '1' ) 06/08/2025 12:22:57 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 ( '98392' , '23905' , 'BRACCIALE IN GOMMA - 800/385' , '200' , '0' , '1' , '0.6200' , '0.5082' , '22' , '0' , '151.28' ) 06/08/2025 12:22:57 pm >> DELETE FROM ps_product_supplier WHERE id_product = '23905' AND id_supplier = '60' 06/08/2025 12:22:57 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23905' , '60' , '1' ) 06/08/2025 12:22:57 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 ( '98392' , '1312' , 'BRACCIALE DECINA - 800/286' , '200' , '0' , '1' , '0.5000' , '0.4098' , '22' , '0' , '122.00' ) 06/08/2025 12:22:57 pm >> DELETE FROM ps_product_supplier WHERE id_product = '1312' AND id_supplier = '60' 06/08/2025 12:22:57 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '1312' , '60' , '1' ) 06/08/2025 12:22:57 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 ( '98392' , '23907' , 'CROCIFISSO CON BASE - 519/NB' , '10' , '0' , '1' , '3.0000' , '2.459' , '22' , '0' , '36.60' ) 06/08/2025 12:22:57 pm >> DELETE FROM ps_product_supplier WHERE id_product = '23907' AND id_supplier = '60' 06/08/2025 12:22:57 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23907' , '60' , '1' ) 06/08/2025 12:22:57 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 ( '98392' , '23909' , 'CORONA CON CONF. VETRO - 40/CN12' , '144' , '0' , '1' , '1.0000' , '0.8197' , '22' , '0' , '175.68' ) 06/08/2025 12:22:57 pm >> DELETE FROM ps_product_supplier WHERE id_product = '23909' AND id_supplier = '60' 06/08/2025 12:22:57 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23909' , '60' , '1' ) 06/08/2025 12:22:57 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 ( '98392' , '23910' , 'DECINA CON VETRO - 194/15' , '360' , '0' , '1' , '0.7000' , '0.5738' , '22' , '0' , '307.44' ) 06/08/2025 12:22:57 pm >> DELETE FROM ps_product_supplier WHERE id_product = '23910' AND id_supplier = '60' 06/08/2025 12:22:57 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23910' , '60' , '1' ) 06/08/2025 12:22:57 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 ( '98392' , '23912' , 'DECINA ULIVO -194/9T4UD' , '48' , '0' , '1' , '1.0000' , '0.8197' , '22' , '0' , '58.56' ) 06/08/2025 12:22:57 pm >> DELETE FROM ps_product_supplier WHERE id_product = '23912' AND id_supplier = '60' 06/08/2025 12:22:57 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23912' , '60' , '1' ) 06/08/2025 12:22:57 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 ( '98392' , '23913' , 'ROSARIO ULIVO - 193/9-T4U' , '28' , '0' , '1' , '2.9500' , '2.418' , '22' , '0' , '100.77' ) 06/08/2025 12:22:57 pm >> DELETE FROM ps_product_supplier WHERE id_product = '23913' AND id_supplier = '60' 06/08/2025 12:22:57 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23913' , '60' , '1' ) 06/08/2025 12:22:57 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 ( '98392' , '23914' , 'DECINA ROSARIO - 142/6-D' , '360' , '0' , '1' , '0.4000' , '0.3279' , '22' , '0' , '175.68' ) 06/08/2025 12:22:57 pm >> DELETE FROM ps_product_supplier WHERE id_product = '23914' AND id_supplier = '60' 06/08/2025 12:22:57 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23914' , '60' , '1' ) 06/08/2025 12:22:57 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 ( '98392' , '15096' , 'CORONA MATRIMONIO - ARG ' , '24' , '0' , '1' , '3.0000' , '2.459' , '22' , '0' , '87.84' ) 06/08/2025 12:22:57 pm >> DELETE FROM ps_product_supplier WHERE id_product = '15096' AND id_supplier = '60' 06/08/2025 12:22:58 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '15096' , '60' , '1' ) 06/08/2025 12:22: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 ( '98392' , '2766' , 'CORONA PLASTICA VARI COLORI - 07' , '2500' , '0' , '1' , '0.0900' , '0.0738' , '22' , '0' , '274.50' ) 06/08/2025 12:22:58 pm >> DELETE FROM ps_product_supplier WHERE id_product = '2766' AND id_supplier = '60' 06/08/2025 12:22:58 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '2766' , '60' , '1' ) 06/08/2025 12:50:04 pm >> SELECT document_num FROM ps_document WHERE document_num = '2683' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-08-06') 06/08/2025 12:50:04 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' , '2683' , '2025-08-06' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '15.70' , '15.70' , NOW() , NOW() ) 06/08/2025 12:50:04 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 = '98393' 06/08/2025 12:50:04 pm >> DELETE FROM ps_document_detail WHERE id_document = '98393' 06/08/2025 12:50:04 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 ( '98393' , '21410' , 'IO E CARLO - M. PAPPALARDO' , '1' , '-1' , '4' , '11.90' , '11.9' , '0' , '0' , '11.90' ) 06/08/2025 12:50:04 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 ( '98393' , '12255' , 'IN CAMMINO CON GESU' , '1' , '-1' , '4' , '3.80' , '3.8' , '0' , '0' , '3.80' ) 06/08/2025 12:54:51 pm >> SELECT document_num FROM ps_document WHERE document_num = '2684' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-08-06') 06/08/2025 12:54:51 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2684' , '2025-08-06' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '87.00' , '85.56' , NOW() , NOW() ) 06/08/2025 12:54:51 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '98394' 06/08/2025 12:54:51 pm >> DELETE FROM ps_document_detail WHERE id_document = '98394' 06/08/2025 12:54:51 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '98394' , '20953' , 'VANGELO E ATTI DEGLI APOSTOLI' , '20' , '-20' , '4' , '2.4' , '2.4' , '0' , '0' , '48.00' ) 06/08/2025 12:54:51 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '98394' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '1.5' , '1.5' , '0' , '0' , '1.50' ) 06/08/2025 12:54:51 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '98394' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '5' , '-5' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '17.50' ) 06/08/2025 12:54:51 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '98394' , '16689' , 'OSTIA PAN DI CENA mm80' , '10' , '-10' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '20.00' ) 06/08/2025 01:01:46 pm >> SELECT document_num FROM ps_document WHERE document_num = '2685' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-08-06') 06/08/2025 01:01:46 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' , '2685' , '2025-08-06' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '5.00' , '5.00' , NOW() , NOW() ) 06/08/2025 01:01:46 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 = '98395' 06/08/2025 01:01:46 pm >> DELETE FROM ps_document_detail WHERE id_document = '98395' 06/08/2025 01:01:46 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 ( '98395' , '5876' , 'LITANIE ALLA VERGINE MARIA' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '0' , '5.00' ) 06/08/2025 01:13:10 pm >> SELECT document_num FROM ps_document WHERE document_num = '2686' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-08-06') 06/08/2025 01:13: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' , '2686' , '2025-08-06' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '22.50' , '18.44' , NOW() , NOW() ) 06/08/2025 01:13: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 = '98396' 06/08/2025 01:13:10 pm >> DELETE FROM ps_document_detail WHERE id_document = '98396' 06/08/2025 01:13: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 ( '98396' , '15097' , 'CORONA MATRIMONIO - ORO - 197/34' , '1' , '-1' , '1' , '7.50' , '6.1475409836066' , '22' , '0' , '7.50' ) 06/08/2025 01:13: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 ( '98396' , '15096' , 'CORONA MATRIMONIO ARG - 197/35' , '2' , '-2' , '1' , '7.50' , '6.1475409836066' , '22' , '0' , '15.00' )