22/02/2025 08:32:42 am >> SELECT document_num FROM ps_document WHERE document_num = '13/A' AND id_document != '94912' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2025-01-02') 22/02/2025 08:32:42 am >> UPDATE ps_document SET id_document_type = '24', document_num = '13/A', document_date = '2025-01-02', document_letter = 'A', id_customer = '2739', id_supplier = '', id_address = '4671014', address1 = 'VIA F. WENNER, 37 84080 PELLEZZANO', address2 = '', note = '**** già scaricati', 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 = '232.80', price_tax_excluded = '196.73', date_upd = NOW() WHERE id_document = '94912' 22/02/2025 08:32: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 = '94912' 22/02/2025 08:32:43 am >> DELETE FROM ps_document_detail WHERE id_document = '94912' 22/02/2025 08:32:43 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94912' , '19906' , 'FASCIA PER TALARE' , '2' , '-2' , '1' , '100.0000' , '81.967213114754' , '22' , '0' , '200.00' ) 22/02/2025 08:32:43 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94912' , '23393' , 'SULLA TUA PAROLA - MAR/APR 25' , '3' , '-3' , '4' , '5.0000' , '5' , '0' , '0' , '15.00' ) 22/02/2025 08:32:43 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94912' , '23278' , 'AMEN - MAR 25' , '1' , '-1' , '4' , '3.9000' , '3.9' , '0' , '0' , '3.90' ) 22/02/2025 08:32:43 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94912' , '23279' , 'AMEN - APR 25' , '1' , '-1' , '4' , '3.9000' , '3.9' , '0' , '0' , '3.90' ) 22/02/2025 08:32:43 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94912' , '22854' , 'MESSALE FESTIVO 2025' , '1' , '-1' , '4' , '10.00' , '10' , '0' , '0' , '10.00' ) 22/02/2025 08:39: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 ( '32' , '48' , '2025-02-14' , '' , '0' , '143' , '4670947' , 'VIA DELLE SELVETTE 324 55018 SEGROMIGNO IN MONTE CAPANNORI' , '' , '' , '13' , '1' , '0' , '0' , '0' , '' , '0' , '0' , '1037.13' , '850.11' , NOW() , NOW() ) 22/02/2025 08:39: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 = '95867' 22/02/2025 08:39:42 am >> DELETE FROM ps_document_detail WHERE id_document = '95867' 22/02/2025 08:39: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 ( '95867' , '19906' , 'FASCIA PER TALARE' , '1' , '0' , '1' , '49' , '40.16393442623' , '22' , '3' , '57.9866' ) 22/02/2025 08:39:42 am >> DELETE FROM ps_product_supplier WHERE id_product = '19906' AND id_supplier = '143' 22/02/2025 08:39:42 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19906' , '143' , '1' ) 22/02/2025 08:39: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 ( '95867' , '23468' , 'CASULA MARIANA LANA/RASO - 65/019945-M' , '1' , '0' , '1' , '720' , '590.16393442623' , '22' , '3' , '852.0480' ) 22/02/2025 08:39:42 am >> DELETE FROM ps_product_supplier WHERE id_product = '23468' AND id_supplier = '143' 22/02/2025 08:39:42 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23468' , '143' , '1' ) 22/02/2025 08:39: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 ( '95867' , '19906' , 'FASCIA PER TALARE' , '2' , '0' , '1' , '47' , '38.524590163934' , '22' , '3' , '111.2396' ) 22/02/2025 08:39:42 am >> DELETE FROM ps_product_supplier WHERE id_product = '19906' AND id_supplier = '143' 22/02/2025 08:39:42 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19906' , '143' , '1' ) 22/02/2025 08:41:34 am >> UPDATE ps_document SET id_document_type = '33', document_num = '54', document_date = '2025-02-14', document_letter = '', id_customer = '0', id_supplier = '', id_address = '4670947', address1 = 'VIA DELLE SELVETTE 324 55018 SEGROMIGNO IN MONTE CAPANNORI', 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 = '0.00', price_tax_excluded = '0.00', date_upd = NOW() WHERE id_document = '95796' 22/02/2025 08:41:34 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '95796' 22/02/2025 08:41:34 am >> DELETE FROM ps_document_detail WHERE id_document = '95796' 22/02/2025 08:41:34 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95796' , '19906' , 'FASCIA PER TALARE' , '1' , '1' , '1' , '0.0000' , '0' , '22' , '0' , '0.0000' ) 22/02/2025 08:41:34 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95796' , '23468' , 'CASULA MARIANA LANA/RASO - 65/019945-M' , '1' , '1' , '1' , '0.0000' , '0' , '22' , '0' , '0.00' ) 22/02/2025 08:41:34 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95796' , '19906' , 'FASCIA PER TALARE' , '2' , '2' , '1' , '0' , '0' , '22' , '0' , '0.0000' ) 22/02/2025 08:42:37 am >> SELECT document_num FROM ps_document WHERE document_num = '397' AND id_document != '95623' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-02-05') 22/02/2025 08:42:37 am >> UPDATE ps_document SET id_document_type = '11', document_num = '397', document_date = '2025-02-05', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '70.00', price_tax_excluded = '57.38', date_upd = NOW() WHERE id_document = '95623' 22/02/2025 08:42:37 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 = '95623' 22/02/2025 08:42:37 am >> DELETE FROM ps_document_detail WHERE id_document = '95623' 22/02/2025 08:42:37 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 ( '95623' , '19906' , 'FASCIA PER TALARE' , '1' , '-1' , '1' , '70' , '57.377049180328' , '22' , '0' , '70.00' ) 22/02/2025 08:43:02 am >> SELECT document_num FROM ps_document WHERE document_num = '470' AND id_document != '95717' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-02-11') 22/02/2025 08:43:02 am >> UPDATE ps_document SET id_document_type = '11', document_num = '470', document_date = '2025-02-11', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '90.00', price_tax_excluded = '73.77', date_upd = NOW() WHERE id_document = '95717' 22/02/2025 08:43:02 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 = '95717' 22/02/2025 08:43:02 am >> DELETE FROM ps_document_detail WHERE id_document = '95717' 22/02/2025 08:43:02 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 ( '95717' , '19906' , 'FASCIA PER TALARE' , '1' , '-1' , '1' , '90' , '73.770491803279' , '22' , '0' , '90.00' ) 22/02/2025 08:43:33 am >> SELECT document_num FROM ps_document WHERE document_num = '13/A' AND id_document != '94912' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2025-01-02') 22/02/2025 08:43:33 am >> UPDATE ps_document SET id_document_type = '24', document_num = '13/A', document_date = '2025-01-02', document_letter = 'A', id_customer = '2739', id_supplier = '', id_address = '4671014', address1 = 'VIA F. WENNER, 37 84080 PELLEZZANO', address2 = '', note = '**** già scaricati', 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 = '232.80', price_tax_excluded = '196.73', date_upd = NOW() WHERE id_document = '94912' 22/02/2025 08:43:33 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 = '94912' 22/02/2025 08:43:34 am >> DELETE FROM ps_document_detail WHERE id_document = '94912' 22/02/2025 08:43:34 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94912' , '19906' , 'FASCIA PER TALARE*****' , '2' , '-2' , '1' , '100.0000' , '81.967213114754' , '22' , '0' , '200.00' ) 22/02/2025 08:43:34 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94912' , '23393' , 'SULLA TUA PAROLA - MAR/APR 25' , '3' , '-3' , '4' , '5.0000' , '5' , '0' , '0' , '15.00' ) 22/02/2025 08:43:34 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94912' , '23278' , 'AMEN - MAR 25' , '1' , '-1' , '4' , '3.9000' , '3.9' , '0' , '0' , '3.90' ) 22/02/2025 08:43:34 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94912' , '23279' , 'AMEN - APR 25' , '1' , '-1' , '4' , '3.9000' , '3.9' , '0' , '0' , '3.90' ) 22/02/2025 08:43:34 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94912' , '22854' , 'MESSALE FESTIVO 2025' , '1' , '-1' , '4' , '10.0000' , '10' , '0' , '0' , '10.00' ) 22/02/2025 09:28:48 am >> SELECT document_num FROM ps_document WHERE document_num = '30/A' AND id_document != '95476' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2025-01-29') 22/02/2025 09:28:48 am >> UPDATE ps_document SET id_document_type = '24', document_num = '30/A', document_date = '2025-01-29', document_letter = 'A', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = 'francesco MARIANI', 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 = '150.00', price_tax_excluded = '150.00', date_upd = NOW() WHERE id_document = '95476' 22/02/2025 09:28: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 = '95476' 22/02/2025 09:28:48 am >> DELETE FROM ps_document_detail WHERE id_document = '95476' 22/02/2025 09:28:48 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 ( '95476' , '15210' , 'CERO PASQUALE API 80X120' , '4' , '-4' , '1' , '0.0000' , '0' , '22' , '0' , '0.00' ) 22/02/2025 09:28:48 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 ( '95476' , '' , 'RICONSEGNATI ' , '1' , '-1' , '0' , '0' , '0' , '' , '0' , '0' ) 22/02/2025 09:28:48 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 ( '95476' , '' , 'DISEGNI' , '2' , '-2' , '0' , '30' , '30' , '' , '0' , '60.00' ) 22/02/2025 09:28:48 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 ( '95476' , '' , 'DISEGNI' , '2' , '-2' , '0' , '45' , '45' , '' , '0' , '90.00' ) 22/02/2025 10:06:11 am >> SELECT document_num FROM ps_document WHERE document_num = '584' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-02-22') 22/02/2025 10:06:11 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' , '584' , '2025-02-22' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '52.25' , '52.25' , NOW() , NOW() ) 22/02/2025 10:06: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 = '95868' 22/02/2025 10:06:11 am >> DELETE FROM ps_document_detail WHERE id_document = '95868' 22/02/2025 10:06: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 ( '95868' , '23393' , 'SULLA TUA PAROLA - MAR/APR 25' , '11' , '-11' , '4' , '5.00' , '5' , '0' , '5' , '52.25' ) 22/02/2025 10:33:34 am >> SELECT document_num FROM ps_document WHERE document_num = '585' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-02-22') 22/02/2025 10:33:34 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '585' , '2025-02-22' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '110.00' , '110.00' , NOW() , NOW() ) 22/02/2025 10:33:34 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '95869' 22/02/2025 10:33:34 am >> DELETE FROM ps_document_detail WHERE id_document = '95869' 22/02/2025 10:33:34 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95869' , '17329' , 'MESSALE ROMANO DALTARE N.E' , '1' , '-1' , '4' , '110.00' , '110' , '0' , '0' , '110.00' ) 22/02/2025 10:41:09 am >> SELECT document_num FROM ps_document WHERE document_num = '586' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-02-22') 22/02/2025 10:41:09 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' , '586' , '2025-02-22' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '64.84' , '55.82' , NOW() , NOW() ) 22/02/2025 10:41:09 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 = '95870' 22/02/2025 10:41:09 am >> DELETE FROM ps_document_detail WHERE id_document = '95870' 22/02/2025 10:41:09 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 ( '95870' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '50' , '40.983606557377' , '22' , '0' , '50.00' ) 22/02/2025 10:41:09 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 ( '95870' , '23492' , 'AMEN - GIU 25' , '1' , '-1' , '4' , '3.90' , '3.9' , '0' , '5' , '3.71' ) 22/02/2025 10:41:09 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 ( '95870' , '23491' , 'AMEN - MAG 25' , '1' , '-1' , '4' , '3.90' , '3.9' , '0' , '5' , '3.71' ) 22/02/2025 10:41:09 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 ( '95870' , '23279' , 'AMEN - APR 25' , '1' , '-1' , '4' , '3.90' , '3.9' , '0' , '5' , '3.71' ) 22/02/2025 10:41:09 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 ( '95870' , '23278' , 'AMEN - MAR 25' , '1' , '-1' , '4' , '3.90' , '3.9' , '0' , '5' , '3.71' ) 22/02/2025 10:43:57 am >> SELECT document_num FROM ps_document WHERE document_num = '587' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-02-22') 22/02/2025 10: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' , '587' , '2025-02-22' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '9.80' , '8.03' , NOW() , NOW() ) 22/02/2025 10: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 = '95871' 22/02/2025 10:43:57 am >> DELETE FROM ps_document_detail WHERE id_document = '95871' 22/02/2025 10:43:58 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 ( '95871' , '1914' , 'CERA DELLA LITURGIA' , '2' , '-2' , '1' , '4.90' , '4.016393442623' , '22' , '0' , '9.80' ) 22/02/2025 11:11:38 am >> SELECT document_num FROM ps_document WHERE document_num = '588' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-02-22') 22/02/2025 11:11:38 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '588' , '2025-02-22' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '10.20' , '8.72' , NOW() , NOW() ) 22/02/2025 11:11:38 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '95872' 22/02/2025 11:11:38 am >> DELETE FROM ps_document_detail WHERE id_document = '95872' 22/02/2025 11:11:38 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95872' , '18122' , 'ROCCA STOPPINO M. 100 - 469/100' , '3' , '-3' , '1' , '1.10' , '0.9016393442623' , '22' , '0' , '3.30' ) 22/02/2025 11:11:38 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95872' , '1914' , 'CERA DELLA LITURGIA' , '1' , '-1' , '1' , '4.90' , '4.016393442623' , '22' , '0' , '4.90' ) 22/02/2025 11:11:38 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95872' , '23365' , 'VIA CRUCIS DEL PELLEGRINO ' , '1' , '-1' , '4' , '2.00' , '2' , '0' , '0' , '2.00' ) 22/02/2025 11:12:48 am >> SELECT document_num FROM ps_document WHERE document_num = '36' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2025-02-22') 22/02/2025 11:12: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 ( '21' , '36' , '2025-02-22' , '' , '1178' , '0' , '4671042' , 'P. ZZA LINGUITI, 1 84095 GIFFONI VALLE PIANA' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '65.45' , '65.45' , NOW() , NOW() ) 22/02/2025 11:12: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 = '95873' 22/02/2025 11:12:48 am >> DELETE FROM ps_document_detail WHERE id_document = '95873' 22/02/2025 11:12:48 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 ( '95873' , '22029' , 'PREPARIAMOCI ALLA PRIMA CONFESSIONE - POSTER' , '1' , '-1' , '4' , '2.00' , '2' , '0' , '15' , '1.70' ) 22/02/2025 11:12:48 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 ( '95873' , '22030' , 'PREPARIAMOCI ALLA PRIMA COMUNIONE - POSTER' , '1' , '-1' , '4' , '2.00' , '2' , '0' , '15' , '1.70' ) 22/02/2025 11:12:48 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 ( '95873' , '8515' , 'PRIMI PASSI CON GESÙ ANNO C - GUIDA' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '15' , '4.25' ) 22/02/2025 11:12:48 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 ( '95873' , '22033' , 'PRIMA CONFESSIONE E MESSA DI PRIMA COMUNIONE - GUIDA N.E.' , '1' , '-1' , '4' , '8.00' , '8' , '0' , '15' , '6.80' ) 22/02/2025 11:12:48 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 ( '95873' , '22028' , 'PRIMA CONFESSIONE E MESSA DI PRIMA COMUNIONE - N.E.' , '20' , '-20' , '4' , '3.00' , '3' , '0' , '15' , '51.00' ) 22/02/2025 11:15:49 am >> SELECT document_num FROM ps_document WHERE document_num = '589' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-02-22') 22/02/2025 11:15:49 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '589' , '2025-02-22' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '80.75' , '80.75' , NOW() , NOW() ) 22/02/2025 11:15: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 = '95874' 22/02/2025 11:15:49 am >> DELETE FROM ps_document_detail WHERE id_document = '95874' 22/02/2025 11:15: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 ( '95874' , '23393' , 'SULLA TUA PAROLA - MAR/APR 25' , '17' , '-17' , '4' , '5.00' , '5' , '0' , '5' , '80.75' ) 22/02/2025 11:19:57 am >> SELECT document_num FROM ps_document WHERE document_num = '590' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-02-22') 22/02/2025 11:19: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' , '590' , '2025-02-22' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '10.00' , '10.00' , NOW() , NOW() ) 22/02/2025 11:19: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 = '95875' 22/02/2025 11:19:57 am >> DELETE FROM ps_document_detail WHERE id_document = '95875' 22/02/2025 11:19: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 ( '95875' , '19366' , 'DAL CENACOLO AL GIARDINO .. - E. DELLA CORTE' , '1' , '-1' , '4' , '10.00' , '10' , '0' , '0' , '10.00' ) 22/02/2025 11:28:40 am >> SELECT document_num FROM ps_document WHERE document_num = '591' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-02-22') 22/02/2025 11:28: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' , '591' , '2025-02-22' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '4.40' , '3.61' , NOW() , NOW() ) 22/02/2025 11:28: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 = '95876' 22/02/2025 11:28:40 am >> DELETE FROM ps_document_detail WHERE id_document = '95876' 22/02/2025 11:28: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 ( '95876' , '18122' , 'ROCCA STOPPINO M. 100 - 469/100' , '4' , '-4' , '1' , '1.10' , '0.9016393442623' , '22' , '0' , '4.40' ) 22/02/2025 12:57:53 pm >> SELECT document_num FROM ps_document WHERE document_num = '36' AND id_document != '95873' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2025-02-22') 22/02/2025 12:57:53 pm >> UPDATE ps_document SET id_document_type = '21', document_num = '36', document_date = '2025-02-22', document_letter = '', id_customer = '1178', id_supplier = '', id_address = '4671042', address1 = 'P. ZZA LINGUITI, 1 84095 GIFFONI VALLE PIANA', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '1', id_causal = '0', price_tax_included = '65.45', price_tax_excluded = '65.45', date_upd = NOW() WHERE id_document = '95873' 22/02/2025 12:57:53 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 = '95873' 22/02/2025 12:57:53 pm >> DELETE FROM ps_document_detail WHERE id_document = '95873' 22/02/2025 12:57:53 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 ( '95873' , '22029' , 'PREPARIAMOCI ALLA PRIMA CONFESSIONE - POSTER' , '1' , '-1' , '4' , '2.0000' , '2' , '0' , '15' , '1.70' ) 22/02/2025 12:57:53 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 ( '95873' , '22030' , 'PREPARIAMOCI ALLA PRIMA COMUNIONE - POSTER' , '1' , '-1' , '4' , '2.0000' , '2' , '0' , '15' , '1.70' ) 22/02/2025 12:57:53 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 ( '95873' , '8515' , 'PRIMI PASSI CON GESÙ ANNO C - GUIDA' , '1' , '-1' , '4' , '5.0000' , '5' , '0' , '15' , '4.25' ) 22/02/2025 12:57:53 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 ( '95873' , '22033' , 'PRIMA CONFESSIONE E MESSA DI PRIMA COMUNIONE - GUIDA N.E.' , '1' , '-1' , '4' , '8.0000' , '8' , '0' , '15' , '6.80' ) 22/02/2025 12:57:53 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 ( '95873' , '22028' , 'PRIMA CONFESSIONE E MESSA DI PRIMA COMUNIONE - N.E.' , '20' , '-20' , '4' , '3.0000' , '3' , '0' , '15' , '51.00' )