24/01/2025 09:06:40 am >> SELECT document_num FROM ps_document WHERE document_num = '11' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2025-01-24') 24/01/2025 09:06: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 ( '21' , '11' , '2025-01-24' , '' , '2891' , '0' , '4671063' , 'P. ZZA DON VINCENZO LEO 84088 SIANO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '1' , '0' , '31.88' , '31.88' , NOW() , NOW() ) 24/01/2025 09:06: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 = '95408' 24/01/2025 09:06:41 am >> DELETE FROM ps_document_detail WHERE id_document = '95408' 24/01/2025 09:06: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 ( '95408' , '2448' , 'COLUI IN CUI CREDO' , '15' , '-15' , '4' , '2.50' , '2.5' , '0' , '15' , '31.88' ) 24/01/2025 09:10:24 am >> SELECT document_num FROM ps_document WHERE document_num = '21/A' AND id_document != '95275' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2025-01-14') 24/01/2025 09:10:24 am >> UPDATE ps_document SET id_document_type = '24', document_num = '21/A', document_date = '2025-01-14', document_letter = 'A', id_customer = '3712', id_supplier = '', id_address = '4671443', address1 = 'VIA DALMAZIA 6 84121 SALERNO', 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 = '38.90', price_tax_excluded = '36.95', date_upd = NOW() WHERE id_document = '95275' 24/01/2025 09:10: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 = '95275' 24/01/2025 09:10:24 am >> DELETE FROM ps_document_detail WHERE id_document = '95275' 24/01/2025 09:10: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 ( '95275' , '4223' , 'FOGLIETTI LA DOMENICA SAN PAOLO' , '30' , '-30' , '4' , '0.7000' , '0.7' , '0' , '0' , '21.00' ) 24/01/2025 09:10: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 ( '95275' , '11384' , 'VINO BIANCO DOLCE - 102' , '1' , '-1' , '1' , '8.90' , '7.2950819672131' , '22' , '0' , '8.90' ) 24/01/2025 09:10: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 ( '95275' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '2' , '-2' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '7.00' ) 24/01/2025 09:10: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 ( '95275' , '16689' , 'OSTIA PAN DI CENA mm80' , '1' , '-1' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '2.00' ) 24/01/2025 09:21:48 am >> SELECT document_num FROM ps_document WHERE document_num = '25/A' AND id_document != '' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2025-01-24') 24/01/2025 09:21:48 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '24' , '25/A' , '2025-01-24' , 'A' , '333' , '0' , '4671072' , 'P.ZZA S. MICHELE 84135 RUFOLI' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '112.00' , '102.08' , NOW() , NOW() ) 24/01/2025 09:21:48 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '95409' 24/01/2025 09:21:48 am >> DELETE FROM ps_document_detail WHERE id_document = '95409' 24/01/2025 09:21:49 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95409' , '1631' , 'CANDELINE NON GOCCIOLANTI ' , '2' , '-2' , '1' , '27.5' , '22.540983606557' , '22' , '0' , '55.00' ) 24/01/2025 09:21:49 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95409' , '20798' , 'LEZIONARIO DOMENICALE E FESTIVO - N.E. - ANNO C' , '1' , '-1' , '4' , '60.00' , '60' , '0' , '5' , '57.00' ) 24/01/2025 09:42:12 am >> SELECT document_num FROM ps_document WHERE document_num = '25/A' AND id_document != '95409' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2025-01-24') 24/01/2025 09:42:12 am >> UPDATE ps_document SET id_document_type = '24', document_num = '25/A', document_date = '2025-01-24', document_letter = 'A', id_customer = '333', id_supplier = '', id_address = '4671072', address1 = 'P.ZZA S. MICHELE 84135 RUFOLI', 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 = '130.00', price_tax_excluded = '116.84', date_upd = NOW() WHERE id_document = '95409' 24/01/2025 09:42: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 = '95409' 24/01/2025 09:42:12 am >> DELETE FROM ps_document_detail WHERE id_document = '95409' 24/01/2025 09:42: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 ( '95409' , '1631' , 'CANDELINE NON GOCCIOLANTI ' , '2' , '-2' , '1' , '27.5000' , '22.540983606557' , '22' , '0' , '55.00' ) 24/01/2025 09:42: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 ( '95409' , '20798' , 'LEZIONARIO DOMENICALE E FESTIVO - N.E. - ANNO C' , '1' , '-1' , '4' , '60.0000' , '60' , '0' , '5' , '57.00' ) 24/01/2025 09:42:13 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95409' , '12849' , 'LIBRO DELLE SS. MESSE' , '1' , '-1' , '1' , '20.00' , '16.393442622951' , '22' , '10' , '18.00' ) 24/01/2025 09:50:41 am >> INSERT INTO ps_customer ( id_gender , firstname , lastname , email , passwd , `date_add` , `date_upd` ) VALUES ( '1' , '' , '' , '' , 'lASJeHM6aRJlx0VP' , NOW() , NOW() ) 24/01/2025 09:50:41 am >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '7121' , '1' ) 24/01/2025 09:50:41 am >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '7121' , '2' ) 24/01/2025 09:50:41 am >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '7121' , '3' ) 24/01/2025 09:53:13 am >> UPDATE ps_address SET deleted='1' , active = '0' WHERE id_customer = '7121' 24/01/2025 09:53:13 am >> INSERT INTO ps_address ( id_customer , id_country , id_state , company , lastname , firstname , address1 , address2 , postcode , city , other , phone , phone_mobile , vat_number , dni , date_add , date_upd ) VALUES ( '7121' , '10' , '162' , 'PARROCCHIA SANTI PIETRO E PAOLO' , 'MILOCO' , 'DON VALTER' , 'VIA SAVOIA 3' , '' , '34079' , 'STARANZANO' , '' , '' , '3200932048' , '' , '81000530311' , NOW() , NOW() ) 24/01/2025 09:53:13 am >> UPDATE ps_customer SET email = '', sdi = '', pec = '', date_upd = NOW() WHERE id_customer = '7121' 24/01/2025 09:55:18 am >> UPDATE ps_address SET deleted='1' , active = '0' WHERE id_customer = '7121' 24/01/2025 09:55:18 am >> INSERT INTO ps_address ( id_customer , id_country , id_state , company , lastname , firstname , address1 , address2 , postcode , city , other , phone , phone_mobile , vat_number , dni , date_add , date_upd ) VALUES ( '7121' , '10' , '162' , 'PARROCCHIA SANTI PIETRO E PAOLO' , 'MILOCO' , 'DON VALTER' , 'VIA SAVOIA 3' , '' , '34079' , 'STARANZANO' , '' , '' , '3200932048' , '' , '81000530311' , NOW() , NOW() ) 24/01/2025 09:55:18 am >> UPDATE ps_customer SET email = 'parrocchiadistaranzano@gmail.com', sdi = '', pec = '', date_upd = NOW() WHERE id_customer = '7121' 24/01/2025 09:55:45 am >> UPDATE ps_address SET deleted='1' , active = '0' WHERE id_customer = '7121' 24/01/2025 09:55:45 am >> INSERT INTO ps_address ( id_customer , id_country , id_state , company , lastname , firstname , address1 , address2 , postcode , city , other , phone , phone_mobile , vat_number , dni , date_add , date_upd ) VALUES ( '7121' , '10' , '162' , 'PARROCCHIA SANTI PIETRO E PAOLO' , 'MILOCO' , 'DON VALTER' , 'VIA SAVOIA 3' , '' , '34079' , 'STARANZANO' , '' , '' , '3200932048' , '' , '81000530311' , NOW() , NOW() ) 24/01/2025 09:55:45 am >> UPDATE ps_customer SET email = 'parrocchiadistaranzano@gmail.com', sdi = '', pec = '', date_upd = NOW() WHERE id_customer = '7121' 24/01/2025 09:56:07 am >> UPDATE ps_address SET deleted='1' , active = '0' WHERE id_customer = '7121' 24/01/2025 09:56:07 am >> INSERT INTO ps_address ( id_customer , id_country , id_state , company , lastname , firstname , address1 , address2 , postcode , city , other , phone , phone_mobile , vat_number , dni , date_add , date_upd ) VALUES ( '7121' , '10' , '162' , 'PARROCCHIA SANTI PIETRO E PAOLO' , 'MILOCO' , 'DON VALTER' , 'VIA SAVOIA 3' , '' , '34079' , 'STARANZANO' , '' , '' , '3200932048' , '' , '81000530311' , NOW() , NOW() ) 24/01/2025 09:56:07 am >> UPDATE ps_customer SET email = 'parrocchiadistaranzano@gmail.com', sdi = '', pec = '', date_upd = NOW() WHERE id_customer = '7121' 24/01/2025 09:56:40 am >> SELECT document_num FROM ps_document WHERE document_num = '1' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2025-01-24') 24/01/2025 09:56: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 ( '21' , '1' , '2025-01-24' , '' , '7121' , '0' , '177359065' , 'VIA SAVOIA 3 34079 STARANZANO' , '' , '' , '6.9' , '4' , '0' , '0' , '0' , '' , '6' , '0' , '70.65' , '70.65' , NOW() , NOW() ) 24/01/2025 09:56: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 = '14783' 24/01/2025 09:56:40 am >> DELETE FROM ps_document_detail WHERE id_document = '14783' 24/01/2025 09:56: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 ( '14783' , '132' , 'MINISTRANTI IERI, OGGI, DOMANI' , '30' , '-30' , '4' , '2.50' , '2.5' , '0' , '15' , '63.75' ) 24/01/2025 10:03:49 am >> SELECT document_num FROM ps_document WHERE document_num = '1' AND id_document != '14783' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2025-01-24') 24/01/2025 10:03:49 am >> UPDATE ps_document SET id_document_type = '21', document_num = '1', document_date = '2025-01-24', document_letter = '', id_customer = '7121', id_supplier = '', id_address = '177359065', address1 = 'VIA SAVOIA 3 34079 STARANZANO', address2 = '', note = '', price_shipping = '6.90', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '3', id_causal = '0', price_tax_included = '70.65', price_tax_excluded = '70.65', date_upd = NOW() WHERE id_document = '14783' 24/01/2025 10:03:49 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '14783' 24/01/2025 10:03:49 am >> DELETE FROM ps_document_detail WHERE id_document = '14783' 24/01/2025 10:03:49 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '14783' , '132' , 'MINISTRANTI IERI, OGGI, DOMANI' , '30' , '-30' , '4' , '2.5000' , '2.5' , '0' , '15' , '63.75' ) 24/01/2025 10:29:31 am >> SELECT document_num FROM ps_document WHERE document_num = '12' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2025-01-24') 24/01/2025 10:29:31 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '21' , '12' , '2025-01-24' , '' , '3834' , '0' , '4673024' , 'VIA CHIOSTRO DELLA CATTEDRALE 14 55100 LUCCA' , '' , 'SCONTO AUTORE' , '0' , '4' , '0' , '0' , '0' , '' , '3' , '0' , '105.00' , '105.00' , NOW() , NOW() ) 24/01/2025 10:29:31 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 = '95410' 24/01/2025 10:29:31 am >> DELETE FROM ps_document_detail WHERE id_document = '95410' 24/01/2025 10:29:31 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95410' , '20951' , 'STORIE DEL NOSTRO TEMPO - F. CERRI' , '10' , '-10' , '4' , '15.00' , '15' , '0' , '30' , '105.00' ) 24/01/2025 10:36:21 am >> SELECT document_num FROM ps_document WHERE document_num = '240' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-01-24') 24/01/2025 10:36:21 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '240' , '2025-01-24' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '7.90' , '6.48' , NOW() , NOW() ) 24/01/2025 10:36:21 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '95411' 24/01/2025 10:36:21 am >> DELETE FROM ps_document_detail WHERE id_document = '95411' 24/01/2025 10:36:21 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95411' , '22199' , 'VINO LIQUOROSO ROSSO ' , '1' , '-1' , '1' , '7.90' , '6.4754098360656' , '22' , '0' , '7.90' ) 24/01/2025 10:40:45 am >> SELECT document_num FROM ps_document WHERE document_num = '241' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-01-24') 24/01/2025 10:40: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' , '241' , '2025-01-24' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '1.50' , '1.23' , NOW() , NOW() ) 24/01/2025 10:40: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 = '95412' 24/01/2025 10:40:45 am >> DELETE FROM ps_document_detail WHERE id_document = '95412' 24/01/2025 10:40: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 ( '95412' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '1.5' , '1.2295081967213' , '22' , '0' , '1.50' ) 24/01/2025 11:57:57 am >> SELECT document_num FROM ps_document WHERE document_num = '242' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-01-24') 24/01/2025 11:57: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' , '242' , '2025-01-24' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '9.41' , '9.41' , NOW() , NOW() ) 24/01/2025 11:57: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 = '95413' 24/01/2025 11:57:57 am >> DELETE FROM ps_document_detail WHERE id_document = '95413' 24/01/2025 11:57: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 ( '95413' , '1090' , 'BIBBIA' , '1' , '-1' , '4' , '9.90' , '9.9' , '0' , '5' , '9.41' ) 24/01/2025 12:17:36 pm >> SELECT document_num FROM ps_document WHERE document_num = '243' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-01-24') 24/01/2025 12:17: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' , '243' , '2025-01-24' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '45.00' , '36.89' , NOW() , NOW() ) 24/01/2025 12:17: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 = '95414' 24/01/2025 12:17:36 pm >> DELETE FROM ps_document_detail WHERE id_document = '95414' 24/01/2025 12:17: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 ( '95414' , '22531' , 'ICONA LEGNO FOGLIA ORO 25X20 - K204.68' , '1' , '-1' , '1' , '45.00' , '36.885245901639' , '22' , '0' , '45.00' ) 24/01/2025 12:37:11 pm >> SELECT document_num FROM ps_document WHERE document_num = '244' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-01-24') 24/01/2025 12:37:11 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' , '244' , '2025-01-24' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '30.00' , '24.59' , NOW() , NOW() ) 24/01/2025 12:37:11 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 = '95415' 24/01/2025 12:37:11 pm >> DELETE FROM ps_document_detail WHERE id_document = '95415' 24/01/2025 12:37:11 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 ( '95415' , '19107' , 'INCENSO GRANI 3A - BUSTA' , '1' , '-1' , '1' , '30.00' , '24.590163934426' , '22' , '0' , '30.00' ) 24/01/2025 12:37:45 pm >> SELECT document_num FROM ps_document WHERE document_num = '245' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-01-24') 24/01/2025 12:37:45 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' , '245' , '2025-01-24' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '30.00' , '24.59' , NOW() , NOW() ) 24/01/2025 12:37:45 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 = '95416' 24/01/2025 12:37:45 pm >> DELETE FROM ps_document_detail WHERE id_document = '95416' 24/01/2025 12:37:45 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 ( '95416' , '19107' , 'INCENSO GRANI 3A - BUSTA' , '1' , '-1' , '1' , '30.00' , '24.590163934426' , '22' , '0' , '30.00' ) 24/01/2025 02:46:32 pm >> SELECT document_num FROM ps_document WHERE document_num = '3' AND id_document != '' AND id_document_type LIKE '24' AND YEAR(document_date) = YEAR('2025-01-24') 24/01/2025 02:46:32 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '24' , '3' , '2025-01-24' , '' , '3000' , '0' , '4669629' , 'VIA DEI CASTANI, 116 00172 ROMA' , '' , 'SPEDITI DA VELAR' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '875.00' , '875.00' , NOW() , NOW() ) 24/01/2025 02:46:32 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 = '95417' 24/01/2025 02:46:32 pm >> DELETE FROM ps_document_detail WHERE id_document = '95417' 24/01/2025 02:46:32 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 ( '95417' , '23380' , 'DAL TUO CUORE TRAFITTO E GLORIOSO LA NOSTRA GIOIA E LA NOSTRA SPERANZA' , '350' , '-350' , '4' , '2.50' , '2.5' , '0' , '0' , '875.00' ) 24/01/2025 03:18:16 pm >> SELECT document_num FROM ps_document WHERE document_num = '246' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-01-24') 24/01/2025 03:18:16 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' , '246' , '2025-01-24' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '113.19' , '113.19' , NOW() , NOW() ) 24/01/2025 03:18:16 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 = '95418' 24/01/2025 03:18:16 pm >> DELETE FROM ps_document_detail WHERE id_document = '95418' 24/01/2025 03:18:16 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 ( '95418' , '23272' , 'BOTTA E RISPOSTA CON I GIOVANI... - M. BOTTA' , '1' , '-1' , '4' , '15.00' , '15' , '0' , '5' , '14.25' ) 24/01/2025 03:18:16 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 ( '95418' , '4349' , 'GENITORI IN AZIONE! - AAVV' , '1' , '-1' , '4' , '12.00' , '12' , '0' , '5' , '11.40' ) 24/01/2025 03:18:16 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 ( '95418' , '23324' , 'PELLEGRINI DI SPERANZA' , '1' , '-1' , '4' , '3.00' , '3' , '0' , '5' , '2.85' ) 24/01/2025 03:18:16 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 ( '95418' , '1090' , 'BIBBIA' , '9' , '-9' , '4' , '9.90' , '9.9' , '0' , '5' , '84.69' ) 24/01/2025 03:18:30 pm >> SELECT document_num FROM ps_document WHERE document_num = '247' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-01-24') 24/01/2025 03:18:30 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '247' , '2025-01-24' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '103.51' , '103.51' , NOW() , NOW() ) 24/01/2025 03:18:30 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '95419' 24/01/2025 03:18:30 pm >> DELETE FROM ps_document_detail WHERE id_document = '95419' 24/01/2025 03:18:30 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95419' , '1090' , 'BIBBIA' , '11' , '-11' , '4' , '9.90' , '9.9' , '0' , '5' , '103.51' ) 24/01/2025 05:01:31 pm >> SELECT document_num FROM ps_document WHERE document_num = '248' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-01-24') 24/01/2025 05:01:32 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' , '248' , '2025-01-24' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '13.00' , '13.00' , NOW() , NOW() ) 24/01/2025 05:01:32 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 = '95420' 24/01/2025 05:01:32 pm >> DELETE FROM ps_document_detail WHERE id_document = '95420' 24/01/2025 05:01:32 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 ( '95420' , '15024' , 'CATECHISMO DELLA CHIESA CATTOLICA N.E.' , '1' , '-1' , '4' , '13.00' , '13' , '0' , '0' , '13.00' ) 24/01/2025 05:26:03 pm >> SELECT document_num FROM ps_document WHERE document_num = '26/A' AND id_document != '' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2025-01-24') 24/01/2025 05:26:03 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '24' , '26/A' , '2025-01-24' , 'A' , '319' , '0' , '4671020' , 'P.ZZA DON GERARDO FIORE 84080 CAPEZZANO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '720.00' , '720.00' , NOW() , NOW() ) 24/01/2025 05:26:03 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 = '95421' 24/01/2025 05:26:03 pm >> DELETE FROM ps_document_detail WHERE id_document = '95421' 24/01/2025 05:26:03 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 ( '95421' , '23131' , 'TEMPO DEL PERDONO - F. CRISTOFARO' , '45' , '-45' , '4' , '16.00' , '16' , '0' , '0' , '720.00' ) 24/01/2025 05:48:32 pm >> SELECT document_num FROM ps_document WHERE document_num = '249' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-01-24') 24/01/2025 05:48:32 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' , '249' , '2025-01-24' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '2.40' , '2.40' , NOW() , NOW() ) 24/01/2025 05:48:32 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 = '95422' 24/01/2025 05:48:32 pm >> DELETE FROM ps_document_detail WHERE id_document = '95422' 24/01/2025 05:48:32 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 ( '95422' , '8488' , 'PRIMA CONFESSIONE E MESSA PRIMA COMUNIONE' , '1' , '-1' , '4' , '2.40' , '2.4' , '0' , '0' , '2.40' ) 24/01/2025 06:01:16 pm >> SELECT document_num FROM ps_document WHERE document_num = '250' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-01-24') 24/01/2025 06:01:16 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' , '250' , '2025-01-24' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '58.00' , '47.54' , NOW() , NOW() ) 24/01/2025 06:01:16 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 = '95423' 24/01/2025 06:01:16 pm >> DELETE FROM ps_document_detail WHERE id_document = '95423' 24/01/2025 06:01:16 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 ( '95423' , '23050' , 'CAMICE MICROFIBRA CERN. DAVANTI - 435PMA' , '1' , '-1' , '1' , '58.00' , '47.540983606557' , '22' , '0' , '58.00' ) 24/01/2025 06:05:06 pm >> SELECT document_num FROM ps_document WHERE document_num = '251' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-01-24') 24/01/2025 06:05:06 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' , '251' , '2025-01-24' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '17.65' , '17.15' , NOW() , NOW() ) 24/01/2025 06:05:06 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 = '95424' 24/01/2025 06:05:06 pm >> DELETE FROM ps_document_detail WHERE id_document = '95424' 24/01/2025 06:05:06 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 ( '95424' , '23104' , 'SULLA TUA PAROLA - GEN/FEB 25' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' ) 24/01/2025 06:05:06 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 ( '95424' , '16691' , 'PARTICOLE PER CELIACI 25pz' , '3' , '-3' , '3' , '4.30' , '4.1346153846154' , '4' , '0' , '12.90' ) 24/01/2025 06:15:26 pm >> SELECT document_num FROM ps_document WHERE document_num = '252' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-01-24') 24/01/2025 06:15:26 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' , '252' , '2025-01-24' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '55.00' , '45.08' , NOW() , NOW() ) 24/01/2025 06:15:26 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 = '95425' 24/01/2025 06:15:26 pm >> DELETE FROM ps_document_detail WHERE id_document = '95425' 24/01/2025 06:15:26 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 ( '95425' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '55' , '45.081967213115' , '22' , '0' , '55.00' ) 24/01/2025 06:18:14 pm >> SELECT document_num FROM ps_document WHERE document_num = '253' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-01-24') 24/01/2025 06:18: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' , '253' , '2025-01-24' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '21.00' , '17.21' , NOW() , NOW() ) 24/01/2025 06:18: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 = '95426' 24/01/2025 06:18:14 pm >> DELETE FROM ps_document_detail WHERE id_document = '95426' 24/01/2025 06:18: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 ( '95426' , '13049' , 'LITURGICO ART. 60LT BIANCO SUPER' , '6' , '-6' , '1' , '3.50' , '2.8688524590164' , '22' , '0' , '21.00' ) 24/01/2025 06:53:22 pm >> SELECT document_num FROM ps_document WHERE document_num = '13' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2025-01-24') 24/01/2025 06:53:22 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '21' , '13' , '2025-01-24' , '' , '302' , '0' , '4672778' , 'VIA F. LLI ROSSELLI 84096 MONTECORVINO ROVELLA' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '1' , '0' , '47.60' , '47.60' , NOW() , NOW() ) 24/01/2025 06:53:22 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '95427' 24/01/2025 06:53:22 pm >> DELETE FROM ps_document_detail WHERE id_document = '95427' 24/01/2025 06:53:22 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95427' , '20952' , 'VANGELO E ATTI DEGLI APOSTOLI - ragazzi' , '20' , '-20' , '4' , '2.80' , '2.8' , '0' , '15' , '47.60' )