{"id":2559,"date":"2014-10-30T13:42:24","date_gmt":"2014-10-30T16:42:24","guid":{"rendered":"https:\/\/alfagestion.com.ar\/faq\/?p=2559"},"modified":"2014-12-08T13:33:22","modified_gmt":"2014-12-08T16:33:22","slug":"disenador-de-consultas","status":"publish","type":"post","link":"https:\/\/www.alfagestion.com.ar\/ag\/disenador-de-consultas\/","title":{"rendered":"Dise\u00f1ador de consultas"},"content":{"rendered":"<h2>Objetivo:<\/h2>\n<p>Analizar las compras en un periodo de fechas.<!--more--><\/p>\n<p><span style=\"text-decoration: underline;\">Esta consulta devuelve las siguientes columnas<br \/>\n<\/span><\/p>\n<p><span style=\"color: #5b9bd5;\">IDARTICULO <\/span>(C\u00f3digo del producto, tenga o no movimientos en el periodo solicitado)<\/p>\n<p><span style=\"color: #5b9bd5;\">DESCRIPCION<\/span>: (Descripci\u00f3n del producto)<\/p>\n<p><span style=\"color: #5b9bd5;\">COMPRAS<\/span>: (Cantidad compradas en el periodo indicado, suma las cantidades sin tener en cuenta las unidades de medida)<\/p>\n<p><span style=\"color: #5b9bd5;\">FHULTIMOCOSTO<\/span>: (Fecha en que se cambi\u00f3 por \u00faltima vez el costo del producto, esta puede estar fuera del rango de fechas solicitadas)<\/p>\n<p><span style=\"color: #5b9bd5;\">PROVEEDOR<\/span>: (Nombre del proveedor)<\/p>\n<p>&nbsp;<\/p>\n<ul>\n<li>Puede copiar la siguiente consulta dentro del Dise\u00f1ador de consultas de Alfa y comenzar a utilizarlo.<\/li>\n<\/ul>\n<p><span style=\"font-family: Courier New; font-size: 10pt;\"><span style=\"color: blue;\">SELECT<\/span><br \/>\n<span style=\"color: teal;\">IDARTICULO<span style=\"color: gray;\">,<\/span> DESCRIPCION<span style=\"color: gray;\">,<\/span><br \/>\n<span style=\"color: fuchsia;\">ISNULL<span style=\"color: gray;\">(<span style=\"color: fuchsia;\">SUM<span style=\"color: gray;\">(<span style=\"color: teal;\">CANTIDAD<span style=\"color: gray;\">),<\/span>0<span style=\"color: gray;\">)<\/span><br \/>\n<span style=\"color: blue;\">as<\/span> COMPRAS<span style=\"color: gray;\">,<span style=\"color: teal;\">FhUltimoCosto<span style=\"color: gray;\">,<\/span> RAZON_SOCIAL<\/span><br \/>\n<span style=\"color: blue;\">AS<\/span><br \/>\n<span style=\"color: teal;\">PROVEEDOR<\/span><br \/>\n<span style=\"color: blue;\">FROM<br \/>\n<\/span><\/span><\/span><\/span><\/span><\/span><\/span><\/span><\/span><\/p>\n<p><span style=\"color: gray; font-family: Courier New; font-size: 10pt;\">(<br \/>\n<\/span><\/p>\n<p><span style=\"font-family: Courier New; font-size: 10pt;\"><span style=\"color: blue;\">SELECT<\/span><br \/>\n<span style=\"color: fuchsia;\">LTRIM<span style=\"color: gray;\">(<span style=\"color: teal;\">A<span style=\"color: gray;\">.<span style=\"color: teal;\">IDARTICULO<span style=\"color: gray;\">)<\/span><br \/>\n<span style=\"color: blue;\">AS<\/span> IDARTICULO<span style=\"color: gray;\">,<\/span> A<span style=\"color: gray;\">.<span style=\"color: teal;\">DESCRIPCION<span style=\"color: gray;\">,<\/span><br \/>\n<span style=\"color: blue;\">CASE<\/span><br \/>\n<span style=\"color: blue;\">WHEN<\/span> TC<\/span> =<\/span><br \/>\n<span style=\"color: red;\">&#8216;NCC&#8217;<\/span><br \/>\n<span style=\"color: blue;\">THEN<\/span><br \/>\n<span style=\"color: fuchsia;\">SUM<span style=\"color: gray;\">(<span style=\"color: teal;\">CANTIDAD<span style=\"color: gray;\">)<\/span><br \/>\n<span style=\"color: gray;\">*<\/span><br \/>\n<span style=\"color: gray;\">&#8211;<\/span>1 <span style=\"color: blue;\">ELSE<\/span><br \/>\n<span style=\"color: fuchsia;\">SUM<span style=\"color: gray;\">(<span style=\"color: teal;\">CANTIDAD<span style=\"color: gray;\">)<\/span><br \/>\n<span style=\"color: blue;\">END<\/span><br \/>\n<span style=\"color: blue;\">AS<\/span> CANTIDAD<\/span> ,<\/span><br \/>\n<\/span><\/span><\/span><\/span><\/span><\/span><\/span><\/span><\/span><\/span><\/p>\n<p><span style=\"color: teal; font-family: Courier New; font-size: 10pt;\">B<span style=\"color: gray;\">.<span style=\"color: teal;\">TC<span style=\"color: gray;\">,<\/span> C<span style=\"color: gray;\">.<span style=\"color: teal;\">RAZON_SOCIAL<span style=\"color: gray;\">,<\/span> A<span style=\"color: gray;\">.<span style=\"color: teal;\">FhUltimoCosto<\/span><br \/>\n<span style=\"color: blue;\">FROM<\/span><br \/>\n<span style=\"color: teal;\">V_MA_ARTICULOS<\/span><br \/>\n<span style=\"color: teal;\">A<br \/>\n<\/span><\/span><\/span><\/span><\/span><\/span><\/span><\/p>\n<p><span style=\"font-family: Courier New; font-size: 10pt;\"><span style=\"color: gray;\">LEFT<\/span><br \/>\n<span style=\"color: gray;\">OUTER<\/span><br \/>\n<span style=\"color: gray;\">JOIN<\/span><br \/>\n<span style=\"color: teal;\">V_MV_STOCK<\/span><br \/>\n<span style=\"color: teal;\">B<\/span><br \/>\n<span style=\"color: blue;\">ON<\/span><br \/>\n<span style=\"color: teal;\">A<span style=\"color: gray;\">.<span style=\"color: teal;\">IDARTICULO<\/span> =<\/span> B<span style=\"color: gray;\">.<span style=\"color: teal;\">IDArticulo<\/span><br \/>\n<\/span><\/span><\/span><\/p>\n<p><span style=\"font-family: Courier New; font-size: 10pt;\"><span style=\"color: gray;\">LEFT<\/span><br \/>\n<span style=\"color: gray;\">OUTER<\/span><br \/>\n<span style=\"color: gray;\">JOIN<\/span><br \/>\n<span style=\"color: teal;\">Vt_Proveedores<\/span><br \/>\n<span style=\"color: teal;\">C<\/span><br \/>\n<span style=\"color: blue;\">ON<\/span><br \/>\n<span style=\"color: teal;\">A<span style=\"color: gray;\">.<span style=\"color: teal;\">CUENTAPROVEEDOR<\/span> =<\/span> C<span style=\"color: gray;\">.<span style=\"color: teal;\">CODIGO<\/span><br \/>\n<\/span><\/span><\/span><\/p>\n<p><span style=\"color: blue; font-family: Courier New; font-size: 10pt;\">WHERE <span style=\"color: gray;\">((<span style=\"color: teal;\">B<span style=\"color: gray;\">.<span style=\"color: teal;\">FECHA<\/span> &gt;=<\/span><br \/>\n<span style=\"color: red;\">&#8217;01\/05\/2014&#8242;<\/span><br \/>\n<span style=\"color: gray;\">AND<\/span> B<span style=\"color: gray;\">.<span style=\"color: teal;\">FECHA<\/span> &lt;=<\/span><br \/>\n<span style=\"color: red;\">&#8217;31\/05\/2014&#8242;<span style=\"color: gray;\">)<\/span><br \/>\n<span style=\"color: gray;\">OR<\/span><br \/>\n<span style=\"color: teal;\">B<span style=\"color: gray;\">.<span style=\"color: teal;\">FECHA<\/span> IS<\/span><br \/>\n<span style=\"color: gray;\">NULL)<br \/>\n<\/span><\/span><\/span><\/span><\/span><\/span><\/p>\n<p><span style=\"font-family: Courier New; font-size: 10pt;\"><span style=\"color: gray;\">AND<\/span><br \/>\n<\/span><\/p>\n<p><span style=\"color: gray; font-family: Courier New; font-size: 10pt;\">((<span style=\"color: teal;\">B<span style=\"color: gray;\">.<span style=\"color: teal;\">TC<\/span> =<\/span><br \/>\n<span style=\"color: red;\">&#8216;FCC&#8217;<\/span><br \/>\n<span style=\"color: gray;\">OR<\/span> B<span style=\"color: gray;\">.<span style=\"color: teal;\">TC<\/span> =<\/span><br \/>\n<span style=\"color: red;\">&#8216;NDC&#8217;<\/span><br \/>\n<span style=\"color: gray;\">OR<\/span> B<span style=\"color: gray;\">.<span style=\"color: teal;\">TC<\/span> =<\/span><br \/>\n<span style=\"color: red;\">&#8216;NCC&#8217;<span style=\"color: gray;\">)<\/span><br \/>\n<span style=\"color: gray;\">OR<\/span><br \/>\n<span style=\"color: teal;\">B<span style=\"color: gray;\">.<span style=\"color: teal;\">TC<\/span> IS<\/span><br \/>\n<span style=\"color: gray;\">NULL)<br \/>\n<\/span><\/span><\/span><\/span><\/span><\/p>\n<p><span style=\"font-family: Courier New; font-size: 10pt;\"><span style=\"color: blue;\">GROUP<\/span><br \/>\n<span style=\"color: blue;\">BY<\/span><br \/>\n<span style=\"color: teal;\">A<span style=\"color: gray;\">.<span style=\"color: teal;\">IDARTICULO<span style=\"color: gray;\">,<\/span> A<span style=\"color: gray;\">.<span style=\"color: teal;\">DESCRIPCION<\/span> ,<\/span> B<span style=\"color: gray;\">.<span style=\"color: teal;\">TC<span style=\"color: gray;\">,<\/span> C<span style=\"color: gray;\">.<span style=\"color: teal;\">RAZON_SOCIAL<span style=\"color: gray;\">,<\/span> A<span style=\"color: gray;\">.<span style=\"color: teal;\">FhUltimoCosto<\/span> )<\/span><br \/>\n<\/span><\/span><\/span><\/span><\/span><\/span><\/span><\/span><\/p>\n<p><span style=\"color: teal; font-family: Courier New; font-size: 10pt;\">Z<br \/>\n<\/span><\/p>\n<p><span style=\"font-family: Courier New; font-size: 10pt;\"><span style=\"color: blue;\">GROUP<\/span><br \/>\n<span style=\"color: blue;\">BY<\/span><br \/>\n<span style=\"color: teal;\">IDARTICULO<span style=\"color: gray;\">,<\/span> DESCRIPCION<span style=\"color: gray;\">,<\/span> RAZON_SOCIAL<span style=\"color: gray;\">,<span style=\"color: teal;\">FhUltimoCosto<br \/>\n<\/span><\/span><\/span><\/span><\/p>\n<p><span style=\"font-family: Courier New; font-size: 10pt;\"><span style=\"color: blue;\">ORDER<\/span><br \/>\n<span style=\"color: blue;\">BY<\/span><br \/>\n<span style=\"color: teal;\">IDARTICULO<span style=\"color: gray;\">,<\/span> DESCRIPCION<span style=\"color: gray;\">,<\/span> RAZON_SOCIAL<br \/>\n<\/span><\/span><\/p>\n<p><span style=\"color: teal; font-family: Courier New; font-size: 10pt;\"><br \/>\n<\/span><\/p>\n<div class=\"sharedaddy sd-sharing-enabled\"><div class=\"robots-nocontent sd-block sd-social sd-social-icon-text sd-sharing\"><h3 class=\"sd-title\">Compartir:<\/h3><div class=\"sd-content\"><ul><li class=\"share-email\"><a rel=\"nofollow noopener noreferrer\" data-shared=\"\" class=\"share-email sd-button share-icon\" href=\"https:\/\/www.alfagestion.com.ar\/ag\/disenador-de-consultas\/?share=email\" target=\"_blank\" title=\"Haz clic para enviar por correo electr\u00f3nico a un amigo\"><span>Correo electr\u00f3nico<\/span><\/a><\/li><li class=\"share-print\"><a rel=\"nofollow noopener noreferrer\" data-shared=\"\" class=\"share-print sd-button share-icon\" href=\"https:\/\/www.alfagestion.com.ar\/ag\/disenador-de-consultas\/\" target=\"_blank\" title=\"Haz clic para imprimir\"><span>Imprimir<\/span><\/a><\/li><li class=\"share-end\"><\/li><\/ul><\/div><\/div><\/div>","protected":false},"excerpt":{"rendered":"<p>Objetivo: Analizar las compras en un periodo de fechas.<\/p>\n<div class=\"sharedaddy sd-sharing-enabled\"><div class=\"robots-nocontent sd-block sd-social sd-social-icon-text sd-sharing\"><h3 class=\"sd-title\">Compartir:<\/h3><div class=\"sd-content\"><ul><li class=\"share-email\"><a rel=\"nofollow noopener noreferrer\" data-shared=\"\" class=\"share-email sd-button share-icon\" href=\"https:\/\/www.alfagestion.com.ar\/ag\/disenador-de-consultas\/?share=email\" target=\"_blank\" title=\"Haz clic para enviar por correo electr\u00f3nico a un amigo\"><span>Correo electr\u00f3nico<\/span><\/a><\/li><li class=\"share-print\"><a rel=\"nofollow noopener noreferrer\" data-shared=\"\" class=\"share-print sd-button share-icon\" href=\"https:\/\/www.alfagestion.com.ar\/ag\/disenador-de-consultas\/\" target=\"_blank\" title=\"Haz clic para imprimir\"><span>Imprimir<\/span><\/a><\/li><li class=\"share-end\"><\/li><\/ul><\/div><\/div><\/div>","protected":false},"author":5,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"advanced_seo_description":"","spay_email":"","footnotes":"","jetpack_publicize_message":"","jetpack_is_tweetstorm":false,"jetpack_publicize_feature_enabled":true},"categories":[1],"tags":[],"class_list":["post-2559","post","type-post","status-publish","format-standard","hentry","category-faq"],"jetpack_featured_media_url":"","jetpack_publicize_connections":[],"jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/p9eJDz-Fh","jetpack_likes_enabled":true,"jetpack-related-posts":[{"id":1665,"url":"https:\/\/www.alfagestion.com.ar\/ag\/como-cambiar-la-configuracion-de-la-consulta-de-articulos\/","url_meta":{"origin":2559,"position":0},"title":"Como cambiar la configuraci\u00f3n de la Consulta de Art\u00edculos?","date":"18 noviembre 2013","format":false,"excerpt":"Desde el Men\u00fa Utilidades, Configuraci\u00f3n de Consultas, Seleccionar Art\u00edculos y seleccione los campos que desea ver. En la siguiente pantalla se seleccionaron los Campos Descripci\u00f3n, IdArticulo y Precio. Se puede solicitar una Vista Previa de como se ver\u00e1 la consulta. Adem\u00e1s, podr\u00e1 cambiar el ancho de las columnas. Finalmente hacer\u2026","rel":"","context":"En \u00abAlfa Gesti\u00f3n Comercial\u00bb","img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":10611,"url":"https:\/\/www.alfagestion.com.ar\/ag\/alfa-geston-implementacion-rapida\/","url_meta":{"origin":2559,"position":1},"title":"Alfa Gest\u00f3n &#8211; Implementaci\u00f3n R\u00e1pida","date":"24 septiembre 2025","format":false,"excerpt":"Alfa Gesti\u00f3n Comercial \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 Alfa Gesti\u00f3n Comercial, forma parte de la familia de productos\u2026. WhatsApp +54 9 11 5148-0148 E-Mail: info@alfagestion.com.ar \u00a0 GUIA RAPIDA DE IMPLEMENTACION \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 Contenido Implementaci\u00f3n R\u00e1pida. 4 Instalaci\u00f3n del Sistema. 5 Operaci\u00f3n General del Sistema.\u2026","rel":"","context":"En \u00abAlfa Gesti\u00f3n Comercial\u00bb","img":{"alt_text":"","src":"https:\/\/i0.wp.com\/www.alfagestion.com.ar\/ag\/wp-content\/uploads\/2022\/07\/logo-alfanet-azul1.png?fit=1200%2C800&ssl=1&resize=350%2C200","width":350,"height":200},"classes":[]},{"id":8424,"url":"https:\/\/www.alfagestion.com.ar\/ag\/recomendaciones-para-mantener-seguro-sus-datos\/","url_meta":{"origin":2559,"position":2},"title":"Recomendaciones para mantener seguro sus datos","date":"4 agosto 2021","format":false,"excerpt":"Para mantener seguro sus datos y que no sean modificados o borrados por error u omisi\u00f3n, le recomendamos seguir los siguientes pasos: Fechas de cierre Desde el men\u00fa utilidades, fechas de cierre, el sistema posee una serie de trabas para evitar que los usuarios puedan modificar datos fuera del rango\u2026","rel":"","context":"En \u00abAlfa Gesti\u00f3n Comercial\u00bb","img":{"alt_text":"","src":"https:\/\/i0.wp.com\/www.alfagestion.com.ar\/ag\/wp-content\/uploads\/2016\/10\/Question.jpg?fit=320%2C400&ssl=1&resize=350%2C200","width":350,"height":200},"classes":[]},{"id":9633,"url":"https:\/\/www.alfagestion.com.ar\/ag\/cargar-rapida-de-factura-de-compras\/","url_meta":{"origin":2559,"position":3},"title":"Cargar rapida de factura de compra","date":"10 abril 2023","format":false,"excerpt":"En este ejemplo, mostramos como cargar una factura de compra, sin detallar productos, esto se puede utilizar para carga de gastos o servicios donde no necesitamos llevar un control de stock. REGISTACION DEL COMPROBANTE AL SISTEMA DE GESTION Entramos al sistema ALFA, men\u00fa Compras, Carga de comprobantes, Cargar facturas de\u2026","rel":"","context":"En \u00abAlfa Gesti\u00f3n Comercial\u00bb","img":{"alt_text":"","src":"https:\/\/i0.wp.com\/www.alfagestion.com.ar\/ag\/wp-content\/uploads\/2023\/04\/image-2.png?resize=350%2C200&ssl=1","width":350,"height":200},"classes":[]},{"id":7089,"url":"https:\/\/www.alfagestion.com.ar\/ag\/carga-de-comprobantes-v-10-2020\/","url_meta":{"origin":2559,"position":4},"title":"Carga de Comprobantes V10 \/ 2020","date":"4 diciembre 2019","format":false,"excerpt":"Algunas de las novedades en Carga de Comprobantes de Ventas, versi\u00f3n 10 \/ 2020 . Nueva interfaz gr\u00e1fica, estilo moderno Logo en pantalla Ancho de columnas configurable por usuario Nueva opci\u00f3n con Informaci\u00f3n adicional del producto. Aqu\u00ed podr\u00e1 ver: Imagen (Cargada desde el maestro de art\u00edculos) el sistema administra autom\u00e1ticamente\u2026","rel":"","context":"En \u00abNewsLetter\u00bb","img":{"alt_text":"","src":"https:\/\/i0.wp.com\/www.alfagestion.com.ar\/ag\/wp-content\/uploads\/2019\/12\/LOGO-2020-c.png?fit=808%2C837&ssl=1&resize=350%2C200","width":350,"height":200},"classes":[]},{"id":9522,"url":"https:\/\/www.alfagestion.com.ar\/ag\/carga-de-comprobantes-de-compras-por-gastos-y-servicios\/","url_meta":{"origin":2559,"position":5},"title":"Carga de comprobantes de compras, por gastos y  servicios","date":"17 noviembre 2022","format":false,"excerpt":"AL RECIBIR UNA FACTURA DE COMPRAS Cada vez que ingresa una factura de compras, puede ser por compras al supermercado, compras de mercader\u00eda de uso interno, por servicios. REGISTACION DEL COMPROBANTE AL SISTEMA DE GESTION Entramos al sistema ALFA, men\u00fa Compras, Carga de comprobantes, Cargar facturas de compras Vamos a\u2026","rel":"","context":"En \u00abAlfa Gesti\u00f3n Comercial\u00bb","img":{"alt_text":"","src":"https:\/\/i0.wp.com\/www.alfagestion.com.ar\/ag\/wp-content\/uploads\/2016\/10\/Question.jpg?fit=320%2C400&ssl=1&resize=350%2C200","width":350,"height":200},"classes":[]}],"_links":{"self":[{"href":"https:\/\/www.alfagestion.com.ar\/ag\/wp-json\/wp\/v2\/posts\/2559","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.alfagestion.com.ar\/ag\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.alfagestion.com.ar\/ag\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.alfagestion.com.ar\/ag\/wp-json\/wp\/v2\/users\/5"}],"replies":[{"embeddable":true,"href":"https:\/\/www.alfagestion.com.ar\/ag\/wp-json\/wp\/v2\/comments?post=2559"}],"version-history":[{"count":2,"href":"https:\/\/www.alfagestion.com.ar\/ag\/wp-json\/wp\/v2\/posts\/2559\/revisions"}],"predecessor-version":[{"id":2633,"href":"https:\/\/www.alfagestion.com.ar\/ag\/wp-json\/wp\/v2\/posts\/2559\/revisions\/2633"}],"wp:attachment":[{"href":"https:\/\/www.alfagestion.com.ar\/ag\/wp-json\/wp\/v2\/media?parent=2559"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.alfagestion.com.ar\/ag\/wp-json\/wp\/v2\/categories?post=2559"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.alfagestion.com.ar\/ag\/wp-json\/wp\/v2\/tags?post=2559"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}