Facturador Falla de Impuesto2

 avatar
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