kardex valorado con macros - tododocumentos.info

Upload: cesar-flores-huallpa

Post on 05-Jul-2018

243 views

Category:

Documents


3 download

TRANSCRIPT

  • 8/15/2019 Kardex Valorado Con Macros - TodoDocumentos.info

    1/51

    LA SEÑORIAL S.A.C. KARDEX VRUC: 20446321780CODIGO: C00001 DESCRIPCION: ACEITE PRIMOR

    DESCRIPCION NOMBRE PROVEEDOR " CLIENTE UNIDA

    SALIDTOTALES 816

    1/1/2016 INVENTARIO INICIAL VR INV-INIC 180 1/2/2016 COMPRA MCDERIA FT 001-360 10007555232 MARTINEZ OSORIO SUSAN 36 1/5/2016 COMPRA MCDERIA FT F001-3151 20532277320 RAANRO! INVERSIONES EIRL 600

    1/15/2016 VENTAS #V 001-3 0000 CLIENTES VARIOS 1/31/2016 FALTANTE VR 0001 1/31/2016 FALTANTE VR 0001

    'EC#AINGRESO "

    SALIDATIPODOC

    NUMERODOC.

    COD.PROVEEDOR "

    CLIENTE

    ENTRADAS

  • 8/15/2019 Kardex Valorado Con Macros - TodoDocumentos.info

    2/51

  • 8/15/2019 Kardex Valorado Con Macros - TodoDocumentos.info

    3/51

    'EC#A DOC DESCRIPCION TIPO DOC

    1/1/2016 1/1/2016 ARTICULOS DE LIMPIEZA FT 005-15 201152364471/2/2016 1/2/2016 COMPRA MCDERIA FT 001-360 100075552321/3/2016 1/3/2016 COMPRA MCDERIA FT F001-1555 205322773201/3/2016 1/3/2016 COMPRA MCDERIA FT F001-361 205322773201/4/2016 1/4/2016 COMPRA MCDERIA FT F001-2511 205322773201/5/2016 1/5/2016 COMPRA MCDERIA FT F001-3151 205322773201/6/2016 1/6/2016 COMPRA MCDERIA FT F002-1655 205322773201/7/2016 1/7/2016 COMPRA MCDERIA FT 001-2611 203569120311/8/2016 1/8/2016 COMPRA MCDERIA FT 005-233 20859614736

    1/10/2016 1/10/2016 COMPRA MCDERIA FT 010-178 203569120311/15/2016 1/15/2016 COMPRA MCDERIA FT 001-166314 208596147361/20/2016 1/20/2016 COMPRA MCDERIA FT 002-1565 20532277320

    'EC#AINGRESO

    NUMERODOC.

    COD.PROVEEDOR

  • 8/15/2019 Kardex Valorado Con Macros - TodoDocumentos.info

    4/51

  • 8/15/2019 Kardex Valorado Con Macros - TodoDocumentos.info

    5/51

  • 8/15/2019 Kardex Valorado Con Macros - TodoDocumentos.info

    6/51

  • 8/15/2019 Kardex Valorado Con Macros - TodoDocumentos.info

    7/51

    NOMBRE PROVEEDOR ARTICULO DESCRIP. ARTICULO CANTIDAD

    CAR#A$AR EIRL ASTO ASTOS VARIOS TOMARTINEZ OSORIO SUSAN C00001 ACEITE PRIMOR % 1 LITRO 3 C12RA ANRO! INVERSIONES EIRL C00002 ACEITE COCINERO % 1 LITRO 25 DOCRA ANRO! INVERSIONES EIRL C00002 ACEITE COCINERO % 1 LITRO 25 C12RA ANRO! INVERSIONES EIRL C00003 ACEITE CASERA % 1 LITRO 30 C12RA ANRO! INVERSIONES EIRL C00001 ACEITE PRIMOR % 1 LITRO 50 C12RA ANRO! INVERSIONES EIRL C00003 ACEITE CASERA % 1 LITRO 50 C12REPRESENTACIONES SOLEDAD C00004 ARROZ PAISANA % 800 R 10 DOCCARDINAL S.A. C00005 ARROZ PAISANA % 5 ! 10 DOCREPRESENTACIONES SOLEDAD C00006 LEC&E LORIA CLASICA % 165 20 C12CARDINAL S.A. C00007 LEC&E LORIA LI &T % 165 20 C12RA ANRO! INVERSIONES EIRL C00008 LEC&E LORIA NI'OS % 165 35 C12

    (N/A (N/A(N/A (N/A(N/A (N/A(N/A (N/A

    (N/A (N/A(N/A (N/A(N/A (N/A(N/A (N/A(N/A (N/A(N/A (N/A(N/A (N/A(N/A (N/A(N/A (N/A(N/A (N/A(N/A (N/A(N/A (N/A

    (N/A (N/A(N/A (N/A(N/A (N/A(N/A (N/A(N/A (N/A(N/A (N/A(N/A (N/A(N/A (N/A(N/A (N/A(N/A (N/A(N/A (N/A(N/A (N/A

    (N/A (N/A(N/A (N/A(N/A (N/A(N/A (N/A(N/A (N/A(N/A (N/A(N/A (N/A(N/A (N/A

    UNID.MEDIDA

  • 8/15/2019 Kardex Valorado Con Macros - TodoDocumentos.info

    8/51

    (N/A (N/A(N/A (N/A(N/A (N/A(N/A (N/A(N/A (N/A(N/A (N/A(N/A (N/A(N/A (N/A(N/A (N/A(N/A (N/A(N/A (N/A(N/A (N/A(N/A (N/A(N/A (N/A(N/A (N/A(N/A (N/A(N/A (N/A(N/A (N/A

    (N/A (N/A(N/A (N/A(N/A (N/A(N/A (N/A(N/A (N/A(N/A (N/A(N/A (N/A(N/A (N/A(N/A (N/A(N/A (N/A(N/A (N/A(N/A (N/A

    (N/A (N/A(N/A (N/A(N/A (N/A(N/A (N/A(N/A (N/A(N/A (N/A(N/A (N/A(N/A (N/A(N/A (N/A(N/A (N/A(N/A (N/A(N/A (N/A

    (N/A (N/A(N/A (N/A(N/A (N/A(N/A (N/A(N/A (N/A(N/A (N/A(N/A (N/A(N/A (N/A

  • 8/15/2019 Kardex Valorado Con Macros - TodoDocumentos.info

    9/51

    (N/A (N/A(N/A (N/A(N/A (N/A(N/A (N/A(N/A (N/A(N/A (N/A(N/A (N/A(N/A (N/A(N/A (N/A(N/A (N/A(N/A (N/A(N/A (N/A(N/A (N/A(N/A (N/A(N/A (N/A(N/A (N/A(N/A (N/A(N/A (N/A

    (N/A (N/A(N/A (N/A(N/A (N/A(N/A (N/A(N/A (N/A(N/A (N/A(N/A (N/A(N/A (N/A(N/A (N/A(N/A (N/A(N/A (N/A(N/A (N/A

    (N/A (N/A(N/A (N/A(N/A (N/A(N/A (N/A(N/A (N/A(N/A (N/A(N/A (N/A(N/A (N/A(N/A (N/A(N/A (N/A(N/A (N/A(N/A (N/A

    (N/A (N/A(N/A (N/A(N/A (N/A(N/A (N/A(N/A (N/A(N/A (N/A(N/A (N/A(N/A (N/A

  • 8/15/2019 Kardex Valorado Con Macros - TodoDocumentos.info

    10/51

    (N/A (N/A(N/A (N/A(N/A (N/A(N/A (N/A(N/A (N/A(N/A (N/A(N/A (N/A(N/A (N/A(N/A (N/A(N/A (N/A(N/A (N/A(N/A (N/A(N/A (N/A(N/A (N/A(N/A (N/A(N/A (N/A(N/A (N/A(N/A (N/A

    (N/A (N/A(N/A (N/A(N/A (N/A(N/A (N/A(N/A (N/A(N/A (N/A(N/A (N/A(N/A (N/A(N/A (N/A(N/A (N/A(N/A (N/A(N/A (N/A

    (N/A (N/A(N/A (N/A(N/A (N/A(N/A (N/A(N/A (N/A(N/A (N/A(N/A (N/A(N/A (N/A(N/A (N/A(N/A (N/A(N/A (N/A(N/A (N/A

    (N/A (N/A(N/A (N/A

  • 8/15/2019 Kardex Valorado Con Macros - TodoDocumentos.info

    11/51

    MONEDA US " MN MONTO S" VV " PV " NG

    ASTOS VARIOS 0 US 10.00 3.413 34.13 PVCA$A % 12 36 MN 150.00 150.00 PVDOCENA)S* 300 MN 300.00 300.00 PVCA$A % 12 300 MN 1"100.00 1"100.00 PVCA$A % 12 360 MN 1"260.00 1"260.00 PVCA$A % 12 600 MN 2"350.00 2"350.00 PVCA$A % 12 600 MN 2"320.00 2"320.00 PVDOCENA)S* 120 MN 350.00 350.00 PVDOCENA)S* 120 MN 350.00 350.00 VVCA$A % 12 240 MN 700.00 700.00 PVCA$A % 12 240 MN 710.00 710.00 VVCA$A % 12 420 MN 853.50 853.50 PV

    (N/A (N/A -(N/A (N/A -(N/A (N/A -(N/A (N/A -

    (N/A (N/A -(N/A (N/A -(N/A (N/A -(N/A (N/A -(N/A (N/A -(N/A (N/A -(N/A (N/A -(N/A (N/A -(N/A (N/A -(N/A (N/A -(N/A (N/A -(N/A (N/A -

    (N/A (N/A -(N/A (N/A -(N/A (N/A -(N/A (N/A -(N/A (N/A -(N/A (N/A -(N/A (N/A -(N/A (N/A -(N/A (N/A -(N/A (N/A -(N/A (N/A -(N/A (N/A -

    (N/A (N/A -(N/A (N/A -(N/A (N/A -(N/A (N/A -(N/A (N/A -(N/A (N/A -(N/A (N/A -(N/A (N/A -

    DESCRIP. UNID.MEDIDA

    E(UIVALENCIAUNITARIA

    MONTOORIGINAL

    TIPO DECAMBIO

  • 8/15/2019 Kardex Valorado Con Macros - TodoDocumentos.info

    12/51

    (N/A (N/A -(N/A (N/A -(N/A (N/A -(N/A (N/A -(N/A (N/A -(N/A (N/A -(N/A (N/A -(N/A (N/A -(N/A (N/A -(N/A (N/A -(N/A (N/A -(N/A (N/A -(N/A (N/A -(N/A (N/A -(N/A (N/A -(N/A (N/A -(N/A (N/A -(N/A (N/A -

    (N/A (N/A -(N/A (N/A -(N/A (N/A -(N/A (N/A -(N/A (N/A -(N/A (N/A -(N/A (N/A -(N/A (N/A -(N/A (N/A -(N/A (N/A -(N/A (N/A -(N/A (N/A -

    (N/A (N/A -(N/A (N/A -(N/A (N/A -(N/A (N/A -(N/A (N/A -(N/A (N/A -(N/A (N/A -(N/A (N/A -(N/A (N/A -(N/A (N/A -(N/A (N/A -(N/A (N/A -

    (N/A (N/A -(N/A (N/A -(N/A (N/A -(N/A (N/A -(N/A (N/A -(N/A (N/A -(N/A (N/A -(N/A (N/A -

  • 8/15/2019 Kardex Valorado Con Macros - TodoDocumentos.info

    13/51

    (N/A (N/A -(N/A (N/A -(N/A (N/A -(N/A (N/A -(N/A (N/A -(N/A (N/A -(N/A (N/A -(N/A (N/A -(N/A (N/A -(N/A (N/A -(N/A (N/A -(N/A (N/A -(N/A (N/A -(N/A (N/A -(N/A (N/A -(N/A (N/A -(N/A (N/A -(N/A (N/A -

    (N/A (N/A -(N/A (N/A -(N/A (N/A -(N/A (N/A -(N/A (N/A -(N/A (N/A -(N/A (N/A -(N/A (N/A -(N/A (N/A -(N/A (N/A -(N/A (N/A -(N/A (N/A -

    (N/A (N/A -(N/A (N/A -(N/A (N/A -(N/A (N/A -(N/A (N/A -(N/A (N/A -(N/A (N/A -(N/A (N/A -(N/A (N/A -(N/A (N/A -(N/A (N/A -(N/A (N/A -

    (N/A (N/A -(N/A (N/A -(N/A (N/A -(N/A (N/A -(N/A (N/A -(N/A (N/A -(N/A (N/A -(N/A (N/A -

  • 8/15/2019 Kardex Valorado Con Macros - TodoDocumentos.info

    14/51

    (N/A (N/A -(N/A (N/A -(N/A (N/A -(N/A (N/A -(N/A (N/A -(N/A (N/A -(N/A (N/A -(N/A (N/A -(N/A (N/A -(N/A (N/A -(N/A (N/A -(N/A (N/A -(N/A (N/A -(N/A (N/A -(N/A (N/A -(N/A (N/A -(N/A (N/A -(N/A (N/A -

    (N/A (N/A -(N/A (N/A -(N/A (N/A -(N/A (N/A -(N/A (N/A -(N/A (N/A -(N/A (N/A -(N/A (N/A -(N/A (N/A -(N/A (N/A -(N/A (N/A -(N/A (N/A -

    (N/A (N/A -(N/A (N/A -(N/A (N/A -(N/A (N/A -(N/A (N/A -(N/A (N/A -(N/A (N/A -(N/A (N/A -(N/A (N/A -(N/A (N/A -(N/A (N/A -(N/A (N/A -

    (N/A (N/A -(N/A (N/A -

  • 8/15/2019 Kardex Valorado Con Macros - TodoDocumentos.info

    15/51

    IGV

    28.92 5.21 34.13127.12 22.88 150.00254.24 45.76 300.00932.20 167.80 1"100.00

    1"067.80 192.20 1"260.001"991.53 358.47 2"350.001"966.10 353.90 2"320.00

    296.61 53.39 350.00350.00 63.00 413.00593.22 106.78 700.00710.00 127.80 837.80723.31 130.19 853.50

    - - -- - -- - -- - -

    - - -- - -- - -- - -- - -- - -- - -- - -- - -- - -- - -- - -

    - - -- - -- - -- - -- - -- - -- - -- - -- - -- - -- - -- - -

    - - -- - -- - -- - -- - -- - -- - -- - -

    VALOR DECOMPRA

    PRECIO DECOMPRA

  • 8/15/2019 Kardex Valorado Con Macros - TodoDocumentos.info

    16/51

    - - -- - -- - -- - -- - -- - -- - -- - -- - -- - -- - -- - -- - -- - -- - -- - -- - -- - -

    - - -- - -- - -- - -- - -- - -- - -- - -- - -- - -- - -- - -

    - - -- - -- - -- - -- - -- - -- - -- - -- - -- - -- - -- - -

    - - -- - -- - -- - -- - -- - -- - -- - -

  • 8/15/2019 Kardex Valorado Con Macros - TodoDocumentos.info

    17/51

    - - -- - -- - -- - -- - -- - -- - -- - -- - -- - -- - -- - -- - -- - -- - -- - -- - -- - -

    - - -- - -- - -- - -- - -- - -- - -- - -- - -- - -- - -- - -

    - - -- - -- - -- - -- - -- - -- - -- - -- - -- - -- - -- - -

    - - -- - -- - -- - -- - -- - -- - -- - -

  • 8/15/2019 Kardex Valorado Con Macros - TodoDocumentos.info

    18/51

    - - -- - -- - -- - -- - -- - -- - -- - -- - -- - -- - -- - -- - -- - -- - -- - -- - -- - -

    - - -- - -- - -- - -- - -- - -- - -- - -- - -- - -- - -- - -

    - - -- - -- - -- - -- - -- - -- - -- - -- - -- - -- - -- - -

    - - -- - -

  • 8/15/2019 Kardex Valorado Con Macros - TodoDocumentos.info

    19/51

    DESCRIPCION COD. CLIENTE NOMBRE CLIENTE

    1/1/2016 1/1/2016 ANULADO #V 001-1 0001 ANULADO1/2/2016 1/2/2016 VENTAS #V 001-2 15336422 RAMOS FARIAS FERNANDO1/1/2016 1/1/2016 VENTAS FT 005-001 20362147596 RE ALOS S.A.1/1/2016 1/1/2016 VENTAS FT 005-002 10232514523 MARTINEZ RO$AS SOLEDAD

    1/15/2016 1/15/2016 VENTAS #V 001-3 0000 CLIENTES VARIOS1/15/2016 1/15/2016 VENTAS #V 001-3 0000 CLIENTES VARIOS1/21/2016 1/21/2016 VENTAS #V 001-4 0000 CLIENTES VARIOS1/21/2016 1/21/2016 VENTAS #V 001-5 0000 CLIENTES VARIOS1/21/2016 1/21/2016 VENTAS #V 001-6 0000 CLIENTES VARIOS1/23/2016 1/23/2016 VENTAS #V 001-7 0000 CLIENTES VARIOS1/23/2016 1/23/2016 VENTAS #V 001-8 0000 CLIENTES VARIOS1/25/2016 1/25/2016 VENTAS #V 001-9 0000 CLIENTES VARIOS1/26/2016 1/26/2016 VENTAS #V 001-10 0000 CLIENTES VARIOS1/27/2016 1/27/2016 VENTAS #V 001-11 0000 CLIENTES VARIOS

    (N/A(N/A

    (N/A(N/A(N/A(N/A(N/A(N/A(N/A(N/A(N/A(N/A(N/A(N/A

    (N/A(N/A(N/A(N/A(N/A(N/A(N/A(N/A(N/A(N/A(N/A(N/A

    (N/A(N/A(N/A(N/A(N/A(N/A(N/A(N/A

    'EC#ASALIDA

    'EC#ADOC

    TIPODOC

    NUMERODOC.

  • 8/15/2019 Kardex Valorado Con Macros - TodoDocumentos.info

    20/51

    (N/A(N/A(N/A(N/A(N/A(N/A(N/A(N/A(N/A(N/A(N/A(N/A(N/A(N/A(N/A(N/A(N/A(N/A

    (N/A(N/A(N/A(N/A(N/A(N/A(N/A(N/A(N/A(N/A(N/A(N/A

    (N/A(N/A(N/A(N/A(N/A(N/A(N/A(N/A(N/A(N/A(N/A(N/A

    (N/A(N/A(N/A(N/A(N/A(N/A(N/A(N/A

  • 8/15/2019 Kardex Valorado Con Macros - TodoDocumentos.info

    21/51

    (N/A(N/A(N/A(N/A(N/A(N/A(N/A(N/A(N/A(N/A(N/A(N/A(N/A(N/A(N/A(N/A(N/A(N/A

    (N/A(N/A(N/A(N/A(N/A(N/A(N/A(N/A(N/A(N/A(N/A(N/A

    (N/A(N/A(N/A(N/A(N/A(N/A(N/A(N/A(N/A(N/A(N/A(N/A

    (N/A(N/A(N/A(N/A(N/A(N/A(N/A(N/A

  • 8/15/2019 Kardex Valorado Con Macros - TodoDocumentos.info

    22/51

    (N/A(N/A(N/A(N/A(N/A(N/A(N/A(N/A(N/A(N/A(N/A(N/A(N/A(N/A(N/A(N/A(N/A(N/A

    (N/A(N/A(N/A(N/A(N/A(N/A(N/A(N/A(N/A(N/A(N/A(N/A

    (N/A(N/A(N/A(N/A(N/A(N/A(N/A(N/A(N/A(N/A(N/A(N/A

    (N/A(N/A

  • 8/15/2019 Kardex Valorado Con Macros - TodoDocumentos.info

    23/51

    ARTICULO DESCRIP. ARTICULO CANTIDAD

    ANULA ANULADO 0 UNI UNIDAD)ES* 0C00002 ACEITE COCINERO % 1 LI 5 UNI UNIDAD)ES* 5 MNC00002 ACEITE COCINERO % 1 LI 2 UNI UNIDAD)ES* 2 MNC00002 ACEITE COCINERO % 1 LI 2 UNI UNIDAD)ES* 2 MNC00001 ACEITE PRIMOR % 1 LITR 1 DOC DOCENA)S* 12 MNC00003 ACEITE CASERA % 1 LITR 3 UNI UNIDAD)ES* 3 MNC00005 ARROZ PAISANA % 5 ! 10 UNI UNIDAD)ES* 10 MNC00004 ARROZ PAISANA % 800 6 UNI UNIDAD)ES* 6 MNC00007 LEC&E LORIA LI &T % 1 1 DOC DOCENA)S* 12 MNC00008 LEC&E LORIA NI'OS % 1 30 UNI UNIDAD)ES* 30 MNC00002 ACEITE COCINERO % 1 LI 16 UNI UNIDAD)ES* 16 MNC00004 ARROZ PAISANA % 800 10 UNI UNIDAD)ES* 10 MNC00005 ARROZ PAISANA % 5 ! 5 UNI UNIDAD)ES* 5 MNC00002 ACEITE COCINERO % 1 LI 1 DOC DOCENA)S* 12 MN

    (N/A (N/A (N/A(N/A (N/A (N/A

    (N/A (N/A (N/A(N/A (N/A (N/A(N/A (N/A (N/A(N/A (N/A (N/A(N/A (N/A (N/A(N/A (N/A (N/A(N/A (N/A (N/A(N/A (N/A (N/A(N/A (N/A (N/A(N/A (N/A (N/A(N/A (N/A (N/A(N/A (N/A (N/A

    (N/A (N/A (N/A(N/A (N/A (N/A(N/A (N/A (N/A(N/A (N/A (N/A(N/A (N/A (N/A(N/A (N/A (N/A(N/A (N/A (N/A(N/A (N/A (N/A(N/A (N/A (N/A(N/A (N/A (N/A(N/A (N/A (N/A(N/A (N/A (N/A

    (N/A (N/A (N/A(N/A (N/A (N/A(N/A (N/A (N/A(N/A (N/A (N/A(N/A (N/A (N/A(N/A (N/A (N/A(N/A (N/A (N/A(N/A (N/A (N/A

    UNID.MEDIDA

    .UNID. CIA MONEDAUS " MN

  • 8/15/2019 Kardex Valorado Con Macros - TodoDocumentos.info

    24/51

    (N/A (N/A (N/A(N/A (N/A (N/A(N/A (N/A (N/A(N/A (N/A (N/A(N/A (N/A (N/A(N/A (N/A (N/A(N/A (N/A (N/A(N/A (N/A (N/A(N/A (N/A (N/A(N/A (N/A (N/A(N/A (N/A (N/A(N/A (N/A (N/A(N/A (N/A (N/A(N/A (N/A (N/A(N/A (N/A (N/A(N/A (N/A (N/A(N/A (N/A (N/A(N/A (N/A (N/A

    (N/A (N/A (N/A(N/A (N/A (N/A(N/A (N/A (N/A(N/A (N/A (N/A(N/A (N/A (N/A(N/A (N/A (N/A(N/A (N/A (N/A(N/A (N/A (N/A(N/A (N/A (N/A(N/A (N/A (N/A(N/A (N/A (N/A(N/A (N/A (N/A

    (N/A (N/A (N/A(N/A (N/A (N/A(N/A (N/A (N/A(N/A (N/A (N/A(N/A (N/A (N/A(N/A (N/A (N/A(N/A (N/A (N/A(N/A (N/A (N/A(N/A (N/A (N/A(N/A (N/A (N/A(N/A (N/A (N/A(N/A (N/A (N/A

    (N/A (N/A (N/A(N/A (N/A (N/A(N/A (N/A (N/A(N/A (N/A (N/A(N/A (N/A (N/A(N/A (N/A (N/A(N/A (N/A (N/A(N/A (N/A (N/A

  • 8/15/2019 Kardex Valorado Con Macros - TodoDocumentos.info

    25/51

    (N/A (N/A (N/A(N/A (N/A (N/A(N/A (N/A (N/A(N/A (N/A (N/A(N/A (N/A (N/A(N/A (N/A (N/A(N/A (N/A (N/A(N/A (N/A (N/A(N/A (N/A (N/A(N/A (N/A (N/A(N/A (N/A (N/A(N/A (N/A (N/A(N/A (N/A (N/A(N/A (N/A (N/A(N/A (N/A (N/A(N/A (N/A (N/A(N/A (N/A (N/A(N/A (N/A (N/A

    (N/A (N/A (N/A(N/A (N/A (N/A(N/A (N/A (N/A(N/A (N/A (N/A(N/A (N/A (N/A(N/A (N/A (N/A(N/A (N/A (N/A(N/A (N/A (N/A(N/A (N/A (N/A(N/A (N/A (N/A(N/A (N/A (N/A(N/A (N/A (N/A

    (N/A (N/A (N/A(N/A (N/A (N/A(N/A (N/A (N/A(N/A (N/A (N/A(N/A (N/A (N/A(N/A (N/A (N/A(N/A (N/A (N/A(N/A (N/A (N/A(N/A (N/A (N/A(N/A (N/A (N/A(N/A (N/A (N/A(N/A (N/A (N/A

    (N/A (N/A (N/A(N/A (N/A (N/A(N/A (N/A (N/A(N/A (N/A (N/A(N/A (N/A (N/A(N/A (N/A (N/A(N/A (N/A (N/A(N/A (N/A (N/A

  • 8/15/2019 Kardex Valorado Con Macros - TodoDocumentos.info

    26/51

    (N/A (N/A (N/A(N/A (N/A (N/A(N/A (N/A (N/A(N/A (N/A (N/A(N/A (N/A (N/A(N/A (N/A (N/A(N/A (N/A (N/A(N/A (N/A (N/A(N/A (N/A (N/A(N/A (N/A (N/A(N/A (N/A (N/A(N/A (N/A (N/A(N/A (N/A (N/A(N/A (N/A (N/A(N/A (N/A (N/A(N/A (N/A (N/A(N/A (N/A (N/A(N/A (N/A (N/A

    (N/A (N/A (N/A(N/A (N/A (N/A(N/A (N/A (N/A(N/A (N/A (N/A(N/A (N/A (N/A(N/A (N/A (N/A(N/A (N/A (N/A(N/A (N/A (N/A(N/A (N/A (N/A(N/A (N/A (N/A(N/A (N/A (N/A(N/A (N/A (N/A

    (N/A (N/A (N/A(N/A (N/A (N/A(N/A (N/A (N/A(N/A (N/A (N/A(N/A (N/A (N/A(N/A (N/A (N/A(N/A (N/A (N/A(N/A (N/A (N/A(N/A (N/A (N/A(N/A (N/A (N/A(N/A (N/A (N/A(N/A (N/A (N/A

    (N/A (N/A (N/A(N/A (N/A (N/A

  • 8/15/2019 Kardex Valorado Con Macros - TodoDocumentos.info

    27/51

    MONTO S" VV " PV " NG IGV

    - - - -10.00 10.00 PV 8.47 1.53 10.00

    4.00 4.00 PV 3.39 0.61 4.004.00 4.00 PV 3.39 0.61 4.00

    50.00 50.00 PV 42.37 7.63 50.0013.00 13.00 PV 11.02 1.98 13.0050.00 50.00 PV 42.37 7.63 50.0030.00 30.00 PV 25.42 4.58 30.0038.00 38.00 PV 32.20 5.80 38.00

    160.00 160.00 PV 135.59 24.41 160.0051.00 51.00 PV 43.22 7.78 51.0052.00 52.00 PV 44.07 7.93 52.0024.00 24.00 PV 20.34 3.66 24.0043.00 43.00 PV 36.44 6.56 43.00

    - - - -- - - -

    - - - -- - - -- - - -- - - -- - - -- - - -- - - -- - - -- - - -- - - -- - - -- - - -

    - - - -- - - -- - - -- - - -- - - -- - - -- - - -- - - -- - - -- - - -- - - -- - - -

    - - - -- - - -- - - -- - - -- - - -- - - -- - - -- - - -

    MONTOORIGINAL

    TIPO DECAMBIO

    VALOR DEVENTA

    PRECIODE VENTA

  • 8/15/2019 Kardex Valorado Con Macros - TodoDocumentos.info

    28/51

    - - - -- - - -- - - -- - - -- - - -- - - -- - - -- - - -- - - -- - - -- - - -- - - -- - - -- - - -- - - -- - - -- - - -- - - -

    - - - -- - - -- - - -- - - -- - - -- - - -- - - -- - - -- - - -- - - -- - - -- - - -

    - - - -- - - -- - - -- - - -- - - -- - - -- - - -- - - -- - - -- - - -- - - -- - - -

    - - - -- - - -- - - -- - - -- - - -- - - -- - - -- - - -

  • 8/15/2019 Kardex Valorado Con Macros - TodoDocumentos.info

    29/51

    - - - -- - - -- - - -- - - -- - - -- - - -- - - -- - - -- - - -- - - -- - - -- - - -- - - -- - - -- - - -- - - -- - - -- - - -

    - - - -- - - -- - - -- - - -- - - -- - - -- - - -- - - -- - - -- - - -- - - -- - - -

    - - - -- - - -- - - -- - - -- - - -- - - -- - - -- - - -- - - -- - - -- - - -- - - -

    - - - -- - - -- - - -- - - -- - - -- - - -- - - -- - - -

  • 8/15/2019 Kardex Valorado Con Macros - TodoDocumentos.info

    30/51

    - - - -- - - -- - - -- - - -- - - -- - - -- - - -- - - -- - - -- - - -- - - -- - - -- - - -- - - -- - - -- - - -- - - -- - - -

    - - - -- - - -- - - -- - - -- - - -- - - -- - - -- - - -- - - -- - - -- - - -- - - -

    - - - -- - - -- - - -- - - -- - - -- - - -- - - -- - - -- - - -- - - -- - - -- - - -

    - - - -- - - -

  • 8/15/2019 Kardex Valorado Con Macros - TodoDocumentos.info

    31/51

    DESCRIPCION ARTICULO DESCRIP. ARTICULO

    1/1/2016 INVENTARIO INICIAL VR INV-INIC C00001 ACEITE PRIMOR % 1 LITRO1/1/2016 INVENTARIO INICIAL VR INV-INIC C00002 ACEITE COCINERO % 1 LITRO1/1/2016 INVENTARIO INICIAL VR INV-INIC C00003 ACEITE CASERA % 1 LITRO1/1/2016 INVENTARIO INICIAL VR INV-INIC C00004 ARROZ PAISANA % 800 R1/1/2016 INVENTARIO INICIAL VR INV-INIC C00005 ARROZ PAISANA % 5 !1/1/2016 INVENTARIO INICIAL VR INV-INIC C00006 LEC&E LORIA CLASICA % 1651/1/2016 INVENTARIO INICIAL VR INV-INIC C00007 LEC&E LORIA LI &T % 1651/1/2016 INVENTARIO INICIAL VR INV-INIC C00008 LEC&E LORIA NI'OS % 165

    (N/A(N/A(N/A(N/A(N/A(N/A(N/A(N/A(N/A(N/A(N/A(N/A(N/A(N/A(N/A(N/A(N/A(N/A(N/A

    (N/A(N/A(N/A(N/A(N/A(N/A(N/A(N/A(N/A(N/A(N/A(N/A

    (N/A(N/A(N/A(N/A(N/A(N/A(N/A(N/A

    'EC#AINGRESO

    TIPODOC

    NUMERODOC.

  • 8/15/2019 Kardex Valorado Con Macros - TodoDocumentos.info

    32/51

    (N/A(N/A(N/A(N/A(N/A(N/A(N/A(N/A(N/A(N/A(N/A(N/A(N/A(N/A(N/A(N/A(N/A(N/A

    (N/A(N/A(N/A(N/A(N/A(N/A(N/A(N/A(N/A(N/A(N/A(N/A

    (N/A(N/A(N/A(N/A(N/A(N/A(N/A(N/A(N/A(N/A(N/A(N/A

    (N/A(N/A(N/A(N/A(N/A(N/A(N/A(N/A

  • 8/15/2019 Kardex Valorado Con Macros - TodoDocumentos.info

    33/51

    (N/A(N/A(N/A(N/A(N/A(N/A(N/A(N/A(N/A(N/A(N/A(N/A(N/A(N/A(N/A(N/A(N/A(N/A

    (N/A(N/A(N/A(N/A(N/A(N/A(N/A(N/A(N/A(N/A(N/A(N/A

    (N/A(N/A(N/A(N/A(N/A(N/A(N/A(N/A(N/A(N/A(N/A(N/A

    (N/A(N/A(N/A(N/A(N/A(N/A(N/A(N/A

  • 8/15/2019 Kardex Valorado Con Macros - TodoDocumentos.info

    34/51

    (N/A(N/A(N/A(N/A(N/A(N/A(N/A(N/A(N/A(N/A(N/A(N/A(N/A(N/A(N/A(N/A(N/A(N/A

    (N/A(N/A(N/A(N/A(N/A(N/A(N/A(N/A(N/A(N/A(N/A(N/A

    (N/A(N/A(N/A(N/A(N/A(N/A(N/A(N/A(N/A(N/A(N/A(N/A

    (N/A(N/A(N/A

  • 8/15/2019 Kardex Valorado Con Macros - TodoDocumentos.info

    35/51

    CANTIDAD

    15 C12 CA$A % 12 180 652.30500 C12 CA$A % 12 6000 1"955.30300 C12 CA$A % 12 3600 865.52

    50 DOC DOCENA)S* 600 2"001.5254 #OL #OLSA)S* 54 153.50

    150 C12 CA$A % 12 1800 3"650.00130 C12 CA$A % 12 1560 3"020.50150 C12 CA$A % 12 1800 5"000.50

    (N/A (N/A(N/A (N/A(N/A (N/A(N/A (N/A(N/A (N/A(N/A (N/A(N/A (N/A(N/A (N/A(N/A (N/A(N/A (N/A(N/A (N/A(N/A (N/A(N/A (N/A(N/A (N/A(N/A (N/A(N/A (N/A(N/A (N/A(N/A (N/A(N/A (N/A

    (N/A (N/A(N/A (N/A(N/A (N/A(N/A (N/A(N/A (N/A(N/A (N/A(N/A (N/A(N/A (N/A(N/A (N/A(N/A (N/A(N/A (N/A(N/A (N/A

    (N/A (N/A(N/A (N/A(N/A (N/A(N/A (N/A(N/A (N/A(N/A (N/A(N/A (N/A(N/A (N/A

    UNID.MEDIDA

    DESCRIP. UNID.MEDIDA

    E(UIVALENCIAUNITARIA

    COSTOTOTAL S"

  • 8/15/2019 Kardex Valorado Con Macros - TodoDocumentos.info

    36/51

    (N/A (N/A(N/A (N/A(N/A (N/A(N/A (N/A(N/A (N/A(N/A (N/A(N/A (N/A(N/A (N/A(N/A (N/A(N/A (N/A(N/A (N/A(N/A (N/A(N/A (N/A(N/A (N/A(N/A (N/A(N/A (N/A(N/A (N/A(N/A (N/A

    (N/A (N/A(N/A (N/A(N/A (N/A(N/A (N/A(N/A (N/A(N/A (N/A(N/A (N/A(N/A (N/A(N/A (N/A(N/A (N/A(N/A (N/A(N/A (N/A

    (N/A (N/A(N/A (N/A(N/A (N/A(N/A (N/A(N/A (N/A(N/A (N/A(N/A (N/A(N/A (N/A(N/A (N/A(N/A (N/A(N/A (N/A(N/A (N/A

    (N/A (N/A(N/A (N/A(N/A (N/A(N/A (N/A(N/A (N/A(N/A (N/A(N/A (N/A(N/A (N/A

  • 8/15/2019 Kardex Valorado Con Macros - TodoDocumentos.info

    37/51

    (N/A (N/A(N/A (N/A(N/A (N/A(N/A (N/A(N/A (N/A(N/A (N/A(N/A (N/A(N/A (N/A(N/A (N/A(N/A (N/A(N/A (N/A(N/A (N/A(N/A (N/A(N/A (N/A(N/A (N/A(N/A (N/A(N/A (N/A(N/A (N/A

    (N/A (N/A(N/A (N/A(N/A (N/A(N/A (N/A(N/A (N/A(N/A (N/A(N/A (N/A(N/A (N/A(N/A (N/A(N/A (N/A(N/A (N/A(N/A (N/A

    (N/A (N/A(N/A (N/A(N/A (N/A(N/A (N/A(N/A (N/A(N/A (N/A(N/A (N/A(N/A (N/A(N/A (N/A(N/A (N/A(N/A (N/A(N/A (N/A

    (N/A (N/A(N/A (N/A(N/A (N/A(N/A (N/A(N/A (N/A(N/A (N/A(N/A (N/A(N/A (N/A

  • 8/15/2019 Kardex Valorado Con Macros - TodoDocumentos.info

    38/51

    (N/A (N/A(N/A (N/A(N/A (N/A(N/A (N/A(N/A (N/A(N/A (N/A(N/A (N/A(N/A (N/A(N/A (N/A(N/A (N/A(N/A (N/A(N/A (N/A(N/A (N/A(N/A (N/A(N/A (N/A(N/A (N/A(N/A (N/A(N/A (N/A

    (N/A (N/A(N/A (N/A(N/A (N/A(N/A (N/A(N/A (N/A(N/A (N/A(N/A (N/A(N/A (N/A(N/A (N/A(N/A (N/A(N/A (N/A(N/A (N/A

    (N/A (N/A(N/A (N/A(N/A (N/A(N/A (N/A(N/A (N/A(N/A (N/A(N/A (N/A(N/A (N/A(N/A (N/A(N/A (N/A(N/A (N/A(N/A (N/A

    (N/A (N/A(N/A (N/A(N/A (N/A

  • 8/15/2019 Kardex Valorado Con Macros - TodoDocumentos.info

    39/51

    DESCRIPCION ARTICULO DESCRIP. ARTICULO CANTIDAD

    1/31/2016 FALTANTE VR 0001 C00001 ACEITE PRIMOR % 1 LITR 5 DOC1/31/2016 FALTANTE VR 0001 C00002 ACEITE COCINERO % 1 LI 16 UNI1/31/2016 FALTANTE VR 0001 C00001 ACEITE PRIMOR % 1 LITR 2 UNI

    (N/A(N/A(N/A(N/A(N/A(N/A(N/A(N/A(N/A(N/A(N/A(N/A(N/A(N/A(N/A(N/A(N/A(N/A(N/A(N/A(N/A(N/A(N/A(N/A

    (N/A(N/A(N/A(N/A(N/A(N/A(N/A(N/A(N/A(N/A(N/A(N/A

    (N/A(N/A(N/A(N/A(N/A(N/A(N/A(N/A

    'EC#ASALIDA

    TIPODOC

    NUMERODOC.

    UNID.MEDIDA

  • 8/15/2019 Kardex Valorado Con Macros - TodoDocumentos.info

    40/51

    (N/A(N/A(N/A(N/A(N/A(N/A(N/A(N/A(N/A(N/A(N/A(N/A(N/A(N/A(N/A(N/A(N/A(N/A

    (N/A(N/A(N/A(N/A(N/A(N/A(N/A(N/A(N/A(N/A(N/A(N/A

    (N/A(N/A(N/A(N/A(N/A(N/A(N/A(N/A(N/A(N/A(N/A(N/A

    (N/A(N/A(N/A(N/A(N/A(N/A(N/A(N/A

  • 8/15/2019 Kardex Valorado Con Macros - TodoDocumentos.info

    41/51

    (N/A(N/A(N/A(N/A(N/A(N/A(N/A(N/A(N/A(N/A(N/A(N/A(N/A(N/A(N/A(N/A(N/A(N/A

    (N/A(N/A(N/A(N/A(N/A(N/A(N/A(N/A(N/A(N/A(N/A(N/A

    (N/A(N/A(N/A(N/A(N/A(N/A(N/A(N/A(N/A(N/A(N/A(N/A

    (N/A(N/A(N/A(N/A(N/A(N/A(N/A(N/A

  • 8/15/2019 Kardex Valorado Con Macros - TodoDocumentos.info

    42/51

    (N/A(N/A(N/A(N/A(N/A(N/A(N/A(N/A(N/A(N/A(N/A(N/A(N/A(N/A(N/A(N/A(N/A(N/A

    (N/A(N/A(N/A(N/A(N/A(N/A(N/A(N/A(N/A(N/A(N/A(N/A

    (N/A(N/A(N/A(N/A(N/A(N/A(N/A(N/A(N/A(N/A(N/A(N/A

    (N/A(N/A(N/A

  • 8/15/2019 Kardex Valorado Con Macros - TodoDocumentos.info

    43/51

    DOCENA)S* 60UNIDAD)ES* 16UNIDAD)ES* 2

    (N/A (N/A(N/A (N/A(N/A (N/A(N/A (N/A(N/A (N/A(N/A (N/A(N/A (N/A(N/A (N/A(N/A (N/A(N/A (N/A(N/A (N/A(N/A (N/A(N/A (N/A(N/A (N/A(N/A (N/A(N/A (N/A(N/A (N/A(N/A (N/A(N/A (N/A(N/A (N/A(N/A (N/A(N/A (N/A(N/A (N/A(N/A (N/A

    (N/A (N/A(N/A (N/A(N/A (N/A(N/A (N/A(N/A (N/A(N/A (N/A(N/A (N/A(N/A (N/A(N/A (N/A(N/A (N/A(N/A (N/A(N/A (N/A

    (N/A (N/A(N/A (N/A(N/A (N/A(N/A (N/A(N/A (N/A(N/A (N/A(N/A (N/A(N/A (N/A

    DESCRIP. UNID.MEDIDA

    E(UIVALENCIAUNITARIA

  • 8/15/2019 Kardex Valorado Con Macros - TodoDocumentos.info

    44/51

    (N/A (N/A(N/A (N/A(N/A (N/A(N/A (N/A(N/A (N/A(N/A (N/A(N/A (N/A(N/A (N/A(N/A (N/A(N/A (N/A(N/A (N/A(N/A (N/A(N/A (N/A(N/A (N/A(N/A (N/A(N/A (N/A(N/A (N/A(N/A (N/A

    (N/A (N/A(N/A (N/A(N/A (N/A(N/A (N/A(N/A (N/A(N/A (N/A(N/A (N/A(N/A (N/A(N/A (N/A(N/A (N/A(N/A (N/A(N/A (N/A

    (N/A (N/A(N/A (N/A(N/A (N/A(N/A (N/A(N/A (N/A(N/A (N/A(N/A (N/A(N/A (N/A(N/A (N/A(N/A (N/A(N/A (N/A(N/A (N/A

    (N/A (N/A(N/A (N/A(N/A (N/A(N/A (N/A(N/A (N/A(N/A (N/A(N/A (N/A(N/A (N/A

  • 8/15/2019 Kardex Valorado Con Macros - TodoDocumentos.info

    45/51

    (N/A (N/A(N/A (N/A(N/A (N/A(N/A (N/A(N/A (N/A(N/A (N/A(N/A (N/A(N/A (N/A(N/A (N/A(N/A (N/A(N/A (N/A(N/A (N/A(N/A (N/A(N/A (N/A(N/A (N/A(N/A (N/A(N/A (N/A(N/A (N/A

    (N/A (N/A(N/A (N/A(N/A (N/A(N/A (N/A(N/A (N/A(N/A (N/A(N/A (N/A(N/A (N/A(N/A (N/A(N/A (N/A(N/A (N/A(N/A (N/A

    (N/A (N/A(N/A (N/A(N/A (N/A(N/A (N/A(N/A (N/A(N/A (N/A(N/A (N/A(N/A (N/A(N/A (N/A(N/A (N/A(N/A (N/A(N/A (N/A

    (N/A (N/A(N/A (N/A(N/A (N/A(N/A (N/A(N/A (N/A(N/A (N/A(N/A (N/A(N/A (N/A

  • 8/15/2019 Kardex Valorado Con Macros - TodoDocumentos.info

    46/51

    (N/A (N/A(N/A (N/A(N/A (N/A(N/A (N/A(N/A (N/A(N/A (N/A(N/A (N/A(N/A (N/A(N/A (N/A(N/A (N/A(N/A (N/A(N/A (N/A(N/A (N/A(N/A (N/A(N/A (N/A(N/A (N/A(N/A (N/A(N/A (N/A

    (N/A (N/A(N/A (N/A(N/A (N/A(N/A (N/A(N/A (N/A(N/A (N/A(N/A (N/A(N/A (N/A(N/A (N/A(N/A (N/A(N/A (N/A(N/A (N/A

    (N/A (N/A(N/A (N/A(N/A (N/A(N/A (N/A(N/A (N/A(N/A (N/A(N/A (N/A(N/A (N/A(N/A (N/A(N/A (N/A(N/A (N/A(N/A (N/A

    (N/A (N/A(N/A (N/A(N/A (N/A

  • 8/15/2019 Kardex Valorado Con Macros - TodoDocumentos.info

    47/51

    CODIGO DESCRIPCION

    TO ASTOS VARIOS 0DOC DOCENA)S* 12UNI UNIDAD)ES* 1#AR #ARRIL)ES* 50LIT LITRO)S* 1#OT #OTELLA)S* 1C12 CA$A % 12 12C06 CA$A % 6 6#OL #OLSA)S* 1LAT LATA)S* 1

    E(UIVALENCIA UNIDADMEDIDA

  • 8/15/2019 Kardex Valorado Con Macros - TodoDocumentos.info

    48/51

    CODIGO DESCRIPCION

    ANULA ANULADO TO N/AASTO ASTOS VARIOS TO N/AC00001 ACEITE PRIMOR % 1 LITRO #OT #OTELLA)S*C00002 ACEITE COCINERO % 1 LITRO #OT #OTELLA)S*C00003 ACEITE CASERA % 1 LITRO #OT #OTELLA)S*C00004 ARROZ PAISANA % 800 R #OL #OLSA)S*C00005 ARROZ PAISANA % 5 ! #OL #OLSA)S*C00006 LEC&E LORIA CLASICA % 165 LAT LATA)S*C00007 LEC&E LORIA LI &T % 165 LAT LATA)S*C00008 LEC&E LORIA NI'OS % 165 LAT LATA)S*

    UNIDADDE

    MEDIDADESCRIPCION

    UNIDAD DE MEDIDA

  • 8/15/2019 Kardex Valorado Con Macros - TodoDocumentos.info

    49/51

    COD. PROVEEDOR NOMBRE PROVEEDOR20115236447 CAR#A$AR EIRL10007555232 MARTINEZ OSORIO SUSAN20532277320 RA ANRO! INVERSIONES EIRL20356912031 REPRESENTACIONES SOLEDAD S.A.C.20859614736 CARDINAL S.A.

  • 8/15/2019 Kardex Valorado Con Macros - TodoDocumentos.info

    50/51

    COD. CLIENTE NOMBRE CLIENTE0000 CLIENTES VARIOS0001 ANULADO20362147596 RE ALOS S.A.10232514523 MARTINEZ RO$AS SOLEDAD15336422 RAMOS FARIAS FERNANDO

  • 8/15/2019 Kardex Valorado Con Macros - TodoDocumentos.info

    51/51

    'EC#A CAMBIO COMPRA CAMBIO VENTA1/1/2016 3.408 3.4131/2/2016 3.408 3.4131/3/2016 3.408 3.4131/4/2016 3.408 3.4131/5/2016 3.426 3.431/6/2016 3.415 3.4171/7/2016 3.415 3.4171/8/2016 3.42 3.4231/9/2016 3.425 3.428

    1/10/2016 3.425 3.4281/11/2016 3.425 3.4281/12/2016 3.424 3.4281/13/2016 3.423 3.4261/14/2016 3.42 3.4211/15/2016 3.422 3.4251/16/2016 3.428 3.431/17/2016 3.428 3.43

    1/18/2016 3.428 3.431/19/2016 3.426 3.4311/20/2016 3.43 3.4331/21/2016 3.441 3.4421/22/2016 3.445 3.4461/23/2016 3.443 3.4471/24/2016 3.443 3.4471/25/2016 3.443 3.4471/26/2016 3.454 3.4581/27/2016 3.465 3.4691/28/2016 3.463 3.4661/29/2016 3.463 3.469

    1/30/2016 3.468 3.4711/31/2016 3.468 3.471

    2/1/2016