02/07/2022 09:14:53 am >> SELECT document_num FROM ps_document WHERE document_num = '2113' AND id_document != '58980' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-06-30') 02/07/2022 09:14:53 am >> UPDATE ps_document SET id_document_type = '11', document_num = '2113', document_date = '2022-06-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 = '19.50', price_tax_excluded = '19.50', date_upd = NOW() WHERE id_document = '58980' 02/07/2022 09:14: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 = '58980' 02/07/2022 09:14:53 am >> DELETE FROM ps_document_detail WHERE id_document = '58980' 02/07/2022 09:14: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 ( '58980' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '10' , '10' , '0' , '0' , '10.00' ) 02/07/2022 09:14:53 am >> DELETE FROM ps_product_supplier WHERE id_product = '11151' AND id_supplier = '' 02/07/2022 09:14:53 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11151' , '' , '1' ) 02/07/2022 09:14: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 ( '58980' , '19467' , 'SULLA TUA PAROLA - LUG/AGO 2022' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' ) 02/07/2022 09:14:53 am >> DELETE FROM ps_product_supplier WHERE id_product = '19467' AND id_supplier = '' 02/07/2022 09:14:53 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19467' , '' , '1' ) 02/07/2022 09:14: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 ( '58980' , '19622' , 'SULLA TUA PAROLA - SETT/OTT 2022' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' ) 02/07/2022 09:14:53 am >> DELETE FROM ps_product_supplier WHERE id_product = '19622' AND id_supplier = '' 02/07/2022 09:14:53 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19622' , '' , '1' ) 02/07/2022 09:15:22 am >> SELECT document_num FROM ps_document WHERE document_num = '2113' AND id_document != '58980' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-06-30') 02/07/2022 09:15:22 am >> UPDATE ps_document SET id_document_type = '11', document_num = '2113', document_date = '2022-06-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 = '19.50', price_tax_excluded = '19.50', date_upd = NOW() WHERE id_document = '58980' 02/07/2022 09:15: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 = '58980' 02/07/2022 09:15:23 am >> DELETE FROM ps_document_detail WHERE id_document = '58980' 02/07/2022 09:15:23 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58980' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '6.5' , '6.5' , '0' , '0' , '6.50' ) 02/07/2022 09:15:23 am >> DELETE FROM ps_product_supplier WHERE id_product = '11151' AND id_supplier = '' 02/07/2022 09:15:23 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11151' , '' , '1' ) 02/07/2022 09:15:23 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58980' , '19467' , 'SULLA TUA PAROLA - LUG/AGO 2022' , '1' , '-1' , '4' , '5.0000' , '5' , '0' , '5' , '4.75' ) 02/07/2022 09:15:23 am >> DELETE FROM ps_product_supplier WHERE id_product = '19467' AND id_supplier = '' 02/07/2022 09:15:23 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19467' , '' , '1' ) 02/07/2022 09:15:23 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58980' , '19622' , 'SULLA TUA PAROLA - SETT/OTT 2022' , '1' , '-1' , '4' , '5.0000' , '5' , '0' , '5' , '4.75' ) 02/07/2022 09:15:23 am >> DELETE FROM ps_product_supplier WHERE id_product = '19622' AND id_supplier = '' 02/07/2022 09:15:23 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19622' , '' , '1' ) 02/07/2022 09:15:23 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58980' , '19664' , 'ANTONIO ROSMINI - V. SALVOLDI' , '1' , '-1' , '4' , '3.50' , '3.5' , '0' , '0' , '3.50' ) 02/07/2022 09:15:23 am >> DELETE FROM ps_product_supplier WHERE id_product = '19664' AND id_supplier = '' 02/07/2022 09:15:23 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19664' , '' , '1' ) 02/07/2022 09:35:24 am >> SELECT document_num FROM ps_document WHERE document_num = '2146' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-07-02') 02/07/2022 09:35: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' , '2146' , '2022-07-02' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '3.50' , '3.50' , NOW() , NOW() ) 02/07/2022 09:35: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 = '59019' 02/07/2022 09:35:24 am >> DELETE FROM ps_document_detail WHERE id_document = '59019' 02/07/2022 09:35: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 ( '59019' , '4223' , 'FOGLIETTI LA DOMENICA SAN PAOLO' , '5' , '-5' , '4' , '0.70' , '0.7' , '0' , '0' , '3.50' ) 02/07/2022 09:35:24 am >> DELETE FROM ps_product_supplier WHERE id_product = '4223' AND id_supplier = '' 02/07/2022 09:35:24 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4223' , '' , '1' ) 02/07/2022 09:37:38 am >> SELECT document_num FROM ps_document WHERE document_num = '2147' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-07-02') 02/07/2022 09:37:38 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2147' , '2022-07-02' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '37.80' , '33.04' , NOW() , NOW() ) 02/07/2022 09:37:38 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '59020' 02/07/2022 09:37:38 am >> DELETE FROM ps_document_detail WHERE id_document = '59020' 02/07/2022 09:37:38 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '59020' , '19431' , 'PALLONCINO MAGNETE 12X15 - PM' , '2' , '-2' , '1' , '12.20' , '10' , '22' , '0' , '24.40' ) 02/07/2022 09:37:38 am >> DELETE FROM ps_product_supplier WHERE id_product = '19431' AND id_supplier = '' 02/07/2022 09:37:38 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19431' , '' , '1' ) 02/07/2022 09:37:38 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '59020' , '19291' , 'VENGELO DELLA PRIMA COMUNIONE' , '1' , '-1' , '4' , '12.00' , '12' , '0' , '5' , '11.40' ) 02/07/2022 09:37:38 am >> DELETE FROM ps_product_supplier WHERE id_product = '19291' AND id_supplier = '' 02/07/2022 09:37:38 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19291' , '' , '1' ) 02/07/2022 09:37:38 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '59020' , '17005' , 'BIGLIETTO AUGURALE medio' , '2' , '-2' , '1' , '1.00' , '0.81967213114754' , '22' , '0' , '2.00' ) 02/07/2022 09:37:38 am >> DELETE FROM ps_product_supplier WHERE id_product = '17005' AND id_supplier = '' 02/07/2022 09:37:38 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17005' , '' , '1' ) 02/07/2022 10:09:59 am >> SELECT document_num FROM ps_document WHERE document_num = '2148' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-07-02') 02/07/2022 10:09:59 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' , '2148' , '2022-07-02' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '3.00' , '3.00' , NOW() , NOW() ) 02/07/2022 10:09: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 = '59021' 02/07/2022 10:09:59 am >> DELETE FROM ps_document_detail WHERE id_document = '59021' 02/07/2022 10:09:59 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 ( '59021' , '18496' , 'MAZZO DI ROSE A SANTA RITA - 8029' , '1' , '-1' , '4' , '3.00' , '3' , '0' , '0' , '3.00' ) 02/07/2022 10:09:59 am >> DELETE FROM ps_product_supplier WHERE id_product = '18496' AND id_supplier = '' 02/07/2022 10:09:59 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18496' , '' , '1' ) 02/07/2022 10:32:10 am >> SELECT document_num FROM ps_document WHERE document_num = '2149' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-07-02') 02/07/2022 10:32:10 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' , '2149' , '2022-07-02' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '3.90' , '3.90' , NOW() , NOW() ) 02/07/2022 10:32:10 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 = '59022' 02/07/2022 10:32:10 am >> DELETE FROM ps_document_detail WHERE id_document = '59022' 02/07/2022 10:32:10 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 ( '59022' , '19515' , 'AMEN - LUG 2022' , '1' , '-1' , '4' , '3.90' , '3.9' , '0' , '0' , '3.90' ) 02/07/2022 10:32:10 am >> DELETE FROM ps_product_supplier WHERE id_product = '19515' AND id_supplier = '' 02/07/2022 10:32:10 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19515' , '' , '1' ) 02/07/2022 11:33:35 am >> SELECT document_num FROM ps_document WHERE document_num = '2150' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-07-02') 02/07/2022 11:33:35 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' , '2150' , '2022-07-02' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '50.00' , '40.98' , NOW() , NOW() ) 02/07/2022 11:33:35 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 = '59023' 02/07/2022 11:33:35 am >> DELETE FROM ps_document_detail WHERE id_document = '59023' 02/07/2022 11:33:35 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 ( '59023' , '1914' , 'CERA DELLA LITURGIA' , '6' , '-6' , '1' , '4.90' , '4.016393442623' , '22' , '0' , '29.40' ) 02/07/2022 11:33:35 am >> DELETE FROM ps_product_supplier WHERE id_product = '1914' AND id_supplier = '' 02/07/2022 11:33:35 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '1914' , '' , '1' ) 02/07/2022 11:33:35 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 ( '59023' , '5975' , 'LUCERNA IN VETRO ROSSO - DIAM. 14 - 1491' , '1' , '-1' , '1' , '20.6' , '16.885245901639' , '22' , '0' , '20.60' ) 02/07/2022 11:33:36 am >> DELETE FROM ps_product_supplier WHERE id_product = '5975' AND id_supplier = '' 02/07/2022 11:33:36 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '5975' , '' , '1' ) 02/07/2022 11:36:17 am >> SELECT document_num FROM ps_document WHERE document_num = '2151' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-07-02') 02/07/2022 11:36:17 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' , '2151' , '2022-07-02' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '17.40' , '15.24' , NOW() , NOW() ) 02/07/2022 11:36:17 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 = '59024' 02/07/2022 11:36:17 am >> DELETE FROM ps_document_detail WHERE id_document = '59024' 02/07/2022 11:36:17 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 ( '59024' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '5.4' , '5.4' , '0' , '0' , '5.40' ) 02/07/2022 11:36:17 am >> DELETE FROM ps_product_supplier WHERE id_product = '11151' AND id_supplier = '' 02/07/2022 11:36:17 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11151' , '' , '1' ) 02/07/2022 11:36:17 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 ( '59024' , '11756' , 'VINO BIANCO SECCO - 14%' , '1' , '-1' , '1' , '5.50' , '4.5081967213115' , '22' , '0' , '5.50' ) 02/07/2022 11:36:17 am >> DELETE FROM ps_product_supplier WHERE id_product = '11756' AND id_supplier = '' 02/07/2022 11:36:17 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11756' , '' , '1' ) 02/07/2022 11:36:17 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 ( '59024' , '11757' , 'VINO LIQUOROSO DOLCE - 16%' , '1' , '-1' , '1' , '6.50' , '5.327868852459' , '22' , '0' , '6.50' ) 02/07/2022 11:36:17 am >> DELETE FROM ps_product_supplier WHERE id_product = '11757' AND id_supplier = '' 02/07/2022 11:36:17 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11757' , '' , '1' ) 02/07/2022 11:38:55 am >> SELECT document_num FROM ps_document WHERE document_num = '2152' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-07-02') 02/07/2022 11:38:55 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' , '2152' , '2022-07-02' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '27.80' , '23.68' , NOW() , NOW() ) 02/07/2022 11:38:55 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 = '59025' 02/07/2022 11:38:55 am >> DELETE FROM ps_document_detail WHERE id_document = '59025' 02/07/2022 11:38:55 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 ( '59025' , '16691' , 'PARTICOLE PER CELIACI 25pz' , '1' , '-1' , '3' , '4.00' , '3.8461538461538' , '4' , '0' , '4.00' ) 02/07/2022 11:38:55 am >> DELETE FROM ps_product_supplier WHERE id_product = '16691' AND id_supplier = '' 02/07/2022 11:38:55 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16691' , '' , '1' ) 02/07/2022 11:38:55 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 ( '59025' , '13048' , 'TECA STANDARD IHS NIK' , '1' , '-1' , '1' , '22' , '18.032786885246' , '22' , '0' , '22.00' ) 02/07/2022 11:38:55 am >> DELETE FROM ps_product_supplier WHERE id_product = '13048' AND id_supplier = '' 02/07/2022 11:38:55 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '13048' , '' , '1' ) 02/07/2022 11:38:55 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 ( '59025' , '19413' , 'CARI SPOSI E SPOSE SCRIVO A VOI' , '1' , '-1' , '4' , '1.80' , '1.8' , '0' , '0' , '1.80' ) 02/07/2022 11:38:55 am >> DELETE FROM ps_product_supplier WHERE id_product = '19413' AND id_supplier = '' 02/07/2022 11:38:55 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19413' , '' , '1' ) 02/07/2022 11:42:53 am >> SELECT document_num FROM ps_document WHERE document_num = '2153' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-07-02') 02/07/2022 11:42: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' , '2153' , '2022-07-02' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '14.00' , '11.48' , NOW() , NOW() ) 02/07/2022 11:42: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 = '59026' 02/07/2022 11:42:53 am >> DELETE FROM ps_document_detail WHERE id_document = '59026' 02/07/2022 11:42: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 ( '59026' , '5903' , 'LITURGICO ART. 60LT ROSSO SUPER' , '5' , '-5' , '1' , '2.8' , '2.2950819672131' , '22' , '0' , '14.00' ) 02/07/2022 11:42:53 am >> DELETE FROM ps_product_supplier WHERE id_product = '5903' AND id_supplier = '' 02/07/2022 11:42:53 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '5903' , '' , '1' )