08/09/2023 09:43:14 am >> SELECT document_num FROM ps_document WHERE document_num = '2353' AND id_document != '86710' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-07-11') 08/09/2023 09:43:14 am >> UPDATE ps_document SET id_document_type = '11', document_num = '2353', document_date = '2023-07-11', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '45.00', price_tax_excluded = '38.26', date_upd = NOW() WHERE id_document = '86710' 08/09/2023 09:43: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 = '86710' 08/09/2023 09:43:14 am >> DELETE FROM ps_document_detail WHERE id_document = '86710' 08/09/2023 09:43:14 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 ( '86710' , '17617' , 'IMMAGINI ISONZO X 100' , '2' , '-2' , '1' , '3.7000' , '3.0327868852459' , '22' , '0' , '7.40' ) 08/09/2023 09:43:14 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 ( '86710' , '9690' , 'SCAPOLARE DEL CARMELO - 8339' , '1' , '-1' , '4' , '5.0000' , '5' , '0' , '5' , '4.75' ) 08/09/2023 09:43:14 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 ( '86710' , '15807' , 'BEATA VERGINE DEL MONTE CARMELO - D. MUSSO' , '1' , '-1' , '4' , '3.0000' , '3' , '0' , '5' , '2.85' ) 08/09/2023 09:43:14 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 ( '86710' , '20507' , 'CONFEZIONE SCATOLA PORTA CIUCCIO - CEL' , '1' , '-1' , '1' , '21.9000' , '17.950819672131' , '22' , '0' , '21.90' ) 08/09/2023 09:43:14 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 ( '86710' , '3016' , 'CROCE LEGNO MDF STILIZZ. CELESTE - AN 092-C - OGGETTI' , '1' , '-1' , '1' , '8.1' , '6.6393442622951' , '22' , '0' , '8.10' ) 08/09/2023 11:27:53 am >> SELECT ean13 FROM ps_product WHERE ean13 = '0205482/F' AND id_product != '16796' AND ean13 != '' 08/09/2023 11:27:53 am >> UPDATE ps_product SET id_supplier = '36', reference = '', ean13 = '0205482/F', date_upd = NOW() WHERE id_product = '16796' 08/09/2023 11:27:53 am >> UPDATE ps_product_lang SET name = 'LUMINO 5F BIANCO', description = '' WHERE id_product = '16796' 08/09/2023 11:27:53 am >> UPDATE ps_product SET wholesale_price = '0.08', on_sale = '0', price = '0.2459016393442623' WHERE id_product = '16796' 08/09/2023 11:27:53 am >> UPDATE ps_product_shop SET wholesale_price = '0.08', price = '0.2459016393442623', id_tax_rules_group = '1', id_category_default = '205', id_argoment_default = '42', id_internal_category = '3', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '16796' 08/09/2023 11:27:53 am >> DELETE FROM ps_specific_price WHERE id_product = '16796' 08/09/2023 11:28:08 am >> SELECT ean13 FROM ps_product WHERE ean13 = '0205481/F' AND id_product != '16795' AND ean13 != '' 08/09/2023 11:28:08 am >> UPDATE ps_product SET id_supplier = '36', reference = '', ean13 = '0205481/F', date_upd = NOW() WHERE id_product = '16795' 08/09/2023 11:28:08 am >> UPDATE ps_product_lang SET name = 'LUMINO 5F ROSSO', description = '' WHERE id_product = '16795' 08/09/2023 11:28:08 am >> UPDATE ps_product SET wholesale_price = '0.08', on_sale = '0', price = '0.2459016393442623' WHERE id_product = '16795' 08/09/2023 11:28:08 am >> UPDATE ps_product_shop SET wholesale_price = '0.08', price = '0.2459016393442623', id_tax_rules_group = '1', id_category_default = '205', id_argoment_default = '42', id_internal_category = '3', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '16795' 08/09/2023 11:28:08 am >> DELETE FROM ps_specific_price WHERE id_product = '16795' 08/09/2023 11:40:40 am >> SELECT document_num FROM ps_document WHERE document_num = '2771' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-09-08') 08/09/2023 11:40: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' , '2771' , '2023-09-08' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '3.50' , '3.50' , NOW() , NOW() ) 08/09/2023 11:40: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 = '87232' 08/09/2023 11:40:40 am >> DELETE FROM ps_document_detail WHERE id_document = '87232' 08/09/2023 11:40: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 ( '87232' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '3.5' , '3.5' , '0' , '0' , '3.50' ) 08/09/2023 12:17:56 pm >> SELECT document_num FROM ps_document WHERE document_num = '17/S' AND id_document != '' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2023-09-08') 08/09/2023 12:17:56 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '23' , '17/S' , '2023-09-08' , 'S' , '3541' , '17' , '4672903' , 'VIA T. TASSO, 10 24020 GORLE' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '3' , '0' , '75.00' , '75.00' , NOW() , NOW() ) 08/09/2023 12:17:56 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '12143' 08/09/2023 12:17:56 pm >> DELETE FROM ps_document_detail WHERE id_document = '12143' 08/09/2023 12:17:56 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '12143' , '111' , 'I NONNI SONO UN TESORO' , '100' , '-100' , '4' , '1.5' , '1.5' , '0' , '50' , '75.00' ) 08/09/2023 12:17:56 pm >> DELETE FROM ps_product_supplier WHERE id_product = '111' AND id_supplier = '17' 08/09/2023 12:17:56 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '111' , '17' , '1' ) 08/09/2023 12:26:41 pm >> SELECT document_num FROM ps_document WHERE document_num = '2772' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-09-08') 08/09/2023 12:26:41 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' , '2772' , '2023-09-08' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '64.40' , '52.79' , NOW() , NOW() ) 08/09/2023 12:26:41 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 = '87233' 08/09/2023 12:26:41 pm >> DELETE FROM ps_document_detail WHERE id_document = '87233' 08/09/2023 12:26:41 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 ( '87233' , '21521' , 'PREGHIERA DELLO STUDENTE - 50 PZ' , '6' , '-6' , '1' , '10.00' , '8.1967213114754' , '22' , '0' , '60.00' ) 08/09/2023 12:26:41 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 ( '87233' , '18122' , 'ROCCA STOPPINO M. 100 - 469/100' , '4' , '-4' , '1' , '1.10' , '0.9016393442623' , '22' , '0' , '4.40' ) 08/09/2023 12:29:27 pm >> SELECT document_num FROM ps_document WHERE document_num = '2773' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-09-08') 08/09/2023 12:29: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' , '2773' , '2023-09-08' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '15.20' , '15.20' , NOW() , NOW() ) 08/09/2023 12:29: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 = '87234' 08/09/2023 12:29:27 pm >> DELETE FROM ps_document_detail WHERE id_document = '87234' 08/09/2023 12:29: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 ( '87234' , '15996' , 'TELEMACO NON SI SBAGLIAVA - L. EPICOCO' , '1' , '-1' , '4' , '16.00' , '16' , '0' , '5' , '15.20' ) 08/09/2023 03:39:46 pm >> SELECT document_num FROM ps_document WHERE document_num = '2774' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-09-08') 08/09/2023 03:39:46 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' , '2774' , '2023-09-08' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '125.50' , '118.29' , NOW() , NOW() ) 08/09/2023 03:39:46 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 = '87235' 08/09/2023 03:39:46 pm >> DELETE FROM ps_document_detail WHERE id_document = '87235' 08/09/2023 03:39: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 ( '87235' , '1425' , 'BUSTA 100 FLAMBEAUX IN CARTA - FLAM' , '5' , '-5' , '1' , '8.00' , '6.5573770491803' , '22' , '0' , '40.00' ) 08/09/2023 03:39: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 ( '87235' , '5774' , 'LEZIONARIO PER LE CELEBRAZIONI DEI SANTI' , '1' , '-1' , '4' , '90.00' , '90' , '0' , '5' , '85.50' ) 08/09/2023 03:43:41 pm >> UPDATE ps_address SET deleted='1' , active = '0' WHERE id_customer = '3487' 08/09/2023 03:43:41 pm >> INSERT INTO ps_address ( id_customer , id_country , id_state , company , lastname , firstname , address1 , address2 , postcode , city , other , phone , phone_mobile , vat_number , dni , date_add , date_upd ) VALUES ( '3487' , '10' , '135' , 'CENTRO CULTURALE CATTOLICO' , '' , '' , 'VIA TORQUATO TASSO, 10' , '' , '24020' , 'GORLE' , '' , '035.665606' , '' , '01714310164' , '01714310164' , NOW() , NOW() ) 08/09/2023 03:43:41 pm >> UPDATE ps_customer SET email = 'arcangela@velar.it', sdi = 'SUBM70N', pec = '', date_upd = NOW() WHERE id_customer = '3487' 08/09/2023 03:43:51 pm >> SELECT document_num FROM ps_document WHERE document_num = '17/S' AND id_document != '12143' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2023-09-08') 08/09/2023 03:43:51 pm >> UPDATE ps_document SET id_document_type = '23', document_num = '17/S', document_date = '2023-09-08', document_letter = 'S', id_customer = '3541', id_supplier = '', id_address = '4672903', address1 = 'VIA T. TASSO, 10 24020 GORLE', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '3', id_causal = '0', price_tax_included = '75.00', price_tax_excluded = '75.00', date_upd = NOW() WHERE id_document = '12143' 08/09/2023 03:43:51 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 = '12143' 08/09/2023 03:43:51 pm >> DELETE FROM ps_document_detail WHERE id_document = '12143' 08/09/2023 03:43:51 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 ( '12143' , '111' , 'I NONNI SONO UN TESORO' , '100' , '-100' , '4' , '1.5000' , '1.5' , '0' , '50' , '75.00' ) 08/09/2023 03:47:01 pm >> UPDATE ps_address SET deleted='1' , active = '0' WHERE id_customer = '3487' 08/09/2023 03:47:01 pm >> INSERT INTO ps_address ( id_customer , id_country , id_state , company , lastname , firstname , address1 , address2 , postcode , city , other , phone , phone_mobile , vat_number , dni , date_add , date_upd ) VALUES ( '3487' , '10' , '135' , 'CENTRO CULTURALE CATTOLICO' , '' , '' , 'VIA TORQUATO TASSO, 10' , '' , '24020' , 'GORLE' , '' , '035.665606' , '' , '01714310164' , '01714310164' , NOW() , NOW() ) 08/09/2023 03:47:01 pm >> UPDATE ps_customer SET email = 'arcangela@velar.it', sdi = 'SUBM70N', pec = '', date_upd = NOW() WHERE id_customer = '3487' 08/09/2023 03:47:10 pm >> SELECT document_num FROM ps_document WHERE document_num = '17/S' AND id_document != '12143' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2023-09-08') 08/09/2023 03:47:10 pm >> UPDATE ps_document SET id_document_type = '23', document_num = '17/S', document_date = '2023-09-08', document_letter = 'S', id_customer = '3487', id_supplier = '0', id_address = '144688385', address1 = 'VIA T. TASSO, 10 24020 GORLE', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '3', id_causal = '0', price_tax_included = '75.00', price_tax_excluded = '75.00', date_upd = NOW() WHERE id_document = '12143' 08/09/2023 03:47:10 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 = '12143' 08/09/2023 03:47:10 pm >> DELETE FROM ps_document_detail WHERE id_document = '12143' 08/09/2023 03:47:10 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '12143' , '111' , 'I NONNI SONO UN TESORO' , '100' , '-100' , '4' , '1.5000' , '1.5' , '0' , '50' , '75.00' ) 08/09/2023 04:50:52 pm >> SELECT document_num FROM ps_document WHERE document_num = '2775' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-09-08') 08/09/2023 04:50:53 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' , '2775' , '2023-09-08' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '59.00' , '48.36' , NOW() , NOW() ) 08/09/2023 04:50:53 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '87236' 08/09/2023 04:50:53 pm >> DELETE FROM ps_document_detail WHERE id_document = '87236' 08/09/2023 04:50:53 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87236' , '19102' , 'CARBONCINI MM 40' , '1' , '-1' , '1' , '13.00' , '10.655737704918' , '22' , '0' , '13.00' ) 08/09/2023 04:50:53 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87236' , '19099' , 'INCENSO A' , '1' , '-1' , '1' , '46.00' , '37.704918032787' , '22' , '0' , '46.00' ) 08/09/2023 04:52:39 pm >> SELECT document_num FROM ps_document WHERE document_num = '2776' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-09-08') 08/09/2023 04:52:39 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' , '2776' , '2023-09-08' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '51.30' , '51.30' , NOW() , NOW() ) 08/09/2023 04:52:39 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 = '87237' 08/09/2023 04:52:39 pm >> DELETE FROM ps_document_detail WHERE id_document = '87237' 08/09/2023 04:52:39 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 ( '87237' , '11151' , 'LIBRI' , '3' , '-3' , '4' , '18' , '18' , '0' , '5' , '51.30' ) 08/09/2023 05:07:09 pm >> SELECT document_num FROM ps_document WHERE document_num = '89/A' AND id_document != '' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2023-09-08') 08/09/2023 05:07:09 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 ( '24' , '89/A' , '2023-09-08' , 'A' , '3030' , '0' , '4671709' , 'VIA SAN FELICE IN FELLINE, 10 84134 SALERNO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '201.00' , '164.75' , NOW() , NOW() ) 08/09/2023 05:07:09 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '87238' 08/09/2023 05:07:09 pm >> DELETE FROM ps_document_detail WHERE id_document = '87238' 08/09/2023 05:07:09 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 ( '87238' , '791' , 'ASSISI IN BUSTA BATTESIMO - 20X270 - BAAS' , '20' , '-20' , '1' , '1.40' , '1.1475409836066' , '22' , '0' , '28.00' ) 08/09/2023 05:07:09 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 ( '87238' , '15387' , 'VESTINA BATTESIMALE ' , '20' , '-20' , '1' , '2.5' , '2.0491803278689' , '22' , '0' , '50.00' ) 08/09/2023 05:07:10 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87238' , '7202' , 'ARTICOLI RELIGIOSI' , '3' , '-3' , '1' , '41' , '33.606557377049' , '22' , '0' , '123.00' ) 08/09/2023 05:30:24 pm >> SELECT document_num FROM ps_document WHERE document_num = '2777' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-09-08') 08/09/2023 05:30:24 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' , '2777' , '2023-09-08' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '104.50' , '104.50' , NOW() , NOW() ) 08/09/2023 05:30:24 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 = '87239' 08/09/2023 05:30:24 pm >> DELETE FROM ps_document_detail WHERE id_document = '87239' 08/09/2023 05:30:25 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 ( '87239' , '17329' , 'MESSALE ROMANO DALTARE N.E' , '1' , '-1' , '4' , '110.00' , '110' , '0' , '5' , '104.50' ) 08/09/2023 06:49:37 pm >> SELECT document_num FROM ps_document WHERE document_num = '2778' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-09-08') 08/09/2023 06:49:37 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' , '2778' , '2023-09-08' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '15.20' , '15.20' , NOW() , NOW() ) 08/09/2023 06:49:37 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 = '87240' 08/09/2023 06:49:37 pm >> DELETE FROM ps_document_detail WHERE id_document = '87240' 08/09/2023 06:49:37 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 ( '87240' , '21516' , 'LAVORARE INSIEME. LAVORARE MEGLIO' , '1' , '-1' , '4' , '16.00' , '16' , '0' , '5' , '15.20' ) 08/09/2023 07:11:32 pm >> SELECT document_num FROM ps_document WHERE document_num = '2779' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-09-08') 08/09/2023 07:11:32 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' , '2779' , '2023-09-08' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '26.00' , '21.31' , NOW() , NOW() ) 08/09/2023 07:11:32 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 = '87241' 08/09/2023 07:11:32 pm >> DELETE FROM ps_document_detail WHERE id_document = '87241' 08/09/2023 07:11:32 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 ( '87241' , '15492' , 'CROCE SAN BENEDETTO CON BASE E LEGNO - CZ6BSNIK' , '1' , '-1' , '1' , '26.00' , '21.311475409836' , '22' , '0' , '26.00' )