Facturador Falla de Impuesto2
Ignacio2023
plain_text
6 months ago
2.9 kB
6
Indexable
Partidas de Nota SN10 select tipodoc,numdoc,numpar,numart,cant,precio,impuesto1,impuesto2 from movim where trim(numdoc)='SN10'; +---------+------------+--------+----------------------+-------+-----------+-----------+-----------+ | tipodoc | numdoc | numpar | numart | cant | precio | impuesto1 | impuesto2 | +---------+------------+--------+----------------------+-------+-----------+-----------+-----------+ | N | SN10 | 1 | INSEC1 | 1.000 | 350.00000 | 16.00 | 3.00 | | N | SN10 | 2 | ABRE | 1.000 | 431.03450 | 16.00 | 0.00 | +---------+------------+--------+----------------------+-------+-----------+-----------+-----------+ 2 rows in set (0.001 sec) Partidas de Factura AF24 MariaDB [facturademosait]> select tipodoc,numdoc,numpar,numart,cant,precio,impuesto1,impuesto2 from movim where trim(numdoc)='AF24'; +---------+------------+--------+----------------------+-------+-----------+-----------+-----------+ | tipodoc | numdoc | numpar | numart | cant | precio | impuesto1 | impuesto2 | +---------+------------+--------+----------------------+-------+-----------+-----------+-----------+ | F | AF24 | 1 | INSEC1 | 1.000 | 350.00000 | 16.00 | 3.00 | | F | AF24 | 2 | ABRE | 1.000 | 431.03450 | 16.00 | 0.00 | | DV | AF24 | 1 | INSEC1 | 1.000 | 350.00000 | 16.00 | NULL | | DV | AF24 | 2 | ABRE | 1.000 | 431.03450 | 16.00 | NULL | +---------+------------+--------+----------------------+-------+-----------+-----------+-----------+ 4 rows in set (0.001 sec) Totales de cada Documento MariaDB [facturademosait]> select tipodoc,numdoc,numalm,numcli,fecha,hora,importe,descuento,impuesto1,impuesto2,importe-descuento+impuesto1+impuesto2 as total from docum where trim(numdoc)="SN10 " or trim(numdoc)="AF24"; +---------+------------+--------+--------+------------+----------+---------+-----------+-----------+-----------+--------+ | tipodoc | numdoc | numalm | numcli | fecha | hora | importe | descuento | impuesto1 | impuesto2 | total | +---------+------------+--------+--------+------------+----------+---------+-----------+-----------+-----------+--------+ | N | SN10 | 15 | 0 | 2024-10-04 | 18:15:26 | 781.03 | 0.00 | 126.65 | 10.50 | 918.18 | | F | AF24 | 15 | 0 | 2024-10-04 | 18:16:56 | 781.03 | 0.00 | 137.15 | 0.00 | 918.18 | | DV | AF24 | 15 | 0 | 2024-10-04 | 18:21:14 | 781.03 | 0.00 | 137.15 | 0.00 | 918.18 | +---------+------------+--------+--------+------------+----------+---------+-----------+-----------+-----------+--------+
Editor is loading...
Leave a Comment