{"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":7428,"url":"https:\/\/www.alfagestion.com.ar\/ag\/enviar-tabla-nutricional-a-balanza-kretz\/","url_meta":{"origin":2559,"position":1},"title":"Enviar tabla nutricional a balanza Kretz","date":"3 enero 2020","format":false,"excerpt":"La tabla nutricional, se carga en el campo observaciones del Sistema Alfa, para importarlo al software Itegra, debe cargar la siguiente consulta SQL en la opci\u00f3n \"Importar\", desde base de datos. \u00a0 SELECT\u00a0LTRIM(IDARTICULO)\u00a0AS IDARTICULO,DBO.FN_EXTRAERENGLON(1,OBSERVACIONES) AS OBS,'1'\u00a0AS RENG FROM V_MA_ARTICULOS WHERE PESABLE = 1 UNION SELECT\u00a0LTRIM(IDARTICULO)\u00a0AS IDARTICULO,\u00a0DBO.FN_EXTRAERENGLON(2,OBSERVACIONES) AS OBS,\u00a0'2'\u00a0AS RENG FROM\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":2},"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":2933,"url":"https:\/\/www.alfagestion.com.ar\/ag\/importar-productos-a-woocommerce-con-alfa-shop-cart\/","url_meta":{"origin":2559,"position":3},"title":"Importar Productos a WooCommerce, con Alfa Shop Cart","date":"20 marzo 2015","format":false,"excerpt":"Como importar el listado de productos a nuestra tienda on-line. Requisitos Previos. Tener el M\u00f3dulo Alfa Shop Cart, instalado en su sistema Alfa Gestion. Tener en su sitio web, el pluggin de WooCommerce + WooCommerce CSV Importer Generar el Archivo CSV para luego Importar a su Tienda Desde el ALFA,\u2026","rel":"","context":"En \u00abAlfa Gesti\u00f3n Comercial\u00bb","img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":9395,"url":"https:\/\/www.alfagestion.com.ar\/ag\/consultar-precios\/","url_meta":{"origin":2559,"position":4},"title":"Consultar precios","date":"5 septiembre 2022","format":false,"excerpt":"Una forma practica de consultar precios, por ejemplo, si tiene la pantalla del facturador abierto (carga de comprobantes) puede presionar las teclas ctrol+b y se abre la pantalla de consulta, donde puede buscar por c\u00f3digo de barra, descripci\u00f3n, rubros, marca, familia, etc... Esta opcion tambien esta habilitado desde la opcion\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\/09\/image.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":5},"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":[]}],"_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}]}}