23/12/2025 09:04:41 am >> SELECT document_num FROM ps_document WHERE document_num = '4376' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-12-23') 23/12/2025 09:04:42 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' , '4376' , '2025-12-23' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '22.52' , '22.52' , NOW() , NOW() ) 23/12/2025 09:04:42 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '100655' 23/12/2025 09:04:42 am >> DELETE FROM ps_document_detail WHERE id_document = '100655' 23/12/2025 09:04:42 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100655' , '8488' , 'PRIMA CONFESSIONE E MESSA PRIMA COMUNIONE' , '2' , '-2' , '4' , '2.40' , '2.4' , '0' , '5' , '4.56' ) 23/12/2025 09:04:42 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100655' , '24449' , 'PRATICA DELLA PRESENZA DI DIO - FRA LORENZO' , '1' , '-1' , '4' , '11.00' , '11' , '0' , '5' , '10.45' ) 23/12/2025 09:04:42 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100655' , '24069' , 'CINQUE PANI DORZO 2026' , '1' , '-1' , '4' , '7.90' , '7.9' , '0' , '5' , '7.51' ) 23/12/2025 09:22:28 am >> SELECT ean13 FROM ps_product WHERE ean13 = '000133' AND id_product != '24433' AND ean13 != '' 23/12/2025 09:22:28 am >> UPDATE ps_product SET id_supplier = '31', reference = '', ean13 = '000133', date_upd = NOW() WHERE id_product = '24433' 23/12/2025 09:22:28 am >> UPDATE ps_product_lang SET name = 'LITURGICO CARTA - KING CELLOPHANE', description = '' WHERE id_product = '24433' 23/12/2025 09:22:28 am >> UPDATE ps_product SET wholesale_price = '2.10', on_sale = '0', price = '3.278688524590164' WHERE id_product = '24433' 23/12/2025 09:22:28 am >> UPDATE ps_product_shop SET wholesale_price = '2.10', price = '3.278688524590164', id_tax_rules_group = '1', id_category_default = '169', id_argoment_default = '42', id_internal_category = '3', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '24433' 23/12/2025 09:22:28 am >> DELETE FROM ps_specific_price WHERE id_product = '24433' 23/12/2025 09:25:54 am >> SELECT document_num FROM ps_document WHERE document_num = '4377' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-12-23') 23/12/2025 09:25:54 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' , '4377' , '2025-12-23' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '109.32' , '90.10' , NOW() , NOW() ) 23/12/2025 09:25:54 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 = '100656' 23/12/2025 09:25:54 am >> DELETE FROM ps_document_detail WHERE id_document = '100656' 23/12/2025 09:25:54 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 ( '100656' , '24433' , 'LITURGICO CARTA - KING CELLOPHANE' , '25' , '-25' , '1' , '3.7' , '3.0327868852459' , '22' , '0' , '92.50' ) 23/12/2025 09:25:54 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 ( '100656' , '17617' , 'IMMAGINI ISONZO X 100' , '4' , '-4' , '1' , '3.33' , '2.7295081967213' , '22' , '0' , '13.32' ) 23/12/2025 09:25:54 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 ( '100656' , '20433' , 'PARTICOLA MORREALE 38MM - PTC38S' , '1' , '-1' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '3.50' ) 23/12/2025 09:42:40 am >> SELECT document_num FROM ps_document WHERE document_num = '4378' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-12-23') 23/12/2025 09:42:40 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' , '4378' , '2025-12-23' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '14.00' , '14.00' , NOW() , NOW() ) 23/12/2025 09:42:40 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 = '100657' 23/12/2025 09:42:40 am >> DELETE FROM ps_document_detail WHERE id_document = '100657' 23/12/2025 09:42:40 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 ( '100657' , '23966' , 'ARMARSI CON CINQUE CIOTTOLI - R. FACCENDA' , '1' , '-1' , '4' , '14.00' , '14' , '0' , '0' , '14.00' ) 23/12/2025 10:16:27 am >> SELECT document_num FROM ps_document WHERE document_num = '4379' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-12-23') 23/12/2025 10:16:27 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' , '4379' , '2025-12-23' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '11.00' , '9.02' , NOW() , NOW() ) 23/12/2025 10:16:27 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 = '100658' 23/12/2025 10:16:27 am >> DELETE FROM ps_document_detail WHERE id_document = '100658' 23/12/2025 10:16:28 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 ( '100658' , '17160' , 'CARBONCINI ROSSI - CARRO' , '1' , '-1' , '1' , '11.00' , '9.016393442623' , '22' , '0' , '11.00' ) 23/12/2025 10:23:53 am >> SELECT document_num FROM ps_document WHERE document_num = '160/A' AND id_document != '' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2025-12-23') 23/12/2025 10:23: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 ( '24' , '160/A' , '2025-12-23' , 'A' , '204' , '0' , '4671483' , 'VIA ROBERTO IL GUISCARDO, 3 84121 SALERNO' , '' , 'campolongo' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '174.70' , '143.20' , NOW() , NOW() ) 23/12/2025 10:23: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 = '100659' 23/12/2025 10:23:53 am >> DELETE FROM ps_document_detail WHERE id_document = '100659' 23/12/2025 10:23: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 ( '100659' , '7202' , 'ARTICOLI RELIGIOSI culla' , '1' , '-1' , '1' , '25' , '20.491803278689' , '22' , '0' , '25.00' ) 23/12/2025 10:23: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 ( '100659' , '11384' , 'VINO BIANCO DOLCE - 102' , '3' , '-3' , '1' , '8.90' , '7.2950819672131' , '22' , '0' , '26.70' ) 23/12/2025 10:23: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 ( '100659' , '23223' , 'COPRILEGGIO - CL10' , '1' , '-1' , '1' , '55.00' , '45.081967213115' , '22' , '0' , '55.00' ) 23/12/2025 10:23: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 ( '100659' , '23840' , 'COPRI LEGGIO - 331/TP' , '1' , '-1' , '1' , '68.00' , '55.737704918033' , '22' , '0' , '68.00' ) 23/12/2025 10:24:24 am >> SELECT document_num FROM ps_document WHERE document_num = '4380' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-12-23') 23/12/2025 10:24:24 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '4380' , '2025-12-23' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '37.00' , '30.33' , NOW() , NOW() ) 23/12/2025 10:24:24 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '100660' 23/12/2025 10:24:24 am >> DELETE FROM ps_document_detail WHERE id_document = '100660' 23/12/2025 10:24:24 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100660' , '18682' , 'CLERGY ROMANO ML - C17' , '1' , '-1' , '1' , '37' , '30.327868852459' , '22' , '0' , '37.00' ) 23/12/2025 10:35:20 am >> SELECT document_num FROM ps_document WHERE document_num = '4381' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-12-23') 23/12/2025 10:35:20 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' , '4381' , '2025-12-23' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '51.70' , '45.97' , NOW() , NOW() ) 23/12/2025 10:35:20 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 = '100661' 23/12/2025 10:35:20 am >> DELETE FROM ps_document_detail WHERE id_document = '100661' 23/12/2025 10:35:20 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 ( '100661' , '24210' , 'LIBERI DI AMARE - CHIARA AMIRANTE' , '1' , '-1' , '4' , '12.90' , '12.9' , '0' , '0' , '12.90' ) 23/12/2025 10:35:20 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 ( '100661' , '14143' , 'SAN FRANCESCO D\'ASSISI - RACCONTATO AI RAGAZZI' , '1' , '-1' , '4' , '4.00' , '4' , '0' , '0' , '4.00' ) 23/12/2025 10:35:20 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 ( '100661' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '1.8' , '1.4754098360656' , '22' , '0' , '1.80' ) 23/12/2025 10:35:20 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 ( '100661' , '15414' , 'CROCE VETRO CM 25 LINEA ROMA' , '1' , '-1' , '1' , '30' , '24.590163934426' , '22' , '0' , '30.00' ) 23/12/2025 10:35:20 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 ( '100661' , '20896' , 'SANTI DEL MESSALINO. MONICA LA VITA 8467' , '1' , '-1' , '4' , '3.00' , '3' , '0' , '0' , '3.00' ) 23/12/2025 10:37:40 am >> SELECT document_num FROM ps_document WHERE document_num = '4382' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-12-23') 23/12/2025 10:37:40 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' , '4382' , '2025-12-23' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '14.84' , '14.84' , NOW() , NOW() ) 23/12/2025 10:37:40 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 = '100662' 23/12/2025 10:37:40 am >> DELETE FROM ps_document_detail WHERE id_document = '100662' 23/12/2025 10:37:40 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 ( '100662' , '24351' , 'AMEN - GEN 26' , '2' , '-2' , '4' , '3.90' , '3.9' , '0' , '5' , '7.42' ) 23/12/2025 10:37:40 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 ( '100662' , '24352' , 'AMEN - FEB 26' , '2' , '-2' , '4' , '3.90' , '3.9' , '0' , '5' , '7.42' ) 23/12/2025 10:41:04 am >> SELECT document_num FROM ps_document WHERE document_num = '160/A' AND id_document != '100659' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2025-12-23') 23/12/2025 10:41:04 am >> UPDATE ps_document SET id_document_type = '24', document_num = '160/A', document_date = '2025-12-23', document_letter = 'A', id_customer = '204', id_supplier = '', id_address = '4671483', address1 = 'VIA ROBERTO IL GUISCARDO, 3 84121 SALERNO', address2 = '', note = 'campolongo', 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 = '204.70', price_tax_excluded = '173.20', date_upd = NOW() WHERE id_document = '100659' 23/12/2025 10:41:04 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '100659' 23/12/2025 10:41:05 am >> DELETE FROM ps_document_detail WHERE id_document = '100659' 23/12/2025 10:41:05 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100659' , '7202' , 'ARTICOLI RELIGIOSI culla' , '1' , '-1' , '1' , '25.0000' , '20.491803278689' , '22' , '0' , '25.00' ) 23/12/2025 10:41:05 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100659' , '11384' , 'VINO BIANCO DOLCE - 102' , '3' , '-3' , '1' , '8.9000' , '7.2950819672131' , '22' , '0' , '26.70' ) 23/12/2025 10:41:05 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100659' , '23223' , 'COPRILEGGIO - CL10' , '1' , '-1' , '1' , '55.0000' , '45.081967213115' , '22' , '0' , '55.00' ) 23/12/2025 10:41:05 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100659' , '23840' , 'COPRI LEGGIO - 331/TP' , '1' , '-1' , '1' , '68.0000' , '55.737704918033' , '22' , '0' , '68.00' ) 23/12/2025 10:41:05 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100659' , '21612' , 'RITO ESEQUIE - ED. MIN.- N.E.' , '1' , '-1' , '4' , '30.00' , '30' , '0' , '0' , '30.00' ) 23/12/2025 10:47:39 am >> SELECT document_num FROM ps_document WHERE document_num = '4383' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-12-23') 23/12/2025 10:47: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' , '4383' , '2025-12-23' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '245.00' , '200.82' , NOW() , NOW() ) 23/12/2025 10:47: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 = '100663' 23/12/2025 10:47:39 am >> DELETE FROM ps_document_detail WHERE id_document = '100663' 23/12/2025 10:47: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 ( '100663' , '13565' , 'NAVETTA CLASSICA CM 13 - 10-460' , '1' , '-1' , '1' , '40' , '32.786885245902' , '22' , '0' , '40.00' ) 23/12/2025 10:47: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 ( '100663' , '18903' , 'TURIBOLO CM 28' , '1' , '-1' , '1' , '180' , '147.54098360656' , '22' , '0' , '180.00' ) 23/12/2025 10:47: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 ( '100663' , '19102' , 'CARBONCINI MM 40' , '2' , '-2' , '1' , '12.5' , '10.245901639344' , '22' , '0' , '25.00' ) 23/12/2025 10:54:05 am >> SELECT document_num FROM ps_document WHERE document_num = '4384' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-12-23') 23/12/2025 10:54:05 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '4384' , '2025-12-23' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '28.80' , '25.59' , NOW() , NOW() ) 23/12/2025 10:54:05 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '100664' 23/12/2025 10:54:05 am >> DELETE FROM ps_document_detail WHERE id_document = '100664' 23/12/2025 10:54:05 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100664' , '15020' , 'PREGARE OGNI GIORNO' , '2' , '-2' , '4' , '1.00' , '1' , '0' , '0' , '2.00' ) 23/12/2025 10:54:05 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100664' , '21760' , 'QUANDO LAMORE E PER SEMPRE - B. BAFFETTI' , '1' , '-1' , '4' , '9.00' , '9' , '0' , '0' , '9.00' ) 23/12/2025 10:54:05 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100664' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '3.8' , '3.1147540983607' , '22' , '0' , '3.80' ) 23/12/2025 10:54:05 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100664' , '18141' , 'TAU SNODATO PADRE NOSTRO GRANDE' , '1' , '-1' , '1' , '14.00' , '11.475409836066' , '22' , '0' , '14.00' ) 23/12/2025 11:01:39 am >> SELECT document_num FROM ps_document WHERE document_num = '4385' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-12-23') 23/12/2025 11:01: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' , '4385' , '2025-12-23' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '11.30' , '9.26' , NOW() , NOW() ) 23/12/2025 11:01: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 = '100665' 23/12/2025 11:01:39 am >> DELETE FROM ps_document_detail WHERE id_document = '100665' 23/12/2025 11:01: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 ( '100665' , '24279' , 'GRUPPO NATIVITA CM 14 - PB19860' , '1' , '-1' , '1' , '9.50' , '7.7868852459016' , '22' , '0' , '9.50' ) 23/12/2025 11:01: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 ( '100665' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '1.8' , '1.4754098360656' , '22' , '0' , '1.80' ) 23/12/2025 11:14:22 am >> SELECT document_num FROM ps_document WHERE document_num = '4386' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-12-23') 23/12/2025 11:14:22 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' , '4386' , '2025-12-23' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '207.00' , '173.79' , NOW() , NOW() ) 23/12/2025 11:14: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 = '100666' 23/12/2025 11:14:22 am >> DELETE FROM ps_document_detail WHERE id_document = '100666' 23/12/2025 11:14: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 ( '100666' , '8936' , 'ANTIVENTO PER TORCIA ORO DIAM. 4 - 33' , '2' , '-2' , '1' , '50.00' , '40.983606557377' , '22' , '0' , '100.00' ) 23/12/2025 11:14: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 ( '100666' , '23034' , 'FINTA CANDELA COMPLETA DI CARTUCCIA 4X100 - 1143' , '2' , '-2' , '1' , '39.00' , '31.967213114754' , '22' , '0' , '78.00' ) 23/12/2025 11:14: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 ( '100666' , '16689' , 'OSTIA PAN DI CENA mm80' , '4' , '-4' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '8.00' ) 23/12/2025 11:14: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 ( '100666' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '6' , '-6' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '21.00' ) 23/12/2025 11:19:40 am >> SELECT document_num FROM ps_document WHERE document_num = '4387' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-12-23') 23/12/2025 11:19:40 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' , '4387' , '2025-12-23' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '5.00' , '5.00' , NOW() , NOW() ) 23/12/2025 11:19:40 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 = '100667' 23/12/2025 11:19:40 am >> DELETE FROM ps_document_detail WHERE id_document = '100667' 23/12/2025 11:19:40 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 ( '100667' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '5' , '5' , '0' , '0' , '5.00' ) 23/12/2025 11:30:11 am >> SELECT document_num FROM ps_document WHERE document_num = '150/A' AND id_document != '100243' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2025-12-03') 23/12/2025 11:30:11 am >> UPDATE ps_document SET id_document_type = '24', document_num = '150/A', document_date = '2025-12-03', document_letter = 'A', id_customer = '2332', id_supplier = '', id_address = '4679092', address1 = 'P.ZZA S. ROCCO 84088 SIANO', address2 = '', note = 'acconto 133,85', 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 = '793.70', price_tax_excluded = '661.88', date_upd = NOW() WHERE id_document = '100243' 23/12/2025 11:30:11 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '100243' 23/12/2025 11:30:11 am >> DELETE FROM ps_document_detail WHERE id_document = '100243' 23/12/2025 11:30:11 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100243' , '20156' , 'PALLA E STELLE CON CARTONCINO - 23' , '30' , '-30' , '1' , '2.0000' , '1.6393442622951' , '22' , '0' , '60.00' ) 23/12/2025 11:30:11 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100243' , '24179' , 'DILEXI TE' , '24' , '-24' , '4' , '2.0000' , '2' , '0' , '5' , '45.60' ) 23/12/2025 11:30:11 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100243' , '1350' , 'BRACCIALETTO CON CROCE - 29002 03' , '27' , '-27' , '1' , '3.0000' , '2.4590163934426' , '22' , '0' , '81.00' ) 23/12/2025 11:30: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 ( '100243' , '1351' , 'BRACCIALETTO CON TAU - 29002 03' , '2' , '-2' , '1' , '3.0000' , '2.4590163934426' , '22' , '0' , '6.00' ) 23/12/2025 11:30: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 ( '100243' , '12527' , 'LAMPADA A SFERA VIOLA' , '1' , '-1' , '1' , '25.0000' , '20.491803278689' , '22' , '0' , '25.00' ) 23/12/2025 11:30: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 ( '100243' , '22548' , 'ROSARIO LEGNO - MM8 - R178' , '50' , '-50' , '1' , '1.2000' , '0.98360655737705' , '22' , '0' , '60.00' ) 23/12/2025 11:30: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 ( '100243' , '17483' , 'LAMPADA IHS - 097DP1K' , '1' , '-1' , '1' , '95.0000' , '77.868852459016' , '22' , '0' , '95.00' ) 23/12/2025 11:30: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 ( '100243' , '6811' , 'MOCCOLO 80X200' , '4' , '-4' , '1' , '9.5000' , '7.7868852459016' , '22' , '0' , '38.00' ) 23/12/2025 11:30: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 ( '100243' , '19107' , 'INCENSO GRANI 3A - BUSTA' , '1' , '-1' , '1' , '30.0000' , '24.590163934426' , '22' , '0' , '30.00' ) 23/12/2025 11:30: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 ( '100243' , '1710' , 'CARBONCINI PER TURIBOLO BIANCHI - PZ 120' , '1' , '-1' , '1' , '13.0000' , '10.655737704918' , '22' , '0' , '13.00' ) 23/12/2025 11:30: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 ( '100243' , '1750' , 'CARTUCCIA TRASPARENTE DIAM. 3,2 - 454' , '4' , '-4' , '1' , '14.0000' , '11.475409836066' , '22' , '0' , '56.00' ) 23/12/2025 11:30: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 ( '100243' , '17617' , 'IMMAGINI ISONZO X 100' , '2' , '-2' , '1' , '3.6000' , '2.9508196721311' , '22' , '0' , '7.20' ) 23/12/2025 11:30: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 ( '100243' , '0' , 'BAMBINO BETLEMME CM 40' , '1' , '-1' , '1' , '48.0000' , '39.344262295082' , '22' , '0' , '48.00' ) 23/12/2025 11:30: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 ( '100243' , '' , '23/12' , '1' , '-1' , '0' , '0' , '0' , '' , '0' , '0' ) 23/12/2025 11:30: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 ( '100243' , '17617' , 'IMMAGINI ISONZO X 100' , '10' , '-10' , '1' , '3.33' , '2.7295081967213' , '22' , '0' , '33.30' ) 23/12/2025 11:30: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 ( '100243' , '24309' , 'NON PERFETTI, MA FELICI - M. DAVIDE' , '1' , '-1' , '4' , '18.00' , '18' , '0' , '5' , '17.10' ) 23/12/2025 11:30: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 ( '100243' , '18122' , 'ROCCA STOPPINO M. 100 - 469/100' , '5' , '-5' , '1' , '1.10' , '0.9016393442623' , '22' , '0' , '5.50' ) 23/12/2025 11:30: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 ( '100243' , '15387' , 'VESTINA BATTESIMALE ' , '40' , '-40' , '1' , '2.5' , '2.0491803278689' , '22' , '0' , '100.00' ) 23/12/2025 11:30: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 ( '100243' , '791' , 'ASSISI IN BUSTA BATTESIMO - 20X270 - BAAS' , '40' , '-40' , '1' , '1.50' , '1.2295081967213' , '22' , '0' , '60.00' ) 23/12/2025 11:30: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 ( '100243' , '19102' , 'CARBONCINI MM 40' , '1' , '-1' , '1' , '13.00' , '10.655737704918' , '22' , '0' , '13.00' ) 23/12/2025 11:41:50 am >> SELECT document_num FROM ps_document WHERE document_num = '4388' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-12-23') 23/12/2025 11:41:50 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '4388' , '2025-12-23' , '' , '0' , '0' , '0' , 'P.ZZA S. ROCCO 84088 SIANO' , '' , '' , '0.00' , '4' , '0' , '0' , '0' , '' , '3' , '0' , '659.85' , '552.17' , NOW() , NOW() ) 23/12/2025 11:41:50 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '100668' 23/12/2025 11:41:50 am >> DELETE FROM ps_document_detail WHERE id_document = '100668' 23/12/2025 11:41:50 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100668' , '20156' , 'PALLA E STELLE CON CARTONCINO - 23' , '30' , '-30' , '1' , '2.0000' , '1.6393' , '22' , '0' , '60.00' ) 23/12/2025 11:41:50 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100668' , '24179' , 'DILEXI TE' , '24' , '-24' , '4' , '2.0000' , '2' , '0' , '5' , '45.60' ) 23/12/2025 11:41:50 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100668' , '1350' , 'BRACCIALETTO CON CROCE - 29002 03' , '27' , '-27' , '1' , '2.5' , '2.0491803278689' , '22' , '0' , '67.50' ) 23/12/2025 11:41:50 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100668' , '1351' , 'BRACCIALETTO CON TAU - 29002 03' , '2' , '-2' , '1' , '3.0000' , '2.459' , '22' , '0' , '6.00' ) 23/12/2025 11:41:50 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100668' , '22548' , 'ROSARIO LEGNO - MM8 - R178' , '50' , '-50' , '1' , '1' , '0.81967213114754' , '22' , '0' , '50.00' ) 23/12/2025 11:41:50 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100668' , '17483' , 'LAMPADA IHS - 097DP1K' , '1' , '-1' , '1' , '80.69' , '66.139344262295' , '22' , '0' , '80.69' ) 23/12/2025 11:41:50 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100668' , '6811' , 'MOCCOLO 80X200' , '4' , '-4' , '1' , '9.5000' , '7.7869' , '22' , '0' , '38.00' ) 23/12/2025 11:41:50 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100668' , '19107' , 'INCENSO GRANI 3A - BUSTA' , '1' , '-1' , '1' , '30.0000' , '24.5902' , '22' , '0' , '30.00' ) 23/12/2025 11:41:50 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100668' , '1710' , 'CARBONCINI PER TURIBOLO BIANCHI - PZ 120' , '1' , '-1' , '1' , '10' , '8.1967213114754' , '22' , '0' , '10.00' ) 23/12/2025 11:41:50 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100668' , '1750' , 'CARTUCCIA TRASPARENTE DIAM. 3,2 - 454' , '4' , '-4' , '1' , '12' , '9.8360655737705' , '22' , '0' , '48.00' ) 23/12/2025 11:41:50 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100668' , '17617' , 'IMMAGINI ISONZO X 100' , '12' , '-12' , '1' , '3.3300' , '2.7295081967213' , '22' , '0' , '39.96' ) 23/12/2025 11:41:50 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100668' , '24309' , 'NON PERFETTI, MA FELICI - M. DAVIDE' , '1' , '-1' , '4' , '18.0000' , '18' , '0' , '5' , '17.10' ) 23/12/2025 11:41:50 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100668' , '18122' , 'ROCCA STOPPINO M. 100 - 469/100' , '5' , '-5' , '1' , '1' , '0.81967213114754' , '22' , '0' , '5.00' ) 23/12/2025 11:41:50 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100668' , '15387' , 'VESTINA BATTESIMALE ' , '40' , '-40' , '1' , '2.5000' , '2.0492' , '22' , '0' , '100.00' ) 23/12/2025 11:41:50 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100668' , '791' , 'ASSISI IN BUSTA BATTESIMO - 20X270 - BAAS' , '40' , '-40' , '1' , '1.3' , '1.0655737704918' , '22' , '0' , '52.00' ) 23/12/2025 11:41:50 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100668' , '19102' , 'CARBONCINI MM 40' , '1' , '-1' , '1' , '10' , '8.1967213114754' , '22' , '0' , '10.00' ) 23/12/2025 11:43:41 am >> SELECT document_num FROM ps_document WHERE document_num = '4389' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-12-23') 23/12/2025 11:43:41 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '4389' , '2025-12-23' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '127.00' , '104.10' , NOW() , NOW() ) 23/12/2025 11:43:41 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '100669' 23/12/2025 11:43:41 am >> DELETE FROM ps_document_detail WHERE id_document = '100669' 23/12/2025 11:43:41 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100669' , '5903' , 'LITURGICO ART. 60LT ROSSO SUPER' , '30' , '-30' , '1' , '3' , '2.4590163934426' , '22' , '0' , '90.00' ) 23/12/2025 11:43:41 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100669' , '7202' , 'ARTICOLI RELIGIOSI' , '10' , '-10' , '1' , '1.9' , '1.5573770491803' , '22' , '0' , '19.00' ) 23/12/2025 11:43:41 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100669' , '22354' , 'CROCE SACRAMENTI VARI - 646' , '10' , '-10' , '1' , '1.80' , '1.4754098360656' , '22' , '0' , '18.00' ) 23/12/2025 11:43:57 am >> SELECT document_num FROM ps_document WHERE document_num = '4390' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-12-23') 23/12/2025 11:43: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' , '4390' , '2025-12-23' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '108.00' , '108.00' , NOW() , NOW() ) 23/12/2025 11:43: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 = '100670' 23/12/2025 11:43:57 am >> DELETE FROM ps_document_detail WHERE id_document = '100670' 23/12/2025 11:43: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 ( '100670' , '24214' , 'SULLA TUA PAROLA GEN/FEB 2026 - 532' , '24' , '-24' , '4' , '4.5' , '4.5' , '0' , '0' , '108.00' ) 23/12/2025 11:52:01 am >> SELECT document_num FROM ps_document WHERE document_num = '38/L' AND id_document != '100512' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2025-12-16') 23/12/2025 11:52:01 am >> UPDATE ps_document SET id_document_type = '23', document_num = '38/L', document_date = '2025-12-16', document_letter = 'L', id_customer = '204', id_supplier = '', id_address = '4671483', address1 = 'VIA ROBERTO IL GUISCARDO, 3 84121 SALERNO', address2 = 'HOSPICE CASA DI LARA', note = 'hospice casa di lara', 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 = '74.00', price_tax_excluded = '62.50', date_upd = NOW() WHERE id_document = '100512' 23/12/2025 11:52:01 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 = '100512' 23/12/2025 11:52:01 am >> DELETE FROM ps_document_detail WHERE id_document = '100512' 23/12/2025 11:52:01 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 ( '100512' , '11757' , 'VINO LIQUOROSO DOLCE - 16%' , '4' , '-4' , '1' , '7.9000' , '6.4754098360656' , '22' , '0' , '31.60' ) 23/12/2025 11:52:01 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 ( '100512' , '1914' , 'CERA DELLA LITURGIA' , '6' , '-6' , '1' , '4.9000' , '4.016393442623' , '22' , '0' , '29.40' ) 23/12/2025 11:52:01 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 ( '100512' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '2' , '-2' , '3' , '3.5000' , '3.3653846153846' , '4' , '0' , '7.00' ) 23/12/2025 11:52:01 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 ( '100512' , '7311' , 'OSTIA SOTTILE 74MM' , '3' , '-3' , '3' , '2.0000' , '1.9230769230769' , '4' , '0' , '6.00' ) 23/12/2025 11:52:27 am >> SELECT document_num FROM ps_document WHERE document_num = '37/L' AND id_document != '100436' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2025-12-12') 23/12/2025 11:52:27 am >> UPDATE ps_document SET id_document_type = '23', document_num = '37/L', document_date = '2025-12-12', document_letter = 'L', id_customer = '204', id_supplier = '', id_address = '4671483', address1 = 'VIA ROBERTO IL GUISCARDO, 3 84121 SALERNO', address2 = 'CAPPELLANIA OSP. BATTIPAGLIA', note = 'ospedale battipaglia', 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 = '71.70', price_tax_excluded = '64.41', date_upd = NOW() WHERE id_document = '100436' 23/12/2025 11:52:27 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 = '100436' 23/12/2025 11:52:27 am >> DELETE FROM ps_document_detail WHERE id_document = '100436' 23/12/2025 11:52:28 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 ( '100436' , '4223' , 'FOGLIETTI LA DOMENICA SAN PAOLO' , '25' , '-25' , '4' , '0.7000' , '0.7' , '0' , '0' , '17.50' ) 23/12/2025 11:52:28 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 ( '100436' , '16689' , 'OSTIA PAN DI CENA mm80' , '4' , '-4' , '3' , '2.0000' , '1.9230769230769' , '4' , '0' , '8.00' ) 23/12/2025 11:52:28 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 ( '100436' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '2' , '-2' , '3' , '3.5000' , '3.3653846153846' , '4' , '0' , '7.00' ) 23/12/2025 11:52:28 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 ( '100436' , '24021' , 'CALENDARIO LITURGICO 2026 - 8164' , '2' , '-2' , '4' , '1.0000' , '1' , '0' , '0' , '2.00' ) 23/12/2025 11:52:28 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 ( '100436' , '17617' , 'IMMAGINI ISONZO X 100' , '2' , '-2' , '1' , '3.6000' , '2.9508196721311' , '22' , '0' , '7.20' ) 23/12/2025 11:52:28 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 ( '100436' , '20885' , 'BIGLIETTI SANTINI X 100 PZ' , '2' , '-2' , '1' , '15.0000' , '12.295081967213' , '22' , '0' , '30.00' ) 23/12/2025 11:53:00 am >> SELECT document_num FROM ps_document WHERE document_num = '35/L' AND id_document != '100433' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2025-12-12') 23/12/2025 11:53:00 am >> UPDATE ps_document SET id_document_type = '23', document_num = '35/L', document_date = '2025-12-12', document_letter = 'L', id_customer = '204', id_supplier = '', id_address = '4671483', address1 = 'VIA ROBERTO IL GUISCARDO, 3 84121 SALERNO', address2 = 'CAMPOLONGO HOSPITAL', note = 'CAMPOLONGO HOSPITAL', 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 = '223.00', price_tax_excluded = '182.79', date_upd = NOW() WHERE id_document = '100433' 23/12/2025 11:53: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 = '100433' 23/12/2025 11:53:00 am >> DELETE FROM ps_document_detail WHERE id_document = '100433' 23/12/2025 11:53: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 ( '100433' , '5976' , 'LUCERNA VETRO - 1493' , '2' , '-2' , '1' , '21.0000' , '17.213114754098' , '22' , '0' , '42.00' ) 23/12/2025 11:53: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 ( '100433' , '24092' , 'PORTAOSTIE - SC 291-COM' , '1' , '-1' , '1' , '15.0000' , '12.295081967213' , '22' , '0' , '15.00' ) 23/12/2025 11:53: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 ( '100433' , '24090' , 'PORTAOSTIE - SC 291-CAL' , '1' , '-1' , '1' , '15.0000' , '12.295081967213' , '22' , '0' , '15.00' ) 23/12/2025 11:53: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 ( '100433' , '8197' , 'PORTATECA - 059' , '2' , '-2' , '1' , '8.5000' , '6.9672131147541' , '22' , '0' , '17.00' ) 23/12/2025 11:53: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 ( '100433' , '2436' , 'COLORANTE PER CERA LIQUIDA - 1002' , '2' , '-2' , '1' , '2.0000' , '1.6393442622951' , '22' , '0' , '4.00' ) 23/12/2025 11:53: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 ( '100433' , '16731' , 'COPRILEGGIO CROCE ORO - AVCL01' , '2' , '-2' , '1' , '65.0000' , '53.27868852459' , '22' , '0' , '130.00' ) 23/12/2025 11:53:24 am >> SELECT document_num FROM ps_document WHERE document_num = '36/L' AND id_document != '100434' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2025-12-12') 23/12/2025 11:53:24 am >> UPDATE ps_document SET id_document_type = '23', document_num = '36/L', document_date = '2025-12-12', document_letter = 'L', id_customer = '204', id_supplier = '', id_address = '4671483', address1 = 'VIA ROBERTO IL GUISCARDO, 3 84121 SALERNO', address2 = 'CAPPELLANIA UNIVERSITA\'', note = 'UNIVERSITA\'', 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 = '159.50', price_tax_excluded = '134.50', date_upd = NOW() WHERE id_document = '100434' 23/12/2025 11:53:24 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '100434' 23/12/2025 11:53:24 am >> DELETE FROM ps_document_detail WHERE id_document = '100434' 23/12/2025 11:53:24 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100434' , '24021' , 'CALENDARIO LITURGICO 2026 - 8164' , '1' , '-1' , '4' , '1.0000' , '1' , '0' , '0' , '1.00' ) 23/12/2025 11:53:24 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100434' , '4223' , 'FOGLIETTI LA DOMENICA SAN PAOLO' , '1' , '-1' , '4' , '0.7000' , '0.7' , '0' , '0' , '0.70' ) 23/12/2025 11:53:24 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100434' , '16689' , 'OSTIA PAN DI CENA mm80' , '2' , '-2' , '3' , '2.0000' , '1.9230769230769' , '4' , '0' , '4.00' ) 23/12/2025 11:53:24 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100434' , '16691' , 'PARTICOLE PER CELIACI 25pz' , '1' , '-1' , '3' , '4.5000' , '4.3269230769231' , '4' , '0' , '4.50' ) 23/12/2025 11:53:24 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100434' , '22809' , 'O LUCE BEATISSIMA' , '5' , '-5' , '4' , '2.5000' , '2.5' , '0' , '0' , '12.50' ) 23/12/2025 11:53:24 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100434' , '18046' , 'TECA PLACCA SMALTATA - 504' , '1' , '-1' , '1' , '33.5000' , '27.459016393443' , '22' , '0' , '33.50' ) 23/12/2025 11:53:24 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100434' , '13049' , 'LITURGICO ART. 60LT BIANCO SUPER' , '30' , '-30' , '1' , '3.0000' , '2.4590163934426' , '22' , '0' , '90.00' ) 23/12/2025 11:53:24 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100434' , '24073' , 'AGENDA LITURGICO PASTORALE 2026 - 40830' , '1' , '-1' , '1' , '14.0000' , '11.475409836066' , '22' , '5' , '13.30' ) 23/12/2025 11:58:26 am >> DELETE FROM ps_document WHERE id_document = '100243' 23/12/2025 11:58:26 am >> DELETE FROM ps_document_detail WHERE id_document = '100243' 23/12/2025 11:58:55 am >> SELECT document_num FROM ps_document WHERE document_num = '4365' AND id_document != '100643' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-12-22') 23/12/2025 11:58:55 am >> UPDATE ps_document SET id_document_type = '11', document_num = '4365', document_date = '2025-12-22', 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 = '79.00', price_tax_excluded = '64.75', date_upd = NOW() WHERE id_document = '100643' 23/12/2025 11:58:55 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 = '100643' 23/12/2025 11:58:55 am >> DELETE FROM ps_document_detail WHERE id_document = '100643' 23/12/2025 11:58:55 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 ( '100643' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '20' , '16.393442622951' , '22' , '0' , '20.00' ) 23/12/2025 11:58:55 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 ( '100643' , '14114' , 'CINGOLO ORO - CING08ORO' , '1' , '-1' , '1' , '34.0000' , '27.868852459016' , '22' , '0' , '34.00' ) 23/12/2025 11:58:55 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 ( '100643' , '12527' , 'LAMPADA A SFERA VIOLA' , '1' , '-1' , '1' , '25.00' , '20.491803278689' , '22' , '0' , '25.00' ) 23/12/2025 12:00:54 pm >> INSERT INTO ps_product ( ean13 , id_tax_rules_group , `date_add` , `date_upd` ) VALUES ( '' , '1' , NOW() , NOW() ) 23/12/2025 12:00:54 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '24459' , '1' , '' , 'nuovo-prodotto' ) 23/12/2025 12:00:54 pm >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , `date_add` , `date_upd` ) VALUES ( '24459' , '1' , '1' , '2' , NOW() , NOW() ) 23/12/2025 12:00:54 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) VALUES ( '24459' , '0' , '1' , '0' , '0' ) 23/12/2025 12:01:39 pm >> SELECT ean13 FROM ps_product WHERE ean13 = 'RIG1' AND id_product != '24459' AND ean13 != '' 23/12/2025 12:01:39 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = 'RIG1', date_upd = NOW() WHERE id_product = '24459' 23/12/2025 12:01:39 pm >> UPDATE ps_product_lang SET name = 'QUADRO CM 112X54 - RIG1', description = '' WHERE id_product = '24459' 23/12/2025 12:01:39 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '140.1639344262295' WHERE id_product = '24459' 23/12/2025 12:01:39 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '140.1639344262295', id_tax_rules_group = '1', id_category_default = '276', id_argoment_default = '42', id_internal_category = '3', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '24459' 23/12/2025 12:01:39 pm >> DELETE FROM ps_specific_price WHERE id_product = '24459' 23/12/2025 12:01:46 pm >> INSERT INTO ps_product ( id_tax_rules_group , `date_add` , `date_upd` ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '24459' 23/12/2025 12:01:46 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '24460' , '1' , '' , 'nuovo-prodotto' ) 23/12/2025 12:01:46 pm >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd` ) SELECT '24460' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '24459' 23/12/2025 12:01:46 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '24460' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '24459' 23/12/2025 12:02:36 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 ( '31' , '972' , '2025-12-15' , '' , '4085' , '0' , '4679275' , 'VIA SEMERIA 19 70014 CONVERSANO' , '' , '' , '15' , '1' , '0' , '0' , '0' , '' , '3' , '0' , '248.88' , '204.00' , NOW() , NOW() ) 23/12/2025 12:02:36 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 = '100671' 23/12/2025 12:02:36 pm >> DELETE FROM ps_document_detail WHERE id_document = '100671' 23/12/2025 12:02: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 ( '100671' , '13611' , 'QUADRO DECORATO DA APPOGGIO 23X14 - ria' , '8' , '8' , '1' , '10' , '8.1967213114754' , '22' , '0' , '97.6000' ) 23/12/2025 12:02: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 ( '100671' , '13609' , 'APPENDICHIAVI 12X12 - RAQ' , '6' , '6' , '1' , '6.5' , '5.327868852459' , '22' , '0' , '47.5800' ) 23/12/2025 12:02: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 ( '100671' , '24459' , 'QUADRO CM 112X54 - RIG1' , '1' , '1' , '1' , '70' , '57.377049180328' , '22' , '0' , '85.4000' ) 23/12/2025 12:27:58 pm >> SELECT document_num FROM ps_document WHERE document_num = '4391' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-12-23') 23/12/2025 12:27:58 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' , '4391' , '2025-12-23' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '53.00' , '43.44' , NOW() , NOW() ) 23/12/2025 12:27:58 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '100672' 23/12/2025 12:27:58 pm >> DELETE FROM ps_document_detail WHERE id_document = '100672' 23/12/2025 12:27: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 ( '100672' , '21080' , 'ROSARIO ARG. MADREPERLA - 328CAV' , '1' , '-1' , '1' , '38.00' , '31.147540983607' , '22' , '0' , '38.00' ) 23/12/2025 12:27: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 ( '100672' , '15206' , 'ANELLO CROCE/MIRACOLOSA' , '1' , '-1' , '1' , '15.00' , '12.295081967213' , '22' , '0' , '15.00' ) 23/12/2025 03:37:02 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9791280736666' AND id_product != '24460' AND ean13 != '' 23/12/2025 03:37:02 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '9791280736666', date_upd = NOW() WHERE id_product = '24460' 23/12/2025 03:37:02 pm >> UPDATE ps_product_lang SET name = 'CRESIMA: IL SIGILLO DELLO SPIRITO SANTO - A. SORRENTINO', description = '' WHERE id_product = '24460' 23/12/2025 03:37:02 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '9.5' WHERE id_product = '24460' 23/12/2025 03:37:02 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '9.5', id_tax_rules_group = '4', id_category_default = '395', id_argoment_default = '108', id_internal_category = '4', on_sale = '0', on_showcase = '1', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '24460' 23/12/2025 03:37:02 pm >> DELETE FROM ps_specific_price WHERE id_product = '24460' 23/12/2025 03:37:02 pm >> INSERT INTO ps_specific_price ( id_specific_price_rule , id_cart , id_product , id_shop , id_shop_group , id_currency , id_country , id_group , id_customer , id_product_attribute , price , from_quantity , reduction , reduction_tax , reduction_type , `from` , `to`) VALUES ( '0' , '0' , '24460' , '1' , '0' , '0' , '0' , '0' , '0' , '0' , '-1' , '1' , '0.05' , '1' , 'percentage' , '0000-00-00' , '0000-00-00' ) 23/12/2025 03:37:04 pm >> INSERT INTO ps_product ( id_tax_rules_group , `date_add` , `date_upd` ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '24460' 23/12/2025 03:37:04 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '24461' , '1' , '' , 'nuovo-prodotto' ) 23/12/2025 03:37:04 pm >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd` ) SELECT '24461' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '24460' 23/12/2025 03:37:04 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '24461' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '24460' 23/12/2025 03:37:38 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 ( '33' , '1834' , '2025-12-23' , '' , '0' , '159' , '4673403' , 'VIA PANNOSE 45 83025 MONTORO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '0.00' , '0.00' , NOW() , NOW() ) 23/12/2025 03:37:38 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 = '100673' 23/12/2025 03:37:38 pm >> DELETE FROM ps_document_detail WHERE id_document = '100673' 23/12/2025 03:37:38 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 ( '100673' , '24460' , 'CRESIMA: IL SIGILLO DELLO SPIRITO SANTO - A. SORRENTINO' , '1000' , '1000' , '4' , '0' , '0' , '0' , '0' , '0.0000' ) 23/12/2025 03:37:38 pm >> DELETE FROM ps_product_supplier WHERE id_product = '24460' AND id_supplier = '159' 23/12/2025 03:37:38 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '24460' , '159' , '1' ) 23/12/2025 03:38:21 pm >> SELECT document_num FROM ps_document WHERE document_num = '282' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2025-12-23') 23/12/2025 03:38:21 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '21' , '282' , '2025-12-23' , '' , '1879' , '0' , '1879' , 'PARROCCHIA DI 84085 MERCATO S. SEVERINO' , '' , 'COPIE OMAGGIO AUTORE' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '0.00' , '0.00' , NOW() , NOW() ) 23/12/2025 03:38:21 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 = '100674' 23/12/2025 03:38:21 pm >> DELETE FROM ps_document_detail WHERE id_document = '100674' 23/12/2025 03:38:21 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 ( '100674' , '24460' , 'CRESIMA: IL SIGILLO DELLO SPIRITO SANTO - A. SORRENTINO' , '100' , '-100' , '4' , '9.50' , '9.5' , '0' , '100' , '0.00' ) 23/12/2025 04:02:37 pm >> SELECT document_num FROM ps_document WHERE document_num = '4392' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-12-23') 23/12/2025 04:02:37 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '4392' , '2025-12-23' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '41.80' , '41.80' , NOW() , NOW() ) 23/12/2025 04:02:37 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '100675' 23/12/2025 04:02:37 pm >> DELETE FROM ps_document_detail WHERE id_document = '100675' 23/12/2025 04:02:37 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100675' , '24449' , 'PRATICA DELLA PRESENZA DI DIO - FRA LORENZO' , '4' , '-4' , '4' , '11.00' , '11' , '0' , '5' , '41.80' ) 23/12/2025 04:06:17 pm >> SELECT document_num FROM ps_document WHERE document_num = '4393' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-12-23') 23/12/2025 04:06:17 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '4393' , '2025-12-23' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '170.00' , '139.34' , NOW() , NOW() ) 23/12/2025 04:06:17 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '100676' 23/12/2025 04:06:17 pm >> DELETE FROM ps_document_detail WHERE id_document = '100676' 23/12/2025 04:06:17 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100676' , '24459' , 'QUADRO CM 112X54 - RIG1' , '1' , '-1' , '1' , '170' , '139.34426229508' , '22' , '0' , '170.00' ) 23/12/2025 04:29:44 pm >> SELECT document_num FROM ps_document WHERE document_num = '4394' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-12-23') 23/12/2025 04:29:44 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '4394' , '2025-12-23' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '49.40' , '40.49' , NOW() , NOW() ) 23/12/2025 04:29:44 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '100677' 23/12/2025 04:29:44 pm >> DELETE FROM ps_document_detail WHERE id_document = '100677' 23/12/2025 04:29:44 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100677' , '5903' , 'LITURGICO ART. 60LT ROSSO SUPER' , '10' , '-10' , '1' , '3.50' , '2.8688524590164' , '22' , '0' , '35.00' ) 23/12/2025 04:29:44 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100677' , '7202' , 'ARTICOLI RELIGIOSI' , '3' , '-3' , '1' , '3.5' , '2.8688524590164' , '22' , '0' , '10.50' ) 23/12/2025 04:29:44 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100677' , '7202' , 'ARTICOLI RELIGIOSI' , '3' , '-3' , '1' , '1.3' , '1.0655737704918' , '22' , '0' , '3.90' ) 23/12/2025 04:57:14 pm >> SELECT document_num FROM ps_document WHERE document_num = '4395' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-12-23') 23/12/2025 04:57:14 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' , '4395' , '2025-12-23' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '9.50' , '9.50' , NOW() , NOW() ) 23/12/2025 04:57:14 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '100678' 23/12/2025 04:57:14 pm >> DELETE FROM ps_document_detail WHERE id_document = '100678' 23/12/2025 04:57:14 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100678' , '24018' , 'UN ANNO CON MARIA - 8280' , '1' , '-1' , '4' , '10.00' , '10' , '0' , '5' , '9.50' ) 23/12/2025 05:13:52 pm >> SELECT document_num FROM ps_document WHERE document_num = '4396' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-12-23') 23/12/2025 05:13: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' , '4396' , '2025-12-23' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '14.00' , '14.00' , NOW() , NOW() ) 23/12/2025 05:13: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 = '100679' 23/12/2025 05:13:52 pm >> DELETE FROM ps_document_detail WHERE id_document = '100679' 23/12/2025 05:13: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 ( '100679' , '23966' , 'ARMARSI CON CINQUE CIOTTOLI - R. FACCENDA' , '1' , '-1' , '4' , '14.00' , '14' , '0' , '0' , '14.00' ) 23/12/2025 06:19:36 pm >> SELECT document_num FROM ps_document WHERE document_num = '4397' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-12-23') 23/12/2025 06:19:36 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' , '4397' , '2025-12-23' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '4.50' , '4.33' , NOW() , NOW() ) 23/12/2025 06:19:36 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 = '100680' 23/12/2025 06:19:36 pm >> DELETE FROM ps_document_detail WHERE id_document = '100680' 23/12/2025 06:19: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 ( '100680' , '16691' , 'PARTICOLE PER CELIACI 25pz' , '1' , '-1' , '3' , '4.50' , '4.3269230769231' , '4' , '0' , '4.50' ) 23/12/2025 07:27:07 pm >> SELECT document_num FROM ps_document WHERE document_num = '4398' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-12-23') 23/12/2025 07:27:07 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' , '4398' , '2025-12-23' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '102.60' , '102.60' , NOW() , NOW() ) 23/12/2025 07:27:07 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 = '100681' 23/12/2025 07:27:07 pm >> DELETE FROM ps_document_detail WHERE id_document = '100681' 23/12/2025 07:27:07 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 ( '100681' , '24455' , 'ASCOLTARE E UNA FESTA ANNO B - F. ARMELLINI' , '1' , '-1' , '4' , '28.00' , '28' , '0' , '5' , '26.60' ) 23/12/2025 07:27:07 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 ( '100681' , '24456' , 'ASCOLTARE E UNA FESTA ANNO A - F. ARMELLINI' , '1' , '-1' , '4' , '30.00' , '30' , '0' , '5' , '28.50' ) 23/12/2025 07:27:07 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 ( '100681' , '24454' , 'ASCOLTARE E UNA FESTA ANNO C - F. ARMELLINI' , '1' , '-1' , '4' , '30.00' , '30' , '0' , '5' , '28.50' ) 23/12/2025 07:27:07 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 ( '100681' , '16429' , 'ASCOLTARTI E UNA FESTA' , '1' , '-1' , '4' , '20.00' , '20' , '0' , '5' , '19.00' )