08/08/2025 09:51:23 am >> SELECT document_num FROM ps_document WHERE document_num = '2695' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-08-08') 08/08/2025 09:51:23 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2695' , '2025-08-08' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '28.25' , '27.35' , NOW() , NOW() ) 08/08/2025 09:51:23 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '98407' 08/08/2025 09:51:23 am >> DELETE FROM ps_document_detail WHERE id_document = '98407' 08/08/2025 09:51:23 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '98407' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '5' , '-5' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '17.50' ) 08/08/2025 09:51:23 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '98407' , '16689' , 'OSTIA PAN DI CENA mm80' , '3' , '-3' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '6.00' ) 08/08/2025 09:51:23 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '98407' , '23921' , 'GESU CRISTO, FIGLIO DI DIO' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' ) 08/08/2025 09:56:52 am >> SELECT document_num FROM ps_document WHERE document_num = '103/A' AND id_document != '98318' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2025-07-31') 08/08/2025 09:56:52 am >> UPDATE ps_document SET id_document_type = '24', document_num = '103/A', document_date = '2025-07-31', document_letter = 'A', id_customer = '3550', id_supplier = '', id_address = '4671016', address1 = 'VIA S. MARIA IN MONTICELLI, 28 00186 ROMA', 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 = '1685.30', price_tax_excluded = '1393.08', date_upd = NOW() WHERE id_document = '98318' 08/08/2025 09:56:52 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '98318' 08/08/2025 09:56:52 am >> DELETE FROM ps_document_detail WHERE id_document = '98318' 08/08/2025 09:56:52 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '98318' , '19756' , 'CAMICIA STOCK' , '1' , '-1' , '1' , '49.0000' , '40.16393442623' , '22' , '0' , '49.00' ) 08/08/2025 09:56:52 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '98318' , '18682' , 'CLERGY ROMANO ML - C17' , '1' , '-1' , '1' , '49.9000' , '40.901639344262' , '22' , '0' , '49.90' ) 08/08/2025 09:56:52 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '98318' , '19395' , 'CLERGY MISTO COTONE ML - C01' , '1' , '-1' , '1' , '37.0000' , '30.327868852459' , '22' , '0' , '37.00' ) 08/08/2025 09:56:52 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '98318' , '19396' , 'CLERGY MISTO COTONE MM - C01' , '3' , '-3' , '1' , '36.5000' , '29.918032786885' , '22' , '0' , '109.50' ) 08/08/2025 09:56:52 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '98318' , '14919' , 'CASULA - POLIESTERE - PCA022' , '1' , '-1' , '1' , '79.0000' , '64.754098360656' , '22' , '0' , '79.00' ) 08/08/2025 09:56:52 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '98318' , '19973' , 'AMPOLLINE - ART. 194/1' , '1' , '-1' , '1' , '220.0000' , '180.32786885246' , '22' , '0' , '220.00' ) 08/08/2025 09:56:52 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '98318' , '23807' , 'CALENDARIO LITURGICO 2026' , '1' , '-1' , '4' , '0.8000' , '0.8' , '0' , '0' , '0.80' ) 08/08/2025 09:56:52 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '98318' , '23689' , 'SULLA TUA PAROLA - LUG/AGO 25' , '4' , '-4' , '4' , '5.0000' , '5' , '0' , '0' , '20.00' ) 08/08/2025 09:56:52 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '98318' , '1914' , 'CERA DELLA LITURGIA' , '12' , '-12' , '1' , '4.7000' , '3.8524590163934' , '22' , '0' , '56.40' ) 08/08/2025 09:56:52 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '98318' , '11384' , 'VINO BIANCO DOLCE - 102' , '12' , '-12' , '1' , '8.5000' , '6.9672131147541' , '22' , '0' , '102.00' ) 08/08/2025 09:56:52 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '98318' , '7202' , 'ARTICOLI RELIGIOSI - dalmatica bianca' , '1' , '-1' , '1' , '100.0000' , '81.967213114754' , '22' , '0' , '100.00' ) 08/08/2025 09:56:52 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '98318' , '17087' , 'POLO COTONE MM' , '1' , '-1' , '1' , '46.0000' , '37.704918032787' , '22' , '0' , '46.00' ) 08/08/2025 09:56:52 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '98318' , '8082' , 'POLO LIMITED ' , '2' , '-2' , '1' , '33.0000' , '27.049180327869' , '22' , '0' , '66.00' ) 08/08/2025 09:56:52 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '98318' , '19594' , 'POLO JERSEY COTONE 100%' , '1' , '-1' , '1' , '41.0000' , '33.606557377049' , '22' , '0' , '41.00' ) 08/08/2025 09:56:52 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '98318' , '18682' , 'CLERGY ROMANO ML - C17' , '2' , '-2' , '1' , '49.9000' , '40.901639344262' , '22' , '0' , '99.80' ) 08/08/2025 09:56:52 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '98318' , '17408' , 'CAMICE MISTO COT. 70/001035' , '3' , '-3' , '1' , '175.0000' , '143.44262295082' , '22' , '0' , '525.00' ) 08/08/2025 09:56:52 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '98318' , '19607' , 'CLERGY F/F ML - C03' , '1' , '-1' , '1' , '39.9000' , '32.704918032787' , '22' , '0' , '39.90' ) 08/08/2025 09:56:52 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '98318' , '15019' , 'PREGHIAMO CON MARIA' , '5' , '-5' , '4' , '0.8000' , '0.8' , '0' , '0' , '4.00' ) 08/08/2025 09:56:52 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '98318' , '' , 'PALLA ' , '2' , '-2' , '0' , '20' , '20' , '' , '0' , '40.00' ) 08/08/2025 09:58:05 am >> SELECT document_num FROM ps_document WHERE document_num = '2696' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-08-08') 08/08/2025 09:58: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' , '2696' , '2025-08-08' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '0.70' , '0.57' , NOW() , NOW() ) 08/08/2025 09:58: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 = '98408' 08/08/2025 09:58:05 am >> DELETE FROM ps_document_detail WHERE id_document = '98408' 08/08/2025 09:58: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 ( '98408' , '7937' , 'PERGAMENE - MATRIMONIO-A' , '1' , '-1' , '1' , '0.7' , '0.57377049180328' , '22' , '0' , '0.70' ) 08/08/2025 10:19:39 am >> SELECT document_num FROM ps_document WHERE document_num = '110/A' AND id_document != '' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2025-08-08') 08/08/2025 10:19:39 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '24' , '110/A' , '2025-08-08' , 'A' , '3550' , '0' , '4671016' , 'VIA S. MARIA IN MONTICELLI, 28 00186 ROMA' , '' , 'MATERIALE NOVIZI' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '712.00' , '700.46' , NOW() , NOW() ) 08/08/2025 10:19: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 = '98409' 08/08/2025 10:19:39 am >> DELETE FROM ps_document_detail WHERE id_document = '98409' 08/08/2025 10:19: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 ( '98409' , '' , 'SOTTOTALARE' , '6' , '-6' , '0' , '39' , '39' , '' , '0' , '234.00' ) 08/08/2025 10:19: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 ( '98409' , '' , 'FASCIA PER TALARE' , '4' , '-4' , '0' , '90' , '90' , '' , '0' , '360.00' ) 08/08/2025 10:19: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 ( '98409' , '' , 'POLO' , '1' , '-1' , '0' , '40' , '40' , '' , '0' , '40.00' ) 08/08/2025 10:19: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 ( '98409' , '' , 'COLLETTO' , '4' , '-4' , '0' , '3.5' , '3.5' , '' , '0' , '14.00' ) 08/08/2025 10:19: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 ( '98409' , '12833' , 'BOTTONE RETROCOLLO - 21630' , '4' , '-4' , '1' , '3.00' , '2.4590163934426' , '22' , '0' , '12.00' ) 08/08/2025 10:19: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 ( '98409' , '' , 'PETTINA' , '4' , '-4' , '1' , '13' , '10.655737704918' , '22' , '0' , '52.00' ) 08/08/2025 10:20:39 am >> SELECT document_num FROM ps_document WHERE document_num = '103/A' AND id_document != '98318' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2025-07-31') 08/08/2025 10:20:39 am >> UPDATE ps_document SET id_document_type = '24', document_num = '103/A', document_date = '2025-07-31', document_letter = 'A', id_customer = '3550', id_supplier = '', id_address = '4671016', address1 = 'VIA S. MARIA IN MONTICELLI, 28 00186 ROMA', 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 = '1720.30', price_tax_excluded = '1421.77', date_upd = NOW() WHERE id_document = '98318' 08/08/2025 10:20: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 = '98318' 08/08/2025 10:20:39 am >> DELETE FROM ps_document_detail WHERE id_document = '98318' 08/08/2025 10:20: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 ( '98318' , '19756' , 'CAMICIA STOCK' , '1' , '-1' , '1' , '49.0000' , '40.16393442623' , '22' , '0' , '49.00' ) 08/08/2025 10:20: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 ( '98318' , '18682' , 'CLERGY ROMANO ML - C17' , '1' , '-1' , '1' , '49.9000' , '40.901639344262' , '22' , '0' , '49.90' ) 08/08/2025 10:20: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 ( '98318' , '19395' , 'CLERGY MISTO COTONE ML - C01' , '1' , '-1' , '1' , '37.0000' , '30.327868852459' , '22' , '0' , '37.00' ) 08/08/2025 10:20: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 ( '98318' , '19396' , 'CLERGY MISTO COTONE MM - C01' , '3' , '-3' , '1' , '36.5000' , '29.918032786885' , '22' , '0' , '109.50' ) 08/08/2025 10:20: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 ( '98318' , '14919' , 'CASULA - POLIESTERE - PCA022' , '1' , '-1' , '1' , '79.0000' , '64.754098360656' , '22' , '0' , '79.00' ) 08/08/2025 10:20: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 ( '98318' , '19973' , 'AMPOLLINE - ART. 194/1' , '1' , '-1' , '1' , '220.0000' , '180.32786885246' , '22' , '0' , '220.00' ) 08/08/2025 10:20: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 ( '98318' , '23807' , 'CALENDARIO LITURGICO 2026' , '1' , '-1' , '4' , '0.8000' , '0.8' , '0' , '0' , '0.80' ) 08/08/2025 10:20: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 ( '98318' , '23689' , 'SULLA TUA PAROLA - LUG/AGO 25' , '4' , '-4' , '4' , '5.0000' , '5' , '0' , '0' , '20.00' ) 08/08/2025 10:20: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 ( '98318' , '1914' , 'CERA DELLA LITURGIA' , '12' , '-12' , '1' , '4.7000' , '3.8524590163934' , '22' , '0' , '56.40' ) 08/08/2025 10:20: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 ( '98318' , '11384' , 'VINO BIANCO DOLCE - 102' , '12' , '-12' , '1' , '8.5000' , '6.9672131147541' , '22' , '0' , '102.00' ) 08/08/2025 10:20: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 ( '98318' , '7202' , 'ARTICOLI RELIGIOSI - dalmatica bianca' , '1' , '-1' , '1' , '100.0000' , '81.967213114754' , '22' , '0' , '100.00' ) 08/08/2025 10:20: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 ( '98318' , '17087' , 'POLO COTONE MM' , '1' , '-1' , '1' , '46.0000' , '37.704918032787' , '22' , '0' , '46.00' ) 08/08/2025 10:20: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 ( '98318' , '8082' , 'POLO LIMITED ' , '2' , '-2' , '1' , '33.0000' , '27.049180327869' , '22' , '0' , '66.00' ) 08/08/2025 10:20: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 ( '98318' , '19594' , 'POLO JERSEY COTONE 100%' , '1' , '-1' , '1' , '41.0000' , '33.606557377049' , '22' , '0' , '41.00' ) 08/08/2025 10:20: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 ( '98318' , '18682' , 'CLERGY ROMANO ML - C17' , '2' , '-2' , '1' , '49.9000' , '40.901639344262' , '22' , '0' , '99.80' ) 08/08/2025 10:20: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 ( '98318' , '17408' , 'CAMICE MISTO COT. 70/001035' , '3' , '-3' , '1' , '175.0000' , '143.44262295082' , '22' , '0' , '525.00' ) 08/08/2025 10:20: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 ( '98318' , '19607' , 'CLERGY F/F ML - C03' , '1' , '-1' , '1' , '39.9000' , '32.704918032787' , '22' , '0' , '39.90' ) 08/08/2025 10:20: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 ( '98318' , '15019' , 'PREGHIAMO CON MARIA' , '5' , '-5' , '4' , '0.8000' , '0.8' , '0' , '0' , '4.00' ) 08/08/2025 10:20: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 ( '98318' , '0' , 'PALLA ' , '2' , '-2' , '0' , '20.0000' , '20' , '0' , '0' , '40.00' ) 08/08/2025 10:20: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 ( '98318' , '' , 'CLERGY COCO NUOVO' , '1' , '-1' , '0' , '0' , '0' , '' , '0' , '0' ) 08/08/2025 10:20: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 ( '98318' , '2177' , 'CLERGY BASIC - MM - B&P' , '1' , '-1' , '1' , '35.00' , '28.688524590164' , '22' , '0' , '35.00' ) 08/08/2025 10:21:21 am >> SELECT document_num FROM ps_document WHERE document_num = '89/A' AND id_document != '97713' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2025-06-14') 08/08/2025 10:21:21 am >> UPDATE ps_document SET id_document_type = '24', document_num = '89/A', document_date = '2025-06-14', document_letter = 'A', id_customer = '2739', id_supplier = '', id_address = '4671014', address1 = 'VIA F. WENNER, 37 84080 PELLEZZANO', 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 = '256.50', price_tax_excluded = '217.22', date_upd = NOW() WHERE id_document = '97713' 08/08/2025 10:21: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 = '97713' 08/08/2025 10:21:21 am >> DELETE FROM ps_document_detail WHERE id_document = '97713' 08/08/2025 10:21: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 ( '97713' , '11757' , 'VINO LIQUOROSO DOLCE - 16%' , '1' , '-1' , '1' , '7.9000' , '6.4754098360656' , '22' , '0' , '7.90' ) 08/08/2025 10:21: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 ( '97713' , '16689' , 'OSTIA PAN DI CENA mm80' , '2' , '-2' , '3' , '2.0000' , '1.9230769230769' , '4' , '0' , '4.00' ) 08/08/2025 10:21: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 ( '97713' , '1077' , 'BERNADETTE' , '1' , '-1' , '4' , '5.0000' , '5' , '0' , '0' , '5.00' ) 08/08/2025 10:21: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 ( '97713' , '7385' , 'SAN PIO DA PIETRELCINA - L. DA FARA' , '1' , '-1' , '4' , '5.0000' , '5' , '0' , '0' , '5.00' ) 08/08/2025 10:21: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 ( '97713' , '23689' , 'SULLA TUA PAROLA - LUG/AGO 25' , '3' , '-3' , '4' , '5.0000' , '5' , '0' , '0' , '15.00' ) 08/08/2025 10:21: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 ( '97713' , '23700' , 'AMEN - LUG 25' , '1' , '-1' , '4' , '3.9000' , '3.9' , '0' , '0' , '3.90' ) 08/08/2025 10:21: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 ( '97713' , '23699' , 'AMEN - AGO 25' , '1' , '-1' , '4' , '3.9000' , '3.9' , '0' , '0' , '3.90' ) 08/08/2025 10:21: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 ( '97713' , '8082' , 'POLO LIMITED ' , '1' , '-1' , '1' , '33.0000' , '27.049180327869' , '22' , '0' , '33.00' ) 08/08/2025 10:21: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 ( '97713' , '20547' , 'MEDAGLIA LOURDES - OV22/L' , '10' , '-10' , '1' , '0.2500' , '0.20491803278689' , '22' , '0' , '2.50' ) 08/08/2025 10:21: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 ( '97713' , '13392' , 'STATUETTA BOTTIGLIA LOURDES' , '6' , '-6' , '1' , '1.8000' , '1.4754098360656' , '22' , '0' , '10.80' ) 08/08/2025 10:21: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 ( '97713' , '2168' , 'CLERGY BASIC - ML - B&P' , '2' , '-2' , '1' , '36.0000' , '29.508196721311' , '22' , '0' , '72.00' ) 08/08/2025 10:21: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 ( '97713' , '20433' , 'PARTICOLA MORREALE 38MM - PTC38S' , '1' , '-1' , '3' , '3.5000' , '3.3653846153846' , '4' , '0' , '3.50' ) 08/08/2025 10:21: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 ( '97713' , '19906' , 'FASCIA PER TALARE' , '1' , '-1' , '1' , '90' , '73.770491803279' , '22' , '0' , '90.00' ) 08/08/2025 10:38:31 am >> SELECT document_num FROM ps_document WHERE document_num = '2697' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-08-08') 08/08/2025 10:38: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 ( '11' , '2697' , '2025-08-08' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '17.98' , '17.98' , NOW() , NOW() ) 08/08/2025 10:38: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 = '98410' 08/08/2025 10:38:31 am >> DELETE FROM ps_document_detail WHERE id_document = '98410' 08/08/2025 10:38: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 ( '98410' , '9455' , 'SAN GIOVANNI MARIA VIANNEY - F.INNOCENTE' , '1' , '-1' , '4' , '3.50' , '3.5' , '0' , '0' , '3.50' ) 08/08/2025 10:38: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 ( '98410' , '9095' , 'ROSARIO DEI SETTE DOLORI DELLA VERGINE - 8140' , '1' , '-1' , '4' , '3.00' , '3' , '0' , '0' , '3.00' ) 08/08/2025 10:38: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 ( '98410' , '13462' , 'SE MI AMI NON PIANGERE' , '1' , '-1' , '4' , '1.50' , '1.5' , '0' , '0' , '1.50' ) 08/08/2025 10:38: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 ( '98410' , '8245' , 'PREGATE IL SANTO ROSARIO OGNI GIORNO - 8234' , '1' , '-1' , '4' , '2.00' , '2' , '0' , '5' , '1.90' ) 08/08/2025 10:38: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 ( '98410' , '4443' , 'GESÙ ENTRÒ PER RIMANERE CON LORO - A. FONTANA' , '1' , '-1' , '4' , '2.50' , '2.5' , '0' , '5' , '2.38' ) 08/08/2025 10:38:32 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 ( '98410' , '6977' , 'NELLA SOFFERENZA LA CAREZZA DI GESÙ - CATACCHIO/DI GIANDOMENICO' , '1' , '-1' , '4' , '6.00' , '6' , '0' , '5' , '5.70' ) 08/08/2025 10:56:58 am >> SELECT document_num FROM ps_document WHERE document_num = '2698' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-08-08') 08/08/2025 10:56:58 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' , '2698' , '2025-08-08' , '' , '0' , '0' , '0' , 'VIA F. WENNER, 37 84080 PELLEZZANO' , '' , '' , '0.00' , '4' , '0' , '0' , '0' , '' , '3' , '0' , '400.00' , '337.25' , NOW() , NOW() ) 08/08/2025 10:56:58 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 = '98411' 08/08/2025 10:56:58 am >> DELETE FROM ps_document_detail WHERE id_document = '98411' 08/08/2025 10:56: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 ( '98411' , '19351' , 'SERVIZIO MESSA MISTO LINO - 7050' , '1' , '-1' , '1' , '52.0000' , '42.623' , '22' , '0' , '52.00' ) 08/08/2025 10:56: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 ( '98411' , '19149' , 'CANDELE STEREATICHE E/10 TRIB' , '1' , '-1' , '1' , '6.0000' , '4.918' , '22' , '0' , '6.00' ) 08/08/2025 10:56: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 ( '98411' , '17864' , 'MESSALE QUOTIDIANO GRANDE - N. E. ' , '1' , '-1' , '4' , '52.0000' , '52' , '0' , '0' , '52.00' ) 08/08/2025 10:56: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 ( '98411' , '19970' , 'CALICE - ART 715' , '1' , '-1' , '1' , '290.0000' , '237.7049' , '22' , '0' , '290.00' ) 08/08/2025 11:52:09 am >> SELECT document_num FROM ps_document WHERE document_num = '2699' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-08-08') 08/08/2025 11:52: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' , '2699' , '2025-08-08' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '14.00' , '11.48' , NOW() , NOW() ) 08/08/2025 11:52: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 = '98412' 08/08/2025 11:52:09 am >> DELETE FROM ps_document_detail WHERE id_document = '98412' 08/08/2025 11:52: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 ( '98412' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '14' , '11.475409836066' , '22' , '0' , '14.00' ) 08/08/2025 11:53:25 am >> SELECT document_num FROM ps_document WHERE document_num = '2700' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-08-08') 08/08/2025 11:53:25 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' , '2700' , '2025-08-08' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '4.00' , '4.00' , NOW() , NOW() ) 08/08/2025 11:53:25 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 = '98413' 08/08/2025 11:53:25 am >> DELETE FROM ps_document_detail WHERE id_document = '98413' 08/08/2025 11:53:25 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 ( '98413' , '19116' , 'ROSARIO ALLA VERGINE DI LOURDES - 8978' , '1' , '-1' , '4' , '4.00' , '4' , '0' , '0' , '4.00' ) 08/08/2025 11:57:54 am >> SELECT document_num FROM ps_document WHERE document_num = '2701' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-08-08') 08/08/2025 11:57: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' , '2701' , '2025-08-08' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '36.75' , '32.69' , NOW() , NOW() ) 08/08/2025 11:57: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 = '98414' 08/08/2025 11:57:54 am >> DELETE FROM ps_document_detail WHERE id_document = '98414' 08/08/2025 11:57: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 ( '98414' , '18223' , 'ROSARIO MISSIONARIO MM8 - R102' , '15' , '-15' , '1' , '1.50' , '1.2295081967213' , '22' , '0' , '22.50' ) 08/08/2025 11:57: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 ( '98414' , '23691' , 'CARLO ACUTIS LINFLUENCER DI DIO - C. GALATOLO' , '1' , '-1' , '4' , '10.00' , '10' , '0' , '5' , '9.50' ) 08/08/2025 11:57: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 ( '98414' , '7395' , 'PADRE PIO - UN PENSIERO PER OGNI GIORNO - 8142' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' ) 08/08/2025 11:58:28 am >> SELECT document_num FROM ps_document WHERE document_num = '2702' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-08-08') 08/08/2025 11:58:28 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' , '2702' , '2025-08-08' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '0.80' , '0.80' , NOW() , NOW() ) 08/08/2025 11:58:28 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 = '98415' 08/08/2025 11:58:28 am >> DELETE FROM ps_document_detail WHERE id_document = '98415' 08/08/2025 11:58: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 ( '98415' , '23807' , 'CALENDARIO LITURGICO 2026' , '1' , '-1' , '4' , '0.80' , '0.8' , '0' , '0' , '0.80' ) 08/08/2025 12:47:42 pm >> SELECT document_num FROM ps_document WHERE document_num = '40/A' AND id_document != '95744' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2025-02-14') 08/08/2025 12:47:43 pm >> UPDATE ps_document SET id_document_type = '24', document_num = '40/A', document_date = '2025-02-14', document_letter = 'A', id_customer = '2757', id_supplier = '', id_address = '4679344', address1 = 'VIA CIRILLO 84085 MERCATO SAN SEVERINO', 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 = '1313.00', price_tax_excluded = '1201.56', date_upd = NOW() WHERE id_document = '95744' 08/08/2025 12:47:43 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 = '95744' 08/08/2025 12:47:43 pm >> DELETE FROM ps_document_detail WHERE id_document = '95744' 08/08/2025 12:47:43 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 ( '95744' , '22231' , 'CASULA - 65/060154' , '1' , '-1' , '1' , '450.0000' , '368.85245901639' , '22' , '0' , '450.00' ) 08/08/2025 12:47:43 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 ( '95744' , '0' , 'piviale' , '1' , '-1' , '0' , '275.0000' , '275' , '0' , '0' , '275.00' ) 08/08/2025 12:47:43 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 ( '95744' , '0' , 'restauro' , '1' , '-1' , '0' , '420.0000' , '420' , '0' , '0' , '420.00' ) 08/08/2025 12:47:43 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 ( '95744' , '16796' , 'LUMINO 5B BIANCO' , '672' , '-672' , '1' , '0.25' , '0.20491803278689' , '22' , '0' , '168.00' ) 08/08/2025 12:57:38 pm >> SELECT document_num FROM ps_document WHERE document_num = '2703' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-08-08') 08/08/2025 12:57: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 ( '11' , '2703' , '2025-08-08' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '84.00' , '68.85' , NOW() , NOW() ) 08/08/2025 12:57: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 = '98416' 08/08/2025 12:57:38 pm >> DELETE FROM ps_document_detail WHERE id_document = '98416' 08/08/2025 12:57: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 ( '98416' , '16796' , 'LUMINO 5B BIANCO' , '336' , '-336' , '1' , '0.25' , '0.20491803278689' , '22' , '0' , '84.00' ) 08/08/2025 12:57:56 pm >> SELECT document_num FROM ps_document WHERE document_num = '2704' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-08-08') 08/08/2025 12:57:56 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2704' , '2025-08-08' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '84.00' , '68.85' , NOW() , NOW() ) 08/08/2025 12:57:56 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '98417' 08/08/2025 12:57:56 pm >> DELETE FROM ps_document_detail WHERE id_document = '98417' 08/08/2025 12:57:56 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '98417' , '16796' , 'LUMINO 5B BIANCO' , '336' , '-336' , '1' , '0.25' , '0.20491803278689' , '22' , '0' , '84.00' ) 08/08/2025 12:59:12 pm >> SELECT document_num FROM ps_document WHERE document_num = '2705' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-08-08') 08/08/2025 12:59:12 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' , '2705' , '2025-08-08' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '480.00' , '393.44' , NOW() , NOW() ) 08/08/2025 12:59:12 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 = '98418' 08/08/2025 12:59:12 pm >> DELETE FROM ps_document_detail WHERE id_document = '98418' 08/08/2025 12:59:12 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 ( '98418' , '22231' , 'CASULA - 65/060154' , '1' , '-1' , '1' , '480.00' , '393.44262295082' , '22' , '0' , '480.00' ) 08/08/2025 01:00:09 pm >> SELECT document_num FROM ps_document WHERE document_num = '40/A' AND id_document != '95744' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2025-02-14') 08/08/2025 01:00:09 pm >> UPDATE ps_document SET id_document_type = '24', document_num = '40/A', document_date = '2025-02-14', document_letter = 'A', id_customer = '2757', id_supplier = '', id_address = '4679344', address1 = 'VIA CIRILLO 84085 MERCATO SAN SEVERINO', 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 = '695.00', price_tax_excluded = '695.00', date_upd = NOW() WHERE id_document = '95744' 08/08/2025 01:00:09 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 = '95744' 08/08/2025 01:00:09 pm >> DELETE FROM ps_document_detail WHERE id_document = '95744' 08/08/2025 01:00:10 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95744' , '0' , 'piviale' , '1' , '-1' , '0' , '275.0000' , '275' , '0' , '0' , '275.00' ) 08/08/2025 01:00:10 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95744' , '0' , 'restauro' , '1' , '-1' , '0' , '420.0000' , '420' , '0' , '0' , '420.00' )