01/08/2024 10:27:53 am >> SELECT document_num FROM ps_document WHERE document_num = '2401' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-08-01') 01/08/2024 10:27:53 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2401' , '2024-08-01' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '7.42' , '7.42' , NOW() , NOW() ) 01/08/2024 10:27:53 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '92791' 01/08/2024 10:27:53 am >> DELETE FROM ps_document_detail WHERE id_document = '92791' 01/08/2024 10:27:53 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92791' , '22713' , 'AMEN - SET 24' , '1' , '-1' , '4' , '3.90' , '3.9' , '0' , '5' , '3.71' ) 01/08/2024 10:27:53 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92791' , '22712' , 'AMEN - OTT 24' , '1' , '-1' , '4' , '3.90' , '3.9' , '0' , '5' , '3.71' ) 01/08/2024 10:47:22 am >> SELECT document_num FROM ps_document WHERE document_num = '2402' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-08-01') 01/08/2024 10:47:22 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2402' , '2024-08-01' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '6.60' , '5.41' , NOW() , NOW() ) 01/08/2024 10:47:22 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '92792' 01/08/2024 10:47:22 am >> DELETE FROM ps_document_detail WHERE id_document = '92792' 01/08/2024 10:47:22 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92792' , '20526' , 'MEDAGLIA SAN BENEDETTO 36MM - M275/A' , '3' , '-3' , '1' , '1.20' , '0.98360655737705' , '22' , '0' , '3.60' ) 01/08/2024 10:47:22 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92792' , '7202' , 'ARTICOLI RELIGIOSI' , '10' , '-10' , '1' , '0.3' , '0.24590163934426' , '22' , '0' , '3.00' ) 01/08/2024 10:49:15 am >> SELECT document_num FROM ps_document WHERE document_num = '2402' AND id_document != '92792' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-08-01') 01/08/2024 10:49:15 am >> UPDATE ps_document SET id_document_type = '11', document_num = '2402', document_date = '2024-08-01', 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 = '6.60', price_tax_excluded = '5.41', date_upd = NOW() WHERE id_document = '92792' 01/08/2024 10:49: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 = '92792' 01/08/2024 10:49:15 am >> DELETE FROM ps_document_detail WHERE id_document = '92792' 01/08/2024 10:49: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 ( '92792' , '20526' , 'MEDAGLIA SAN BENEDETTO 36MM - M275/A' , '3' , '-3' , '1' , '1.2000' , '0.98360655737705' , '22' , '0' , '3.60' ) 01/08/2024 10:49: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 ( '92792' , '20548' , 'MEDAGLIA SAN BENEDETTO -T18/SBB' , '10' , '-10' , '1' , '0.30' , '0.24590163934426' , '22' , '0' , '3.00' ) 01/08/2024 11:01:18 am >> SELECT document_num FROM ps_document WHERE document_num = '2386' AND id_document != '92770' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-07-30') 01/08/2024 11:01:18 am >> UPDATE ps_document SET id_document_type = '11', document_num = '2386', document_date = '2024-07-30', 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 = '3.00', price_tax_excluded = '3.00', date_upd = NOW() WHERE id_document = '92770' 01/08/2024 11:01:18 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 = '92770' 01/08/2024 11:01:18 am >> DELETE FROM ps_document_detail WHERE id_document = '92770' 01/08/2024 11:01:18 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92770' , '2777' , 'CORONCINA E NOVENA ALLA DIVINA MISERICORDIA - 8189' , '1' , '-1' , '4' , '3.00' , '3' , '0' , '0' , '3.00' ) 01/08/2024 11:09:22 am >> SELECT document_num FROM ps_document WHERE document_num = '1745' AND id_document != '91990' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-05-24') 01/08/2024 11:09:22 am >> UPDATE ps_document SET id_document_type = '11', document_num = '1745', document_date = '2024-05-24', 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 = '2.40', price_tax_excluded = '1.97', date_upd = NOW() WHERE id_document = '91990' 01/08/2024 11:09:22 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '91990' 01/08/2024 11:09:22 am >> DELETE FROM ps_document_detail WHERE id_document = '91990' 01/08/2024 11:09:22 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91990' , '22548' , 'ROSARIO LEGNO - MM8 - R178' , '2' , '-2' , '1' , '1.20' , '0.98360655737705' , '22' , '0' , '2.40' ) 01/08/2024 11:11:48 am >> SELECT document_num FROM ps_document WHERE document_num = '2403' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-08-01') 01/08/2024 11:11: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' , '2403' , '2024-08-01' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '19.60' , '16.07' , NOW() , NOW() ) 01/08/2024 11:11: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 = '92793' 01/08/2024 11:11:48 am >> DELETE FROM ps_document_detail WHERE id_document = '92793' 01/08/2024 11:11: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 ( '92793' , '1914' , 'CERA DELLA LITURGIA' , '4' , '-4' , '1' , '4.90' , '4.016393442623' , '22' , '0' , '19.60' ) 01/08/2024 11:20:14 am >> SELECT document_num FROM ps_document WHERE document_num = '2404' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-08-01') 01/08/2024 11:20:14 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' , '2404' , '2024-08-01' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '8.46' , '8.46' , NOW() , NOW() ) 01/08/2024 11:20:14 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 = '92794' 01/08/2024 11:20:14 am >> DELETE FROM ps_document_detail WHERE id_document = '92794' 01/08/2024 11:20: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 ( '92794' , '22476' , 'AMEN - AGO 24' , '1' , '-1' , '4' , '3.90' , '3.9' , '0' , '5' , '3.71' ) 01/08/2024 11:20: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 ( '92794' , '22693' , 'SULLA TUA PAROLA - SETT/OTT 2024' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' ) 01/08/2024 11:21:08 am >> SELECT document_num FROM ps_document WHERE document_num = '2405' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-08-01') 01/08/2024 11:21:08 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' , '2405' , '2024-08-01' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '1.50' , '1.50' , NOW() , NOW() ) 01/08/2024 11:21:08 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 = '92795' 01/08/2024 11:21:08 am >> DELETE FROM ps_document_detail WHERE id_document = '92795' 01/08/2024 11:21:08 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92795' , '21609' , 'CARLO ACUTIS - OMELIA - A. COMASTRI' , '1' , '-1' , '4' , '1.50' , '1.5' , '0' , '0' , '1.50' ) 01/08/2024 11:41:34 am >> DELETE FROM ps_document WHERE id_document = '92454' 01/08/2024 11:41:34 am >> DELETE FROM ps_document_detail WHERE id_document = '92454' 01/08/2024 11:41:51 am >> SELECT document_num FROM ps_document WHERE document_num = '2406' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-08-01') 01/08/2024 11:41:51 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' , '2406' , '2024-08-01' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '109.20' , '95.82' , NOW() , NOW() ) 01/08/2024 11:41:51 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 = '92796' 01/08/2024 11:41:51 am >> DELETE FROM ps_document_detail WHERE id_document = '92796' 01/08/2024 11:41:51 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92796' , '1914' , 'CERA DELLA LITURGIA' , '12' , '-12' , '1' , '4.7' , '3.8524590163934' , '22' , '0' , '56.40' ) 01/08/2024 11:41:51 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92796' , '4223' , 'FOGLIETTI LA DOMENICA SAN PAOLO' , '50' , '-50' , '4' , '0.70' , '0.7' , '0' , '0' , '35.00' ) 01/08/2024 11:41:51 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92796' , '11384' , 'VINO BIANCO DOLCE - 102' , '2' , '-2' , '1' , '8.90' , '7.2950819672131' , '22' , '0' , '17.80' ) 01/08/2024 11:45:59 am >> SELECT document_num FROM ps_document WHERE document_num = '2404' AND id_document != '92794' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-08-01') 01/08/2024 11:45:59 am >> UPDATE ps_document SET id_document_type = '11', document_num = '2404', document_date = '2024-08-01', 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 = '8.46', price_tax_excluded = '8.46', date_upd = NOW() WHERE id_document = '92794' 01/08/2024 11:45:59 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 = '92794' 01/08/2024 11:46:00 am >> DELETE FROM ps_document_detail WHERE id_document = '92794' 01/08/2024 11:46:00 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92794' , '22476' , 'AMEN - AGO 24' , '1' , '-1' , '4' , '3.9000' , '3.9' , '0' , '5' , '3.71' ) 01/08/2024 11:46:00 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92794' , '22693' , 'SULLA TUA PAROLA - SETT/OTT 2024' , '1' , '-1' , '4' , '5.0000' , '5' , '0' , '5' , '4.75' ) 01/08/2024 11:46:09 am >> SELECT document_num FROM ps_document WHERE document_num = '2403' AND id_document != '92793' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-08-01') 01/08/2024 11:46:09 am >> UPDATE ps_document SET id_document_type = '11', document_num = '2403', document_date = '2024-08-01', 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 = '19.60', price_tax_excluded = '16.07', date_upd = NOW() WHERE id_document = '92793' 01/08/2024 11:46: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 = '92793' 01/08/2024 11:46:09 am >> DELETE FROM ps_document_detail WHERE id_document = '92793' 01/08/2024 11:46: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 ( '92793' , '1914' , 'CERA DELLA LITURGIA' , '4' , '-4' , '1' , '4.9000' , '4.016393442623' , '22' , '0' , '19.60' ) 01/08/2024 11:52:44 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 ( '33' , '24V604445' , '2024-07-31' , '' , '0' , '7' , '2602' , 'P. ZZA SAN PAOLO, 14 12051 ALBA' , '' , '' , '8.43' , '4' , '0' , '0' , '0' , '' , '11' , '0' , '311.11' , '310.44' , NOW() , NOW() ) 01/08/2024 11:52:44 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 = '92797' 01/08/2024 11:52:44 am >> DELETE FROM ps_document_detail WHERE id_document = '92797' 01/08/2024 11:52:44 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92797' , '22743' , 'PIU NOBILE DEGLI AVVENTURIERI FRANCESCO SAVERIO' , '1' , '1' , '4' , '15.0000' , '15' , '0' , '30' , '10.50' ) 01/08/2024 11:52:44 am >> DELETE FROM ps_product_supplier WHERE id_product = '22743' AND id_supplier = '7' 01/08/2024 11:52:44 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22743' , '7' , '1' ) 01/08/2024 11:52:44 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92797' , '22744' , 'LODE GUARISCE OGNI NOSTRO PATIRE - M. TEDOLDI' , '1' , '1' , '4' , '10.0000' , '10' , '0' , '33' , '6.70' ) 01/08/2024 11:52:44 am >> DELETE FROM ps_product_supplier WHERE id_product = '22744' AND id_supplier = '7' 01/08/2024 11:52:44 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22744' , '7' , '1' ) 01/08/2024 11:52:44 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92797' , '22745' , 'VANGELO DEL CORAGGIO - TONINO BELLO' , '1' , '1' , '4' , '9.9000' , '9.9' , '0' , '33' , '6.63' ) 01/08/2024 11:52:44 am >> DELETE FROM ps_product_supplier WHERE id_product = '22745' AND id_supplier = '7' 01/08/2024 11:52:44 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22745' , '7' , '1' ) 01/08/2024 11:52:44 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92797' , '22746' , 'COME SE VEDESSE LINVISIBILE - G.M. DOS SANTOS' , '1' , '1' , '4' , '10.0000' , '10' , '0' , '35' , '6.50' ) 01/08/2024 11:52:44 am >> DELETE FROM ps_product_supplier WHERE id_product = '22746' AND id_supplier = '7' 01/08/2024 11:52:44 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22746' , '7' , '1' ) 01/08/2024 11:52:44 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92797' , '22747' , 'MISTERO UOMO - W. KASPER' , '1' , '1' , '4' , '6.0000' , '6' , '0' , '30' , '4.20' ) 01/08/2024 11:52:44 am >> DELETE FROM ps_product_supplier WHERE id_product = '22747' AND id_supplier = '7' 01/08/2024 11:52:44 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22747' , '7' , '1' ) 01/08/2024 11:52:44 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92797' , '22748' , 'DEL GRANDE MEZZO DELLA PREGHIERA - A. MARIA DE LIGUORI' , '1' , '1' , '4' , '14.0000' , '14' , '0' , '33' , '9.38' ) 01/08/2024 11:52:44 am >> DELETE FROM ps_product_supplier WHERE id_product = '22748' AND id_supplier = '7' 01/08/2024 11:52:44 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22748' , '7' , '1' ) 01/08/2024 11:52:44 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92797' , '22749' , 'PAROLA E I GIORNI 2025' , '2' , '2' , '4' , '9.0000' , '9' , '0' , '33' , '12.06' ) 01/08/2024 11:52:44 am >> DELETE FROM ps_product_supplier WHERE id_product = '22749' AND id_supplier = '7' 01/08/2024 11:52:44 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22749' , '7' , '1' ) 01/08/2024 11:52:44 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92797' , '22750' , 'DISCEPOLO AMATO E LA SUA TESTIMONIANZA - G. DE VIRGILIO' , '1' , '1' , '4' , '15.0000' , '15' , '0' , '33' , '10.05' ) 01/08/2024 11:52:44 am >> DELETE FROM ps_product_supplier WHERE id_product = '22750' AND id_supplier = '7' 01/08/2024 11:52:44 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22750' , '7' , '1' ) 01/08/2024 11:52:44 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92797' , '22751' , 'BIBBIA PER IL CATECHISMO' , '3' , '3' , '4' , '6.9000' , '6.9' , '0' , '30' , '14.49' ) 01/08/2024 11:52:45 am >> DELETE FROM ps_product_supplier WHERE id_product = '22751' AND id_supplier = '7' 01/08/2024 11:52:45 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22751' , '7' , '1' ) 01/08/2024 11:52:45 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92797' , '22768' , 'PAROLA E PREGHIERA - OTT 24' , '4' , '4' , '4' , '2.9000' , '2.9' , '0' , '33' , '7.77' ) 01/08/2024 11:52:45 am >> DELETE FROM ps_product_supplier WHERE id_product = '22768' AND id_supplier = '7' 01/08/2024 11:52:45 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22768' , '7' , '1' ) 01/08/2024 11:52:45 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92797' , '22775' , 'INSIEME NELLA MESSA - OTT 24' , '1' , '1' , '4' , '1.8000' , '1.8' , '0' , '33' , '1.21' ) 01/08/2024 11:52:45 am >> DELETE FROM ps_product_supplier WHERE id_product = '22775' AND id_supplier = '7' 01/08/2024 11:52:45 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22775' , '7' , '1' ) 01/08/2024 11:52:45 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92797' , '22772' , 'IN DIALOGO CON DIO - S. ALFONSO M. DE LIGUORI' , '1' , '1' , '4' , '10.0000' , '10' , '0' , '30' , '7.00' ) 01/08/2024 11:52:45 am >> DELETE FROM ps_product_supplier WHERE id_product = '22772' AND id_supplier = '7' 01/08/2024 11:52:45 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22772' , '7' , '1' ) 01/08/2024 11:52:45 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92797' , '22769' , 'COPPIE IN CAMMINO - MAIO/CALETTI' , '1' , '1' , '4' , '14.0000' , '14' , '0' , '33' , '9.38' ) 01/08/2024 11:52:45 am >> DELETE FROM ps_product_supplier WHERE id_product = '22769' AND id_supplier = '7' 01/08/2024 11:52:45 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22769' , '7' , '1' ) 01/08/2024 11:52:45 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92797' , '22771' , 'SUPERPOTERI DEGLI ANIMALI - DIARIO 2024/25' , '1' , '1' , '4' , '8.9000' , '8.9' , '0' , '30' , '6.23' ) 01/08/2024 11:52:45 am >> DELETE FROM ps_product_supplier WHERE id_product = '22771' AND id_supplier = '7' 01/08/2024 11:52:45 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22771' , '7' , '1' ) 01/08/2024 11:52:45 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92797' , '22773' , 'DONO E IL COMPITO DEL CULTO - A. GRILLO' , '1' , '1' , '4' , '22.0000' , '22' , '0' , '30' , '15.40' ) 01/08/2024 11:52:45 am >> DELETE FROM ps_product_supplier WHERE id_product = '22773' AND id_supplier = '7' 01/08/2024 11:52:45 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22773' , '7' , '1' ) 01/08/2024 11:52:45 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92797' , '22774' , 'IGNIAZIO, BENEDETTO, FRANCESCO E TERESA' , '1' , '1' , '4' , '13.0000' , '13' , '0' , '30' , '9.10' ) 01/08/2024 11:52:45 am >> DELETE FROM ps_product_supplier WHERE id_product = '22774' AND id_supplier = '7' 01/08/2024 11:52:45 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22774' , '7' , '1' ) 01/08/2024 11:52:45 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92797' , '22766' , 'CONNESSI COL CIELO' , '1' , '1' , '4' , '8.0000' , '8' , '0' , '33' , '5.36' ) 01/08/2024 11:52:45 am >> DELETE FROM ps_product_supplier WHERE id_product = '22766' AND id_supplier = '7' 01/08/2024 11:52:45 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22766' , '7' , '1' ) 01/08/2024 11:52:45 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92797' , '22767' , 'CUORE DI MAMMA - A. COMASTRI' , '2' , '2' , '4' , '5.0000' , '5' , '0' , '30' , '7.00' ) 01/08/2024 11:52:45 am >> DELETE FROM ps_product_supplier WHERE id_product = '22767' AND id_supplier = '7' 01/08/2024 11:52:45 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22767' , '7' , '1' ) 01/08/2024 11:52:45 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92797' , '22770' , 'NELLA TUA FEDELTA - VOL. II' , '1' , '1' , '3' , '23.0700' , '22.1827' , '4' , '30' , '16.80' ) 01/08/2024 11:52:45 am >> DELETE FROM ps_product_supplier WHERE id_product = '22770' AND id_supplier = '7' 01/08/2024 11:52:45 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22770' , '7' , '1' ) 01/08/2024 11:52:45 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92797' , '7442' , 'PANE QUOTIDIANO' , '1' , '1' , '4' , '3.9000' , '3.9' , '0' , '30' , '2.73' ) 01/08/2024 11:52:45 am >> DELETE FROM ps_product_supplier WHERE id_product = '7442' AND id_supplier = '7' 01/08/2024 11:52:45 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7442' , '7' , '1' ) 01/08/2024 11:52:45 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92797' , '22784' , 'ROSARIO CON PADRE PIO' , '48' , '48' , '4' , '1.5000' , '1.5' , '0' , '33' , '48.24' ) 01/08/2024 11:52:45 am >> DELETE FROM ps_product_supplier WHERE id_product = '22784' AND id_supplier = '7' 01/08/2024 11:52:45 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22784' , '7' , '1' ) 01/08/2024 11:52:46 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92797' , '22784' , 'ROSARIO CON PADRE PIO' , '4' , '4' , '4' , '1.5000' , '1.5' , '0' , '100' , '0.00' ) 01/08/2024 11:52:46 am >> DELETE FROM ps_product_supplier WHERE id_product = '22784' AND id_supplier = '7' 01/08/2024 11:52:46 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22784' , '7' , '1' ) 01/08/2024 11:52:46 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92797' , '19412' , 'FRANCESCO - COMMENTO AI VANGELI' , '1' , '1' , '4' , '25.0000' , '25' , '0' , '30' , '17.50' ) 01/08/2024 11:52:46 am >> DELETE FROM ps_product_supplier WHERE id_product = '19412' AND id_supplier = '7' 01/08/2024 11:52:46 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19412' , '7' , '1' ) 01/08/2024 11:52:46 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92797' , '22805' , 'RESPIRO DELLA LODE - A. VENA' , '1' , '1' , '4' , '13.5000' , '13.5' , '0' , '30' , '9.45' ) 01/08/2024 11:52:46 am >> DELETE FROM ps_product_supplier WHERE id_product = '22805' AND id_supplier = '7' 01/08/2024 11:52:46 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22805' , '7' , '1' ) 01/08/2024 11:52:46 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92797' , '22803' , 'PANE E VINO - N.E. - GUIDA 3' , '2' , '2' , '4' , '15.0000' , '15' , '0' , '35' , '19.50' ) 01/08/2024 11:52:46 am >> DELETE FROM ps_product_supplier WHERE id_product = '22803' AND id_supplier = '7' 01/08/2024 11:52:46 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22803' , '7' , '1' ) 01/08/2024 11:52:46 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92797' , '22804' , 'PANE E VINO - N.E. - SUSSIDIO' , '12' , '12' , '4' , '5.0000' , '5' , '0' , '35' , '39.00' ) 01/08/2024 11:52:46 am >> DELETE FROM ps_product_supplier WHERE id_product = '22804' AND id_supplier = '7' 01/08/2024 11:52:46 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22804' , '7' , '1' ) 01/08/2024 11:52:46 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92797' , '22804' , 'PANE E VINO - N.E. - SUSSIDIO' , '1' , '1' , '4' , '5.0000' , '5' , '0' , '100' , '0.00' ) 01/08/2024 11:52:46 am >> DELETE FROM ps_product_supplier WHERE id_product = '22804' AND id_supplier = '7' 01/08/2024 11:52:46 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22804' , '7' , '1' ) 01/08/2024 11:52:46 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92797' , '10133' , 'SPESE DI TRASPORTO' , '1' , '1' , '3' , '0.48' , '0.46153846153846' , '4' , '0' , '0.4992' ) 01/08/2024 11:52:46 am >> DELETE FROM ps_product_supplier WHERE id_product = '10133' AND id_supplier = '7' 01/08/2024 11:52:46 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '10133' , '7' , '1' ) 01/08/2024 11:54:00 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '32' , '24V604446' , '2024-07-31' , '' , '0' , '7' , '2602' , 'P. ZZA SAN PAOLO, 14 12051 ALBA' , '' , '' , '54.74' , '4' , '0' , '0' , '0' , '' , '14' , '0' , '1411.69' , '1411.69' , NOW() , NOW() ) 01/08/2024 11:54:00 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '92798' 01/08/2024 11:54:00 am >> DELETE FROM ps_document_detail WHERE id_document = '92798' 01/08/2024 11:54:00 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92798' , '18289' , 'SANTA MESSA DEGLI SPOSI - N.E.' , '30' , '0' , '4' , '1.9000' , '1.9' , '0' , '33+26' , '28.26' ) 01/08/2024 11:54:01 am >> DELETE FROM ps_product_supplier WHERE id_product = '18289' AND id_supplier = '7' 01/08/2024 11:54:01 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18289' , '7' , '1' ) 01/08/2024 11:54: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 ( '92798' , '22698' , 'CALENDARIO LITURGICO 2025' , '150' , '0' , '4' , '0.8000' , '0.8' , '0' , '33+26' , '59.50' ) 01/08/2024 11:54:01 am >> DELETE FROM ps_product_supplier WHERE id_product = '22698' AND id_supplier = '7' 01/08/2024 11:54:01 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22698' , '7' , '1' ) 01/08/2024 11:54: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 ( '92798' , '6962' , 'NELLA CASA DEL DEFUNTO' , '5' , '0' , '4' , '1.5000' , '1.5' , '0' , '33+26' , '3.72' ) 01/08/2024 11:54:01 am >> DELETE FROM ps_product_supplier WHERE id_product = '6962' AND id_supplier = '7' 01/08/2024 11:54:01 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '6962' , '7' , '1' ) 01/08/2024 11:54: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 ( '92798' , '22785' , 'PIENA DI VITA - M. FUSARELLI' , '1' , '0' , '4' , '10.0000' , '10' , '0' , '33+26' , '4.96' ) 01/08/2024 11:54:01 am >> DELETE FROM ps_product_supplier WHERE id_product = '22785' AND id_supplier = '7' 01/08/2024 11:54:01 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22785' , '7' , '1' ) 01/08/2024 11:54: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 ( '92798' , '21713' , 'FEDE SPERANZA E CARITA - R. CANTALAMESSA' , '1' , '0' , '4' , '19.0000' , '19' , '0' , '33+26' , '9.42' ) 01/08/2024 11:54:01 am >> DELETE FROM ps_product_supplier WHERE id_product = '21713' AND id_supplier = '7' 01/08/2024 11:54:01 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21713' , '7' , '1' ) 01/08/2024 11:54: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 ( '92798' , '1090' , 'BIBBIA' , '120' , '0' , '4' , '9.9000' , '9.9' , '0' , '33+26' , '589.01' ) 01/08/2024 11:54:01 am >> DELETE FROM ps_product_supplier WHERE id_product = '1090' AND id_supplier = '7' 01/08/2024 11:54:01 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '1090' , '7' , '1' ) 01/08/2024 11:54: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 ( '92798' , '20655' , 'ARTE DELLA BUONA BATTAGLIA - F. ROSINI' , '2' , '0' , '4' , '18.0000' , '18' , '0' , '33+26' , '17.85' ) 01/08/2024 11:54:01 am >> DELETE FROM ps_product_supplier WHERE id_product = '20655' AND id_supplier = '7' 01/08/2024 11:54:01 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20655' , '7' , '1' ) 01/08/2024 11:54: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 ( '92798' , '17581' , 'MESSALE QUOTIDIANO N.E. ' , '5' , '0' , '4' , '39.0000' , '39' , '0' , '33+26' , '96.68' ) 01/08/2024 11:54:01 am >> DELETE FROM ps_product_supplier WHERE id_product = '17581' AND id_supplier = '7' 01/08/2024 11:54:01 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17581' , '7' , '1' ) 01/08/2024 11:54: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 ( '92798' , '20250' , 'PREGA MANGIA AMA - L. EPICOCO' , '2' , '0' , '4' , '16.0000' , '16' , '0' , '33+26' , '15.87' ) 01/08/2024 11:54:02 am >> DELETE FROM ps_product_supplier WHERE id_product = '20250' AND id_supplier = '7' 01/08/2024 11:54:02 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20250' , '7' , '1' ) 01/08/2024 11:54:02 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92798' , '16884' , 'ARTE DI GUARIRE - F. ROSINI' , '1' , '0' , '4' , '18.0000' , '18' , '0' , '33+26' , '8.92' ) 01/08/2024 11:54:02 am >> DELETE FROM ps_product_supplier WHERE id_product = '16884' AND id_supplier = '7' 01/08/2024 11:54:02 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16884' , '7' , '1' ) 01/08/2024 11:54:02 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92798' , '13432' , 'ARTE DI RICOMINCIARE - F. ROSINI' , '1' , '0' , '4' , '18.0000' , '18' , '0' , '33+26' , '8.92' ) 01/08/2024 11:54:02 am >> DELETE FROM ps_product_supplier WHERE id_product = '13432' AND id_supplier = '7' 01/08/2024 11:54:02 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '13432' , '7' , '1' ) 01/08/2024 11:54:02 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92798' , '21668' , 'ALFABETO DI DIO - G. RAVASI' , '1' , '0' , '4' , '20.0000' , '20' , '0' , '33+26' , '9.92' ) 01/08/2024 11:54:02 am >> DELETE FROM ps_product_supplier WHERE id_product = '21668' AND id_supplier = '7' 01/08/2024 11:54:02 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21668' , '7' , '1' ) 01/08/2024 11:54:02 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92798' , '18298' , 'SAN GIUSEPPE - F. ROSINI' , '1' , '0' , '4' , '14.0000' , '14' , '0' , '33+26' , '6.94' ) 01/08/2024 11:54:02 am >> DELETE FROM ps_product_supplier WHERE id_product = '18298' AND id_supplier = '7' 01/08/2024 11:54:02 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18298' , '7' , '1' ) 01/08/2024 11:54:02 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92798' , '22129' , 'PADRE NOSTRO - L. EPICOCO' , '3' , '0' , '4' , '14.0000' , '14' , '0' , '33+26' , '20.82' ) 01/08/2024 11:54:02 am >> DELETE FROM ps_product_supplier WHERE id_product = '22129' AND id_supplier = '7' 01/08/2024 11:54:02 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22129' , '7' , '1' ) 01/08/2024 11:54:02 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92798' , '12995' , 'SALE, NON MIELE - L. EPICOCO' , '1' , '0' , '4' , '18.0000' , '18' , '0' , '33+26' , '8.92' ) 01/08/2024 11:54:02 am >> DELETE FROM ps_product_supplier WHERE id_product = '12995' AND id_supplier = '7' 01/08/2024 11:54:02 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '12995' , '7' , '1' ) 01/08/2024 11:54:02 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92798' , '1826' , 'CATECHISMO DELLA CHIESA CATTOLICA COMPENDIO' , '4' , '0' , '4' , '6.5000' , '6.5' , '0' , '33+26' , '12.89' ) 01/08/2024 11:54:02 am >> DELETE FROM ps_product_supplier WHERE id_product = '1826' AND id_supplier = '7' 01/08/2024 11:54:02 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '1826' , '7' , '1' ) 01/08/2024 11:54:02 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92798' , '1132' , 'BIBBIA DELLA PRIMA COMUNIONE - RIL' , '10' , '0' , '4' , '12.9000' , '12.9' , '0' , '33+26' , '63.96' ) 01/08/2024 11:54:02 am >> DELETE FROM ps_product_supplier WHERE id_product = '1132' AND id_supplier = '7' 01/08/2024 11:54:02 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '1132' , '7' , '1' ) 01/08/2024 11:54:02 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92798' , '5929' , 'LODI E VESPRI' , '100' , '0' , '4' , '4.5000' , '4.5' , '0' , '33+26' , '223.11' ) 01/08/2024 11:54:02 am >> DELETE FROM ps_product_supplier WHERE id_product = '5929' AND id_supplier = '7' 01/08/2024 11:54:02 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '5929' , '7' , '1' ) 01/08/2024 11:54:02 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92798' , '3528' , 'DIO VIVO E VERO - L. F. LADARIA' , '1' , '0' , '4' , '59.0000' , '59' , '0' , '33+26' , '29.25' ) 01/08/2024 11:54:03 am >> DELETE FROM ps_product_supplier WHERE id_product = '3528' AND id_supplier = '7' 01/08/2024 11:54:03 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '3528' , '7' , '1' ) 01/08/2024 11:54:03 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92798' , '17529' , 'NUOVO RITO DELLA MESSA' , '10' , '0' , '4' , '1.5000' , '1.5' , '0' , '33+26' , '7.44' ) 01/08/2024 11:54:03 am >> DELETE FROM ps_product_supplier WHERE id_product = '17529' AND id_supplier = '7' 01/08/2024 11:54:03 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17529' , '7' , '1' ) 01/08/2024 11:54:03 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92798' , '4487' , 'GESÙ NEL CUORE - ALBUM PRIMA COMUNIONE' , '1' , '0' , '4' , '12.9000' , '12.9' , '0' , '35+24' , '6.37' ) 01/08/2024 11:54:03 am >> DELETE FROM ps_product_supplier WHERE id_product = '4487' AND id_supplier = '7' 01/08/2024 11:54:03 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4487' , '7' , '1' ) 01/08/2024 11:54:03 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92798' , '17186' , 'MIA PRIMA COMUNIONE - ALBUM' , '1' , '0' , '4' , '14.9000' , '14.9' , '0' , '35+24' , '7.36' ) 01/08/2024 11:54:03 am >> DELETE FROM ps_product_supplier WHERE id_product = '17186' AND id_supplier = '7' 01/08/2024 11:54:03 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17186' , '7' , '1' ) 01/08/2024 11:54:03 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92798' , '15227' , 'ALBUM DELLA PRIMA COMUNIONE' , '1' , '0' , '4' , '12.9000' , '12.9' , '0' , '35+24' , '6.37' ) 01/08/2024 11:54:03 am >> DELETE FROM ps_product_supplier WHERE id_product = '15227' AND id_supplier = '7' 01/08/2024 11:54:03 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '15227' , '7' , '1' ) 01/08/2024 11:54:03 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92798' , '16704' , 'BIBBIA RACCONTATA AI RAGAZZI' , '1' , '0' , '4' , '16.0000' , '16' , '0' , '35+24' , '7.90' ) 01/08/2024 11:54:03 am >> DELETE FROM ps_product_supplier WHERE id_product = '16704' AND id_supplier = '7' 01/08/2024 11:54:03 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16704' , '7' , '1' ) 01/08/2024 11:54:03 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92798' , '16702' , 'EVANGELIARIO' , '1' , '0' , '4' , '109.0000' , '109' , '0' , '33+26' , '54.04' ) 01/08/2024 11:54:03 am >> DELETE FROM ps_product_supplier WHERE id_product = '16702' AND id_supplier = '7' 01/08/2024 11:54:03 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16702' , '7' , '1' ) 01/08/2024 11:54:03 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92798' , '14000' , 'GALATEO IN CHIESA' , '10' , '0' , '4' , '1.0000' , '1' , '0' , '33+26' , '4.96' ) 01/08/2024 11:54:03 am >> DELETE FROM ps_product_supplier WHERE id_product = '14000' AND id_supplier = '7' 01/08/2024 11:54:03 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '14000' , '7' , '1' ) 01/08/2024 11:54:03 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92798' , '1102' , 'BIBBIA BROSSURA OLANDESE' , '1' , '0' , '4' , '26.9000' , '26.9' , '0' , '33+26' , '13.34' ) 01/08/2024 11:54:03 am >> DELETE FROM ps_product_supplier WHERE id_product = '1102' AND id_supplier = '7' 01/08/2024 11:54:03 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '1102' , '7' , '1' ) 01/08/2024 11:54:03 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92798' , '21185' , 'RIPORTARE I GIOVANI A MESSA - A. MATTEO' , '1' , '0' , '4' , '13.0000' , '13' , '0' , '33+26' , '6.45' ) 01/08/2024 11:54:03 am >> DELETE FROM ps_product_supplier WHERE id_product = '21185' AND id_supplier = '7' 01/08/2024 11:54:03 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21185' , '7' , '1' ) 01/08/2024 11:54:03 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92798' , '10914' , 'UNA COMUNITÀ LEGGE IL VANGELO DI GIOVANNI' , '1' , '0' , '4' , '48.0000' , '48' , '0' , '33+26' , '23.80' ) 01/08/2024 11:54:03 am >> DELETE FROM ps_product_supplier WHERE id_product = '10914' AND id_supplier = '7' 01/08/2024 11:54:03 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '10914' , '7' , '1' ) 01/08/2024 12:36:47 pm >> SELECT document_num FROM ps_document WHERE document_num = '2407' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-08-01') 01/08/2024 12:36:47 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' , '2407' , '2024-08-01' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '110.00' , '91.23' , NOW() , NOW() ) 01/08/2024 12:36:47 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 = '92799' 01/08/2024 12:36:47 pm >> DELETE FROM ps_document_detail WHERE id_document = '92799' 01/08/2024 12:36: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 ( '92799' , '11384' , 'VINO BIANCO DOLCE - 102' , '1' , '-1' , '1' , '8.90' , '7.2950819672131' , '22' , '0' , '8.90' ) 01/08/2024 12:36: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 ( '92799' , '16689' , 'OSTIA PAN DI CENA mm80' , '2' , '-2' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '4.00' ) 01/08/2024 12:36: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 ( '92799' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '1' , '-1' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '3.50' ) 01/08/2024 12:36: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 ( '92799' , '16248' , 'APPENDICHIAVI 16X11' , '1' , '-1' , '1' , '14.9' , '12.213114754098' , '22' , '0' , '14.90' ) 01/08/2024 12:36: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 ( '92799' , '22756' , 'CROCIFISSO SAGOMATO 30X19 - 1030161' , '1' , '-1' , '1' , '78.7' , '64.508196721311' , '22' , '0' , '78.70' )