09/09/2023 09:46:48 am >> SELECT document_num FROM ps_document WHERE document_num = '2780' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-09-09') 09/09/2023 09:46: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' , '2780' , '2023-09-09' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '4.75' , '4.75' , NOW() , NOW() ) 09/09/2023 09:46: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 = '87242' 09/09/2023 09:46:48 am >> DELETE FROM ps_document_detail WHERE id_document = '87242' 09/09/2023 09:46: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 ( '87242' , '21192' , 'SULLA TUA PAROLA - SET/OTT 23' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' ) 09/09/2023 10:42:53 am >> SELECT document_num FROM ps_document WHERE document_num = '2781' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-09-09') 09/09/2023 10: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' , '2781' , '2023-09-09' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '3.00' , '3.00' , NOW() , NOW() ) 09/09/2023 10: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 = '87243' 09/09/2023 10:42:53 am >> DELETE FROM ps_document_detail WHERE id_document = '87243' 09/09/2023 10: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 ( '87243' , '21490' , 'CALENDARIO LITURGICO 2024 - 8478' , '1' , '-1' , '4' , '1.00' , '1' , '0' , '0' , '1.00' ) 09/09/2023 10: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 ( '87243' , '21479' , 'PENSIERI E PREGHIERE DI DON DOLINDO - 8517' , '1' , '-1' , '4' , '2.00' , '2' , '0' , '0' , '2.00' ) 09/09/2023 11:56:16 am >> SELECT document_num FROM ps_document WHERE document_num = '2782' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-09-09') 09/09/2023 11:56:16 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' , '2782' , '2023-09-09' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '27.00' , '23.84' , NOW() , NOW() ) 09/09/2023 11:56:16 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 = '87244' 09/09/2023 11:56:16 am >> DELETE FROM ps_document_detail WHERE id_document = '87244' 09/09/2023 11:56: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 ( '87244' , '19689' , 'NEL VOSTRO AMORE - PAPA FRANCESCO' , '1' , '-1' , '4' , '10.00' , '10' , '0' , '5' , '9.50' ) 09/09/2023 11:56: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 ( '87244' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '16.5' , '13.524590163934' , '22' , '0' , '16.50' ) 09/09/2023 11:56: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 ( '87244' , '17005' , 'BIGLIETTO AUGURALE medio' , '1' , '-1' , '1' , '1.00' , '0.81967213114754' , '22' , '0' , '1.00' ) 09/09/2023 12:16:49 pm >> SELECT document_num FROM ps_document WHERE document_num = '2783' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-09-09') 09/09/2023 12:16:49 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' , '2783' , '2023-09-09' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '12.17' , '12.17' , NOW() , NOW() ) 09/09/2023 12:16:49 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 = '87245' 09/09/2023 12:16:49 pm >> DELETE FROM ps_document_detail WHERE id_document = '87245' 09/09/2023 12:16:49 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 ( '87245' , '21199' , 'AMEN - OTT 23' , '1' , '-1' , '4' , '3.90' , '3.9' , '0' , '5' , '3.71' ) 09/09/2023 12:16:49 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 ( '87245' , '21198' , 'AMEN - SET 2023' , '1' , '-1' , '4' , '3.90' , '3.9' , '0' , '5' , '3.71' ) 09/09/2023 12:16:49 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 ( '87245' , '21519' , 'SULLA TUA PAROLA - NOV DIC 23' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' )