05/07/2024 09:30:57 am >> SELECT document_num FROM ps_document WHERE document_num = '2198' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-07-05') 05/07/2024 09:30: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' , '2198' , '2024-07-05' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '108.90' , '97.48' , NOW() , NOW() ) 05/07/2024 09:30: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 = '92544' 05/07/2024 09:30:57 am >> DELETE FROM ps_document_detail WHERE id_document = '92544' 05/07/2024 09:30: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 ( '92544' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '10' , '-10' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '35.00' ) 05/07/2024 09:30: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 ( '92544' , '16689' , 'OSTIA PAN DI CENA mm80' , '5' , '-5' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '10.00' ) 05/07/2024 09:30: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 ( '92544' , '16691' , 'PARTICOLE PER CELIACI 25pz' , '3' , '-3' , '3' , '4.30' , '4.1346153846154' , '4' , '0' , '12.90' ) 05/07/2024 09:30: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 ( '92544' , '11384' , 'VINO BIANCO DOLCE - 102' , '6' , '-6' , '1' , '8.5' , '6.9672131147541' , '22' , '0' , '51.00' ) 05/07/2024 09:31:48 am >> SELECT document_num FROM ps_document WHERE document_num = '2199' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-07-05') 05/07/2024 09:31: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 ( '11' , '2199' , '2024-07-05' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '90.00' , '73.77' , NOW() , NOW() ) 05/07/2024 09:31: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 = '92545' 05/07/2024 09:31:48 am >> DELETE FROM ps_document_detail WHERE id_document = '92545' 05/07/2024 09:31: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 ( '92545' , '22199' , 'VINO LIQUOROSO ROSSO ' , '12' , '-12' , '1' , '7.5' , '6.1475409836066' , '22' , '0' , '90.00' ) 05/07/2024 09:46:24 am >> SELECT document_num FROM ps_document WHERE document_num = '2200' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-07-05') 05/07/2024 09:46:24 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2200' , '2024-07-05' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '19.60' , '16.07' , NOW() , NOW() ) 05/07/2024 09:46: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 = '92546' 05/07/2024 09:46:24 am >> DELETE FROM ps_document_detail WHERE id_document = '92546' 05/07/2024 09:46: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 ( '92546' , '1914' , 'CERA DELLA LITURGIA' , '4' , '-4' , '1' , '4.90' , '4.016393442623' , '22' , '0' , '19.60' ) 05/07/2024 10:09:20 am >> DELETE FROM ps_document WHERE id_document = '92481' 05/07/2024 10:09:20 am >> DELETE FROM ps_document_detail WHERE id_document = '92481' 05/07/2024 10:35:01 am >> SELECT document_num FROM ps_document WHERE document_num = '2201' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-07-05') 05/07/2024 10:35:01 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' , '2201' , '2024-07-05' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '65.00' , '53.28' , NOW() , NOW() ) 05/07/2024 10:35:01 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '92547' 05/07/2024 10:35:01 am >> DELETE FROM ps_document_detail WHERE id_document = '92547' 05/07/2024 10:35:01 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92547' , '22732' , 'TUNICA CON SCAPOLARE - S12' , '1' , '-1' , '1' , '65.00' , '53.27868852459' , '22' , '0' , '65.00' ) 05/07/2024 10:50:50 am >> SELECT document_num FROM ps_document WHERE document_num = '2202' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-07-05') 05/07/2024 10:50:50 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2202' , '2024-07-05' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '70.00' , '57.38' , NOW() , NOW() ) 05/07/2024 10:50:50 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '92548' 05/07/2024 10:50:50 am >> DELETE FROM ps_document_detail WHERE id_document = '92548' 05/07/2024 10:50:50 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92548' , '14088' , 'CAMICE IN MICROFIBRA - 429/PMA' , '1' , '-1' , '1' , '59.00' , '48.360655737705' , '22' , '0' , '59.00' ) 05/07/2024 10:50:50 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92548' , '18140' , 'TAU SNODATO PADRE NOSTRO MEDIO' , '1' , '-1' , '1' , '11.00' , '9.016393442623' , '22' , '0' , '11.00' ) 05/07/2024 10:56:40 am >> SELECT document_num FROM ps_document WHERE document_num = '2203' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-07-05') 05/07/2024 10: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 ( '11' , '2203' , '2024-07-05' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '2.10' , '2.10' , NOW() , NOW() ) 05/07/2024 10: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 = '92549' 05/07/2024 10:56:40 am >> DELETE FROM ps_document_detail WHERE id_document = '92549' 05/07/2024 10: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 ( '92549' , '4223' , 'FOGLIETTI LA DOMENICA SAN PAOLO' , '3' , '-3' , '4' , '0.70' , '0.7' , '0' , '0' , '2.10' ) 05/07/2024 10:58:41 am >> SELECT document_num FROM ps_document WHERE document_num = '2204' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-07-05') 05/07/2024 10:58:41 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2204' , '2024-07-05' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '5.45' , '5.45' , NOW() , NOW() ) 05/07/2024 10:58: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 = '92550' 05/07/2024 10:58:41 am >> DELETE FROM ps_document_detail WHERE id_document = '92550' 05/07/2024 10:58: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 ( '92550' , '22414' , 'SULLA TUA PAROLA - LUG/AGO 2024' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' ) 05/07/2024 10:58: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 ( '92550' , '4223' , 'FOGLIETTI LA DOMENICA SAN PAOLO' , '1' , '-1' , '4' , '0.70' , '0.7' , '0' , '0' , '0.70' ) 05/07/2024 11:06:41 am >> SELECT document_num FROM ps_document WHERE document_num = '2205' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-07-05') 05/07/2024 11: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 ( '11' , '2205' , '2024-07-05' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '5.00' , '4.10' , NOW() , NOW() ) 05/07/2024 11: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 = '92551' 05/07/2024 11:06:41 am >> DELETE FROM ps_document_detail WHERE id_document = '92551' 05/07/2024 11: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 ( '92551' , '20154' , 'QUADRETTO CULLA ANGELO DI DIO ROSA - 5510SC' , '1' , '-1' , '1' , '5.00' , '4.0983606557377' , '22' , '0' , '5.00' ) 05/07/2024 11:28:29 am >> SELECT document_num FROM ps_document WHERE document_num = '2206' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-07-05') 05/07/2024 11:28:29 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' , '2206' , '2024-07-05' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '19.00' , '19.00' , NOW() , NOW() ) 05/07/2024 11:28:29 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 = '92552' 05/07/2024 11:28:29 am >> DELETE FROM ps_document_detail WHERE id_document = '92552' 05/07/2024 11:28:29 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92552' , '22414' , 'SULLA TUA PAROLA - LUG/AGO 2024' , '4' , '-4' , '4' , '5.00' , '5' , '0' , '5' , '19.00' ) 05/07/2024 11:43:15 am >> SELECT document_num FROM ps_document WHERE document_num = '1535' AND id_document != '91738' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-05-10') 05/07/2024 11:43:15 am >> UPDATE ps_document SET id_document_type = '11', document_num = '1535', document_date = '2024-05-10', 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 = '499.40', price_tax_excluded = '409.34', date_upd = NOW() WHERE id_document = '91738' 05/07/2024 11:43:15 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 = '91738' 05/07/2024 11:43:15 am >> DELETE FROM ps_document_detail WHERE id_document = '91738' 05/07/2024 11:43:15 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91738' , '16865' , 'CROCIFISSO SAGOMATO 28X20 - 102860' , '1' , '-1' , '1' , '79.0000' , '64.754098360656' , '22' , '0' , '79.00' ) 05/07/2024 11:43:15 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91738' , '19431' , 'PALLONCINO MAGNETE 12X15 - PM' , '1' , '-1' , '1' , '12.2000' , '10' , '22' , '0' , '12.20' ) 05/07/2024 11:43:15 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91738' , '16310' , 'PORTACHIAVI COLOMBA - KP027' , '15' , '-15' , '1' , '1.2000' , '0.98360655737705' , '22' , '0' , '18.00' ) 05/07/2024 11:43:15 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91738' , '19594' , 'POLO JERSEY COTONE 100%' , '3' , '-3' , '1' , '38.0000' , '31.147540983607' , '22' , '0' , '114.00' ) 05/07/2024 11:43:15 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91738' , '22318' , 'BOSSOLO OTTONE 8X14 - 162' , '1' , '-1' , '1' , '69.0000' , '56.55737704918' , '22' , '0' , '69.00' ) 05/07/2024 11:43:15 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91738' , '22354' , 'CROCE SACRAMENTI VARI - 646' , '36' , '-36' , '1' , '1.8000' , '1.4754098360656' , '22' , '0' , '64.80' ) 05/07/2024 11:43:16 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91738' , '20072' , 'BRACCIALE - BC1759N' , '36' , '-36' , '1' , '2.0000' , '1.6393442622951' , '22' , '0' , '72.00' ) 05/07/2024 11:43:16 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91738' , '18222' , 'ROSARIO COLORATO - R316' , '15' , '-15' , '1' , '0.7000' , '0.57377049180328' , '22' , '0' , '10.50' ) 05/07/2024 11:43:16 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91738' , '15871' , 'FINTA CANDELA 4X100 - 143' , '1' , '-1' , '1' , '30.0000' , '24.590163934426' , '22' , '0' , '30.00' ) 05/07/2024 11:43:16 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91738' , '14247' , 'ROSARIO ULIVO OVALE CON SETA E CROCE SAN DAMIANO' , '12' , '-12' , '1' , '1.5000' , '1.2295081967213' , '22' , '0' , '18.00' ) 05/07/2024 11:43:16 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91738' , '1375' , 'BRUCIAINCENSI LEGNO - BRUL' , '1' , '-1' , '1' , '10.00' , '8.1967213114754' , '22' , '0' , '10.00' ) 05/07/2024 11:43:16 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91738' , '18617' , 'MEDAGLIA MIRACOLOSA - OV22/M' , '6' , '-6' , '1' , '0.2500' , '0.20491803278689' , '22' , '0' , '1.50' ) 05/07/2024 11:43:16 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91738' , '18620' , 'MEDAGLIA MIRACOLOSA BLU PICCOLA - 022M/SM' , '1' , '-1' , '1' , '0.4000' , '0.32786885245902' , '22' , '0' , '0.40' ) 05/07/2024 11:52:48 am >> SELECT document_num FROM ps_document WHERE document_num = '2207' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-07-05') 05/07/2024 11:52: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 ( '11' , '2207' , '2024-07-05' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '6.75' , '6.75' , NOW() , NOW() ) 05/07/2024 11:52: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 = '92553' 05/07/2024 11:52:48 am >> DELETE FROM ps_document_detail WHERE id_document = '92553' 05/07/2024 11:52: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 ( '92553' , '22414' , 'SULLA TUA PAROLA - LUG/AGO 2024' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' ) 05/07/2024 11:52: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 ( '92553' , '8245' , 'PREGATE IL SANTO ROSARIO OGNI GIORNO - 8234' , '1' , '-1' , '4' , '2.00' , '2' , '0' , '0' , '2.00' ) 05/07/2024 12:11:44 pm >> SELECT document_num FROM ps_document WHERE document_num = '18' AND id_document != '92346' AND id_document_type LIKE '24' AND YEAR(document_date) = YEAR('2024-06-19') 05/07/2024 12:11:44 pm >> UPDATE ps_document SET id_document_type = '24', document_num = '18', document_date = '2024-06-19', document_letter = '', id_customer = '0', id_supplier = '', id_address = '2602', address1 = 'P. ZZA SAN PAOLO, 14 12051 ALBA', address2 = '', note = 'RESA - N. C. RICEVUTA', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '9', price_tax_included = '774.30', price_tax_excluded = '773.78', date_upd = NOW() WHERE id_document = '92346' 05/07/2024 12:11:44 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '92346' 05/07/2024 12:11:44 pm >> DELETE FROM ps_document_detail WHERE id_document = '92346' 05/07/2024 12:11:44 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92346' , '22068' , 'PAROLA E PREGHIERA - MAR 2024' , '1' , '-1' , '4' , '2.9000' , '2.9' , '0' , '0' , '2.90' ) 05/07/2024 12:11:44 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92346' , '22069' , 'PAROLA E PREGHIERA - APR 2024' , '1' , '-1' , '4' , '2.9000' , '2.9' , '0' , '0' , '2.90' ) 05/07/2024 12:11:44 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92346' , '21920' , 'AMEN - MAR 24' , '2' , '-2' , '4' , '2.9000' , '2.9' , '0' , '0' , '5.80' ) 05/07/2024 12:11:44 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92346' , '22167' , 'AMEN - MAG. 2024' , '3' , '-3' , '4' , '3.9000' , '3.9' , '0' , '0' , '11.70' ) 05/07/2024 12:11:44 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92346' , '21919' , 'AMEN - APR 24' , '5' , '-5' , '4' , '2.9000' , '2.9' , '0' , '0' , '14.50' ) 05/07/2024 12:11:44 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92346' , '22168' , 'AMEN - GIU. 2024' , '4' , '-4' , '4' , '3.9000' , '3.9' , '0' , '0' , '15.60' ) 05/07/2024 12:11:44 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92346' , '22505' , 'DALLALBA AL TRAMONTO - GIU 24' , '1' , '-1' , '4' , '3.2000' , '3.2' , '0' , '0' , '3.20' ) 05/07/2024 12:11:44 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92346' , '22120' , 'DALLALBA AL TRAMONTO - MAR 2024' , '1' , '-1' , '4' , '3.2000' , '3.2' , '0' , '0' , '3.20' ) 05/07/2024 12:11:44 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92346' , '22085' , 'FATICA DEL CAMMINO - S. DI BENEDETTO' , '3' , '-3' , '4' , '3.0000' , '3' , '0' , '0' , '9.00' ) 05/07/2024 12:11:44 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92346' , '20748' , 'VERSO LA PASQUA' , '1' , '-1' , '4' , '3.5000' , '3.5' , '0' , '0' , '3.50' ) 05/07/2024 12:11:44 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92346' , '22140' , 'QUARESIMA PER I FANNULLONI' , '1' , '-1' , '4' , '6.0000' , '6' , '0' , '0' , '6.00' ) 05/07/2024 12:11:44 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92346' , '22064' , 'QUARESIMA 2024' , '1' , '-1' , '4' , '3.6000' , '3.6' , '0' , '0' , '3.60' ) 05/07/2024 12:11: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 ( '92346' , '22122' , 'CON TUTTO TE STESSO' , '1' , '-1' , '4' , '2.8000' , '2.8' , '0' , '0' , '2.80' ) 05/07/2024 12:11: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 ( '92346' , '22121' , 'CON TE IN PIENEZZA DI VITA ' , '3' , '-3' , '4' , '3.5000' , '3.5' , '0' , '0' , '10.50' ) 05/07/2024 12:11: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 ( '92346' , '22078' , 'CHICCO DI GRANO - QUARESIMA BAMBINI 2024' , '2' , '-2' , '4' , '2.5000' , '2.5' , '0' , '0' , '5.00' ) 05/07/2024 12:11: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 ( '92346' , '22077' , 'QUARESIMA E PASQUA 2024' , '2' , '-2' , '4' , '2.9000' , '2.9' , '0' , '0' , '5.80' ) 05/07/2024 12:11: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 ( '92346' , '22135' , 'PIEDI IN CAMMINO - 2024' , '1' , '-1' , '4' , '9.9000' , '9.9' , '0' , '0' , '9.90' ) 05/07/2024 12:11: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 ( '92346' , '21394' , 'LIBRO DORO DEI PROVERBI DI GESU ' , '1' , '-1' , '4' , '16.0000' , '16' , '0' , '0' , '16.00' ) 05/07/2024 12:11: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 ( '92346' , '4134' , 'FELICI DI CREDERE - ANNO DELLA FEDE' , '2' , '-2' , '4' , '1.5000' , '1.5' , '0' , '0' , '3.00' ) 05/07/2024 12:11: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 ( '92346' , '16790' , 'MAMMA E PAPA' , '12' , '-12' , '4' , '1.8000' , '1.8' , '0' , '0' , '21.60' ) 05/07/2024 12:11: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 ( '92346' , '17504' , 'O MARIA MAMMA DOLCISSIMA P. PIO - L. REGOLO' , '1' , '-1' , '4' , '7.9000' , '7.9' , '0' , '0' , '7.90' ) 05/07/2024 12:11: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 ( '92346' , '17458' , 'MADONNA REGINA DELLA PACE' , '1' , '-1' , '4' , '7.9000' , '7.9' , '0' , '0' , '7.90' ) 05/07/2024 12:11: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 ( '92346' , '17064' , 'ASSUNTA' , '1' , '-1' , '4' , '7.9000' , '7.9' , '0' , '0' , '7.90' ) 05/07/2024 12:11: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 ( '92346' , '16885' , 'MADONNA DEL ROSARIO' , '1' , '-1' , '4' , '7.9000' , '7.9' , '0' , '0' , '7.90' ) 05/07/2024 12:11: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 ( '92346' , '16896' , 'CUORE IMMACOLATO' , '1' , '-1' , '4' , '7.9000' , '7.9' , '0' , '0' , '7.90' ) 05/07/2024 12:11: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 ( '92346' , '16084' , 'MARIA CHE SCIOGLIE I NODI' , '2' , '-2' , '4' , '7.9000' , '7.9' , '0' , '0' , '15.80' ) 05/07/2024 12:11: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 ( '92346' , '17062' , 'MADRE DI DIO E DELLA CHIESA' , '1' , '-1' , '4' , '7.9000' , '7.9' , '0' , '0' , '7.90' ) 05/07/2024 12:11:46 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92346' , '16907' , 'MARIA ADDOLORATA' , '1' , '-1' , '4' , '7.9000' , '7.9' , '0' , '0' , '7.90' ) 05/07/2024 12:11:46 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92346' , '21748' , 'DI PASQUA IN PASQUA - ANNO B - F. ROSINI' , '1' , '-1' , '4' , '16.0000' , '16' , '0' , '0' , '16.00' ) 05/07/2024 12:11:46 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92346' , '22324' , 'ESODO A CARATTERI GRANDI' , '1' , '-1' , '4' , '9.0000' , '9' , '0' , '0' , '9.00' ) 05/07/2024 12:11:46 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92346' , '21025' , 'UN ANNO CON MARIA - A. CANOPI' , '1' , '-1' , '4' , '10.0000' , '10' , '0' , '0' , '10.00' ) 05/07/2024 12:11:46 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92346' , '19175' , 'OLTRE PIO V - A. GRILLO' , '1' , '-1' , '4' , '15.0000' , '15' , '0' , '0' , '15.00' ) 05/07/2024 12:11:46 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92346' , '20103' , 'GESU IL COMPIMENTO DELLE SCRITTURE - A. GRASSO' , '1' , '-1' , '4' , '13.0000' , '13' , '0' , '0' , '13.00' ) 05/07/2024 12:11:46 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92346' , '17128' , 'FAI VIVERE E SANTIFICHI LUNIVERSO' , '1' , '-1' , '4' , '13.0000' , '13' , '0' , '0' , '13.00' ) 05/07/2024 12:11:46 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92346' , '15720' , 'EUCARISTIA E LARTE DI EDUCARE - E. BOLIS' , '1' , '-1' , '4' , '13.0000' , '13' , '0' , '0' , '13.00' ) 05/07/2024 12:11:46 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92346' , '17237' , 'EUCARESTIA DOMENICALE - V. MIRACAPILLO' , '1' , '-1' , '4' , '10.0000' , '10' , '0' , '0' , '10.00' ) 05/07/2024 12:11:46 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92346' , '17456' , 'VANGELO SECONDO MARCO - PAPA FRANCESCO' , '1' , '-1' , '4' , '12.0000' , '12' , '0' , '0' , '12.00' ) 05/07/2024 12:11:46 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92346' , '17759' , 'VANGELO SECONDO LUCA - PAPA FRANCESCO' , '2' , '-2' , '4' , '12.0000' , '12' , '0' , '0' , '24.00' ) 05/07/2024 12:11:46 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92346' , '11129' , 'VANGELO SECONDO LUCA' , '17' , '-17' , '4' , '0.9000' , '0.9' , '0' , '0' , '15.30' ) 05/07/2024 12:11:46 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92346' , '17656' , 'ATTI DEGLI APOSTOLI - PAPA FRANCESCO' , '1' , '-1' , '4' , '12.0000' , '12' , '0' , '0' , '12.00' ) 05/07/2024 12:11:46 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92346' , '17652' , 'LETTERA AGLI EBREI E LETTERE CATTOLICHE - PAPA FRANCESCO' , '1' , '-1' , '4' , '12.0000' , '12' , '0' , '0' , '12.00' ) 05/07/2024 12:11:46 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92346' , '8702' , 'QUANDO IL MAESTRO PARLA AL CUORE - G. COURTOIS' , '1' , '-1' , '4' , '14.0000' , '14' , '0' , '0' , '14.00' ) 05/07/2024 12:11:46 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92346' , '22689' , 'UN GIOCO DAMORE - D. DE CAROLIS' , '1' , '-1' , '4' , '13.0000' , '13' , '0' , '0' , '13.00' ) 05/07/2024 12:11:46 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92346' , '18373' , 'COMMENTI AI VANGELI - BENEDETTO XVI' , '1' , '-1' , '4' , '25.0000' , '25' , '0' , '0' , '25.00' ) 05/07/2024 12:11:47 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92346' , '19412' , 'FRANCESCO - COMMENTO AI VANGELI' , '1' , '-1' , '4' , '25.0000' , '25' , '0' , '0' , '25.00' ) 05/07/2024 12:11:47 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92346' , '16895' , 'ANIMA MIA BENEDICI IL SIGNORE' , '1' , '-1' , '4' , '10.0000' , '10' , '0' , '0' , '10.00' ) 05/07/2024 12:11:47 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92346' , '22003' , 'IMPARARE A PREGARE - C.M. MARTINI' , '1' , '-1' , '4' , '12.0000' , '12' , '0' , '0' , '12.00' ) 05/07/2024 12:11:47 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92346' , '21888' , 'FARE DELLA CHIESA - C.M. MARTINI' , '1' , '-1' , '4' , '12.0000' , '12' , '0' , '0' , '12.00' ) 05/07/2024 12:11:47 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92346' , '21816' , 'MESSAGGIO AI GIOVANI - C.M. MARTINI' , '1' , '-1' , '4' , '12.0000' , '12' , '0' , '0' , '12.00' ) 05/07/2024 12:11:47 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92346' , '21815' , 'FRUTTI DELLO SPIRITO - C.M. MARTINI' , '1' , '-1' , '4' , '12.0000' , '12' , '0' , '0' , '12.00' ) 05/07/2024 12:11:47 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92346' , '21887' , 'PAROLE SULLA CHIESA - C.M. MARTINI' , '1' , '-1' , '4' , '12.0000' , '12' , '0' , '0' , '12.00' ) 05/07/2024 12:11:47 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92346' , '21886' , 'PER UNA NUOVA PRIMAVERA - C.M. MARTINI' , '1' , '-1' , '4' , '12.0000' , '12' , '0' , '0' , '12.00' ) 05/07/2024 12:11:47 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92346' , '21885' , 'FARE DEL CRISTIANO - C.M. MARTINI' , '1' , '-1' , '4' , '12.0000' , '12' , '0' , '0' , '12.00' ) 05/07/2024 12:11:47 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92346' , '20770' , 'MEMORY DI PASQUA' , '1' , '-1' , '1' , '2.9000' , '2.3770491803279' , '22' , '0' , '2.90' ) 05/07/2024 12:11:47 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92346' , '21879' , 'ATTI DEGLI APOSTOLI COMMENTATI DA SEI BIBLISTE' , '1' , '-1' , '4' , '60.0000' , '60' , '0' , '0' , '60.00' ) 05/07/2024 12:11:47 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92346' , '21931' , 'TI SONO PERDONATI I PECCATI' , '1' , '-1' , '4' , '18.0000' , '18' , '0' , '0' , '18.00' ) 05/07/2024 12:11:47 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92346' , '21918' , 'PARABOLE, CANTICI E DISCORSI' , '1' , '-1' , '4' , '22.0000' , '22' , '0' , '0' , '22.00' ) 05/07/2024 12:11:47 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92346' , '17733' , 'VANGELO E ATTI' , '1' , '-1' , '4' , '3.0000' , '3' , '0' , '0' , '3.00' ) 05/07/2024 12:11:47 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92346' , '4348' , 'GENITORI E NONNI' , '2' , '-2' , '4' , '2.0000' , '2' , '0' , '0' , '4.00' ) 05/07/2024 12:11:47 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92346' , '6596' , 'MI CONFESSO' , '2' , '-2' , '4' , '1.5000' , '1.5' , '0' , '0' , '3.00' ) 05/07/2024 12:11:47 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92346' , '21634' , 'ORDO VIRGINUM, PROFEZIA E SINODALITA - D. VITALI' , '1' , '-1' , '4' , '12.0000' , '12' , '0' , '0' , '12.00' ) 05/07/2024 12:11:47 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92346' , '21742' , 'MARIA, LA DONNA PIU BELLA - A. COMASTRI' , '1' , '-1' , '4' , '25.0000' , '25' , '0' , '0' , '25.00' ) 05/07/2024 12:11:47 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92346' , '21805' , 'DIO SI E FATTO CARNE - AAVV' , '1' , '-1' , '4' , '28.0000' , '28' , '0' , '0' , '28.00' ) 05/07/2024 12:11:47 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92346' , '4762' , 'GRAZIE PAPĂ€' , '4' , '-4' , '4' , '1.5000' , '1.5' , '0' , '0' , '6.00' ) 05/07/2024 12:11:48 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 ( '92346' , '4129' , 'FELICE ANNIVERSARIO' , '1' , '-1' , '4' , '1.5000' , '1.5' , '0' , '0' , '1.50' ) 05/07/2024 12:11:48 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 ( '92346' , '16156' , 'MAI DA SOLI - PREGHIERE ANGELI' , '2' , '-2' , '4' , '2.0000' , '2' , '0' , '0' , '4.00' ) 05/07/2024 12:11:48 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 ( '92346' , '19489' , 'ATTO DI CONSACRAZIONE A MARIA - PAPA FRANCESCO' , '10' , '-10' , '4' , '1.2000' , '1.2' , '0' , '0' , '12.00' ) 05/07/2024 12:45:15 pm >> SELECT document_num FROM ps_document WHERE document_num = '2208' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-07-05') 05/07/2024 12:45:15 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' , '2208' , '2024-07-05' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '174.00' , '143.19' , NOW() , NOW() ) 05/07/2024 12:45:15 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 = '92554' 05/07/2024 12:45:15 pm >> DELETE FROM ps_document_detail WHERE id_document = '92554' 05/07/2024 12:45:15 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 ( '92554' , '15387' , 'VESTINA BATTESIMALE ' , '20' , '-20' , '1' , '2.5' , '2.0491803278689' , '22' , '0' , '50.00' ) 05/07/2024 12:45:15 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 ( '92554' , '791' , 'ASSISI IN BUSTA BATTESIMO - 20X270 - BAAS' , '20' , '-20' , '1' , '1.50' , '1.2295081967213' , '22' , '0' , '30.00' ) 05/07/2024 12:45:15 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 ( '92554' , '16689' , 'OSTIA PAN DI CENA mm80' , '2' , '-2' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '4.00' ) 05/07/2024 12:45:15 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 ( '92554' , '5903' , 'LITURGICO ART. 60LT ROSSO SUPER' , '30' , '-30' , '1' , '3' , '2.4590163934426' , '22' , '0' , '90.00' ) 05/07/2024 12:56:34 pm >> SELECT document_num FROM ps_document WHERE document_num = '2209' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-07-05') 05/07/2024 12:56:34 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' , '2209' , '2024-07-05' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '10.00' , '10.00' , NOW() , NOW() ) 05/07/2024 12:56:34 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 = '92555' 05/07/2024 12:56:34 pm >> DELETE FROM ps_document_detail WHERE id_document = '92555' 05/07/2024 12:56:34 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 ( '92555' , '8247' , 'PREGATE, PREGATE, PREGATE - 8100' , '1' , '-1' , '4' , '10.00' , '10' , '0' , '0' , '10.00' ) 05/07/2024 03:56:45 pm >> SELECT document_num FROM ps_document WHERE document_num = '2210' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-07-05') 05/07/2024 03:56: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' , '2210' , '2024-07-05' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '40.00' , '32.79' , NOW() , NOW() ) 05/07/2024 03:56: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 = '92556' 05/07/2024 03:56:45 pm >> DELETE FROM ps_document_detail WHERE id_document = '92556' 05/07/2024 03:56: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 ( '92556' , '20558' , 'FINTA CANDELA 2,5X30 - 124' , '2' , '-2' , '1' , '6.00' , '4.9180327868852' , '22' , '0' , '12.00' ) 05/07/2024 03:56: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 ( '92556' , '1750' , 'CARTUCCIA TRASPARENTE DIAM. 3,2 - 454' , '2' , '-2' , '1' , '14.00' , '11.475409836066' , '22' , '0' , '28.00' ) 05/07/2024 04:35:02 pm >> SELECT document_num FROM ps_document WHERE document_num = '2097' AND id_document != '92421' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-06-26') 05/07/2024 04:35:02 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '2097', document_date = '2024-06-26', 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 = '75.00', price_tax_excluded = '61.48', date_upd = NOW() WHERE id_document = '92421' 05/07/2024 04:35:02 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 = '92421' 05/07/2024 04:35:02 pm >> DELETE FROM ps_document_detail WHERE id_document = '92421' 05/07/2024 04:35:02 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 ( '92421' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '75' , '61.475409836066' , '22' , '0' , '75.00' ) 05/07/2024 04:35:54 pm >> SELECT document_num FROM ps_document WHERE document_num = '2038' AND id_document != '92347' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-06-19') 05/07/2024 04:35:54 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '2038', document_date = '2024-06-19', 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 = '155.00', price_tax_excluded = '127.05', date_upd = NOW() WHERE id_document = '92347' 05/07/2024 04:35:54 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '92347' 05/07/2024 04:35:54 pm >> DELETE FROM ps_document_detail WHERE id_document = '92347' 05/07/2024 04:35:54 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92347' , '5903' , 'LITURGICO ART. 60LT ROSSO SUPER' , '2' , '-2' , '1' , '3.50' , '2.8688524590164' , '22' , '0' , '7.00' ) 05/07/2024 04:35:54 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92347' , '17352' , 'STOLA MARIANA MISTO SETA- 1021 AM' , '1' , '-1' , '1' , '148.00' , '121.31147540984' , '22' , '0' , '148.00' ) 05/07/2024 04:39:11 pm >> SELECT document_num FROM ps_document WHERE document_num = '2211' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-07-05') 05/07/2024 04:39: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' , '2211' , '2024-07-05' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '17.10' , '17.10' , NOW() , NOW() ) 05/07/2024 04:39: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 = '92557' 05/07/2024 04:39:11 pm >> DELETE FROM ps_document_detail WHERE id_document = '92557' 05/07/2024 04:39: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 ( '92557' , '20655' , 'ARTE DELLA BUONA BATTAGLIA - F. ROSINI' , '1' , '-1' , '4' , '18.00' , '18' , '0' , '5' , '17.10' ) 05/07/2024 05:13:55 pm >> SELECT document_num FROM ps_document WHERE document_num = '1291' AND id_document != '91441' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-04-26') 05/07/2024 05:13:55 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '1291', document_date = '2024-04-26', 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 = '4.80', price_tax_excluded = '3.93', date_upd = NOW() WHERE id_document = '91441' 05/07/2024 05:13:55 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 = '91441' 05/07/2024 05:13:55 pm >> DELETE FROM ps_document_detail WHERE id_document = '91441' 05/07/2024 05:13:55 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 ( '91441' , '18617' , 'MEDAGLIA MIRACOLOSA - OV22/M' , '1' , '-1' , '1' , '0.2' , '0.16393442622951' , '22' , '0' , '0.20' ) 05/07/2024 05:13:55 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 ( '91441' , '15085' , 'BRACCIALE DECINA COLORATA - BC506' , '2' , '-2' , '1' , '1.2000' , '0.98360655737705' , '22' , '0' , '2.40' ) 05/07/2024 05:13:55 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 ( '91441' , '16132' , 'DECINA IN METALLO - M0123' , '2' , '-2' , '1' , '0.4000' , '0.32786885245902' , '22' , '0' , '0.80' ) 05/07/2024 05:13:55 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 ( '91441' , '17052' , 'CROCETTA S. BENEDETTO METALLO OX CM5X3,3 - PG382' , '2' , '-2' , '1' , '0.70' , '0.57377049180328' , '22' , '0' , '1.40' ) 05/07/2024 05:14:17 pm >> SELECT document_num FROM ps_document WHERE document_num = '1417' AND id_document != '91594' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-05-03') 05/07/2024 05:14:17 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '1417', document_date = '2024-05-03', 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 = '91594' 05/07/2024 05:14:17 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '91594' 05/07/2024 05:14:17 pm >> DELETE FROM ps_document_detail WHERE id_document = '91594' 05/07/2024 05:14:17 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91594' , '7735' , 'PATENA OTTONE - DIAM. 14 - 900' , '2' , '-2' , '1' , '40.0000' , '32.786885245902' , '22' , '0' , '80.00' ) 05/07/2024 05:14:17 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91594' , '22503' , 'ROSARIO PROFUMATO ROSA MIRACOLOSA - 192/RP6' , '1' , '-1' , '1' , '5.0000' , '4.0983606557377' , '22' , '0' , '5.00' ) 05/07/2024 05:14:17 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91594' , '18617' , 'MEDAGLIA MIRACOLOSA - OV22/M' , '20' , '-20' , '1' , '0.25' , '0.20491803278689' , '22' , '0' , '5.00' ) 05/07/2024 06:03:27 pm >> SELECT document_num FROM ps_document WHERE document_num = '2212' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-07-05') 05/07/2024 06:03:27 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' , '2212' , '2024-07-05' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '40.00' , '32.79' , NOW() , NOW() ) 05/07/2024 06:03:27 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 = '92558' 05/07/2024 06:03:27 pm >> DELETE FROM ps_document_detail WHERE id_document = '92558' 05/07/2024 06:03:27 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 ( '92558' , '22508' , 'POLO PIQUET - M06' , '1' , '-1' , '1' , '40.00' , '32.786885245902' , '22' , '0' , '40.00' ) 05/07/2024 06:17:21 pm >> SELECT document_num FROM ps_document WHERE document_num = '2213' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-07-05') 05/07/2024 06:17:21 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2213' , '2024-07-05' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '5.70' , '5.70' , NOW() , NOW() ) 05/07/2024 06:17:21 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '92559' 05/07/2024 06:17:21 pm >> DELETE FROM ps_document_detail WHERE id_document = '92559' 05/07/2024 06:17:21 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92559' , '22388' , 'MESSALINO QUOTIDIANO - AGO/SET/OTT 2024' , '1' , '-1' , '4' , '6.00' , '6' , '0' , '5' , '5.70' ) 05/07/2024 07:15:01 pm >> SELECT document_num FROM ps_document WHERE document_num = '1849' AND id_document != '92122' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-06-03') 05/07/2024 07:15:01 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '1849', document_date = '2024-06-03', 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 = '55.00', price_tax_excluded = '45.08', date_upd = NOW() WHERE id_document = '92122' 05/07/2024 07:15:01 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 = '92122' 05/07/2024 07:15:01 pm >> DELETE FROM ps_document_detail WHERE id_document = '92122' 05/07/2024 07:15:01 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 ( '92122' , '5903' , 'LITURGICO ART. 60LT ROSSO SUPER' , '2' , '-2' , '1' , '2.5' , '2.0491803278689' , '22' , '0' , '5.00' ) 05/07/2024 07:15:01 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 ( '92122' , '13611' , 'QUADRO DECORATO DA APPOGGIO 23X14' , '2' , '-2' , '1' , '25.00' , '20.491803278689' , '22' , '0' , '50.00' )