Return-path: Envelope-to: christian@ssf.com.mx Delivery-date: Sat, 27 Feb 2016 23:07:06 -0600 Received: from brown.pear.relay.mailchannels.net ([23.83.216.23]:43901) by vishnu.hosting-mexico.net with esmtps (TLSv1.2:ECDHE-RSA-AES256-GCM-SHA384:256) (Exim 4.86) (envelope-from ) id 1aZtZP-002vAl-Op for christian@ssf.com.mx; Sat, 27 Feb 2016 23:07:06 -0600 X-Sender-Id: totalchoicehosting|x-authuser|mantisbt@softwarepararestaurantes.mx Received: from relay.mailchannels.net (localhost [127.0.0.1]) by relay.mailchannels.net (Postfix) with ESMTP id 80A30100294 for ; Sun, 28 Feb 2016 05:06:22 +0000 (UTC) Received: from troy.tchmachines.com (ip-10-37-2-55.us-west-2.compute.internal [10.37.2.55]) by relay.mailchannels.net (Postfix) with ESMTPA id DD4D6100314 for ; Sun, 28 Feb 2016 05:06:21 +0000 (UTC) X-Sender-Id: totalchoicehosting|x-authuser|mantisbt@softwarepararestaurantes.mx Received: from troy.tchmachines.com (troy.tchmachines.com [10.204.2.195]) (using TLSv1 with cipher DHE-RSA-AES256-SHA) by 0.0.0.0:2500 (trex/5.6.6); Sun, 28 Feb 2016 05:06:22 +0000 X-MC-Relay: Good X-MailChannels-SenderId: totalchoicehosting|x-authuser|mantisbt@softwarepararestaurantes.mx X-MailChannels-Auth-Id: totalchoicehosting X-MC-Loop-Signature: 1456635982169:87118350 X-MC-Ingress-Time: 1456635982169 Received: from [108.161.131.202] (port=33520 helo=108.161.131.202) by troy.tchmachines.com with esmtpsa (TLSv1:DHE-RSA-AES256-SHA:256) (Exim 4.86) (envelope-from ) id 1aZtYf-000059-7n for christian@ssf.com.mx; Sun, 28 Feb 2016 00:06:17 -0500 Date: Sat, 27 Feb 2016 23:06:20 -0600 To: christian@ssf.com.mx From: Mantis Bugtracker system Subject: =?utf-8?Q?[PADPOS_0001089]:_Correcci=C3=B3n_en_Existencias_al_consultar_m?= =?utf-8?Q?ovimientos_de_inventario?= Message-ID: X-Priority: 3 X-Mailer: PHPMailer 5.2.6 (https://github.com/PHPMailer/PHPMailer/) Auto-Submitted: auto-generated X-Auto-Response-Suppress: All keywords: [PADPOS] JSP (Vista) In-Reply-To: MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 X-AuthUser: mantisbt@softwarepararestaurantes.mx Content-Transfer-Encoding: quoted-printable X-Spam-Status: No, score=3.3 X-Spam-Score: 33 X-Spam-Bar: +++ X-Ham-Report: Spam detection software, running on the system "vishnu.hosting-mexico.net", has NOT identified this incoming email as spam. The original message has been attached to this so you can view it or label similar future email. If you have any questions, see root\@localhost for details. Content preview: A NOTE has been added to this issue. ====================================================================== http://108.161.131.202/mantis/view.php?id=1089 ====================================================================== Reported By: jdurazo Assigned To: christian ====================================================================== Project: PADPOS Issue ID: 1089 Category: JSP (Vista) Reproducibility: always Severity: minor Priority: normal Status: assigned Target Version: 1.8 Ambiente: Pruebas(8100) Número Completo de Versión: 1.7.258 Revisión en control de versiones: ====================================================================== Date Submitted: 2015-02-01 18:13 CST Last Modified: 2016-02-24 19:24 CST ====================================================================== Summary: Corrección en Existencias al consultar movimientos de inventario Description: Los datos de Existencia no corresponden a la realidad en las consultas de Movimientos de Inventario que se presentan al usuario en pantalla. Esto se puede verificar al hacer una carga de inventario físico con la opción subir archivo (Corregido en la incidencia 1060) ====================================================================== Relationships ID Summary related to 0001060 No se puede subir inventario en Subir A... related to 0000565 En el reporte de consulta de Movimiento... parent of 0000812 Reporte de Movimientos de Inventario - ... ====================================================================== [...] Content analysis details: (3.3 points, 5.0 required) pts rule name description ---- ---------------------- -------------------------------------------------- 0.0 URIBL_BLOCKED ADMINISTRATOR NOTICE: The query to URIBL was blocked. See http://wiki.apache.org/spamassassin/DnsBlocklists#dnsbl-block for more information. [URIs: 108.161.131.202] 0.0 HEADER_FROM_DIFFERENT_DOMAINS From and EnvelopeFrom 2nd level mail domains are different 0.9 RCVD_NUMERIC_HELO Received: contains an IP address used for HELO 0.9 SPF_FAIL SPF: sender does not match SPF record (fail) [SPF failed: Please see http://www.openspf.org/Why?s=mfrom;id=admin%40example.com;ip=23.83.216.23;r=vishnu.hosting-mexico.net] 0.0 IP_LINK_PLUS URI: Dotted-decimal IP address followed by CGI 0.0 NORMAL_HTTP_TO_IP URI: URI host has a public dotted-decimal IPv4 address 1.5 FSL_HELO_BARE_IP_2 No description available. X-Spam-Flag: NO A NOTE has been added to this issue.=20 =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=20 http://108.161.131.202/mantis/view.php?id=3D1089=20 =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=20 Reported By: jdurazo Assigned To: christian =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=20 Project: PADPOS Issue ID: 1089 Category: JSP (Vista) Reproducibility: always Severity: minor Priority: normal Status: assigned Target Version: 1.8 Ambiente: Pruebas(8100)=20 N=C3=BAmero Completo de Versi=C3=B3n: 1.7.258=20 Revisi=C3=B3n en control de versiones: =20 =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=20 Date Submitted: 2015-02-01 18:13 CST Last Modified: 2016-02-24 19:24 CST =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=20 Summary: Correcci=C3=B3n en Existencias al consultar m= ovimientos de inventario Description:=20 Los datos de Existencia no corresponden a la realidad en las consultas de Movimientos de Inventario que se presentan al usuario en pantalla. Esto s= e puede verificar al hacer una carga de inventario f=C3=ADsico con la opci=C3=B3n= subir archivo (Corregido en la incidencia 1060) =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D Relationships ID Summary ---------------------------------------------------------------------- related to 0001060 No se puede subir inventario en Subir A... related to 0000565 En el reporte de consulta de Movimiento... parent of 0000812 Reporte de Movimientos de Inventario - ... =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=20 ----------------------------------------------------------------------=20 (0002764) jdurazo (administrator) - 2015-02-02 16:25 http://108.161.131.202/mantis/view.php?id=3D1089#c2764=20 ----------------------------------------------------------------------=20 La teor=C3=ADa dice que debe de calcularse de esta forma considerando la = fecha inicial solicitada y la fecha final solicitada. 1.- Encontrar el ajuste de inventario m=C3=A1s cercano, partiendo de la F= echa Inicial solicitada hacia atr=C3=A1s en el tiempo. Considerar los inicios = y fines de turno. 2.- Considerar todos los movimientos que afectan inventario hasta un d=C3= =ADa anterior a la fecha solicitada: Restar Consumos, Sumar Recepci=C3=B3n de = Orden de Compra, Restar Env=C3=ADo de traspaso, Restar Env=C3=ADo de traspaso a co= mposta, Sumar Recepci=C3=B3n de traspaso. 3.- Con el dato inicial ya calculado empezar a listar todos y cada uno de= los movimientos de inventario y presentarlo en donde haya sido solicitado, ya= sea en pantalla o en los reportes. 4.- No considerar, para este efecto los inicios y fines de turno, que sea= n siempre hist=C3=B3ricos. 5.- Si se desea tener el despliegue o reporte de estos movimientos por intervalos en horas, se habr=C3=A1n de agregar esos par=C3=A1metros de b=C3= =BAsqueda en un futuro.=20 ----------------------------------------------------------------------=20 (0002937) jdurazo (administrator) - 2015-10-19 17:27 http://108.161.131.202/mantis/view.php?id=3D1089#c2937=20 ----------------------------------------------------------------------=20 En la incidencia 812 est=C3=A1 el desgloce de la forma de c=C3=A1lculo. En la nota: 2529 se menciona: Se toma en cuenta para el c=C3=A1lculo: -Composta -Traspasos enviados -Traspasos recibidos -Recepci=C3=B3n de orden de compra -Consumos -Captura de inventario (Cada que este aparece, el c=C3=A1lculo se reinici= a en base a la captura de inventario) Aunque falta agregar: - Ordenes de Fabricaci=C3=B3n - Cancelaci=C3=B3n de tickets de tienda con retorno de inventario (La apl= icaci=C3=B3n pregunta si el producto a cancelar se va a reintegrar al inventario) Detallando: Suponiendo que se pide una consulta de movimientos de inventario del 10 a= l 20 de Octubre en el almac=C3=A9n 2, se debe hacer lo siguiente: 1.- Ubicar, si lo hay, un ajuste de inventario previo al 10 de Octubre, y= de encontrarse el ajuste de inventario tomar ese dato, si no hay dato de aju= ste de inventario tomar 0 como base. 2.- Sumar todos los movimientos que sumen inventario previos al 2015-10-1= 0 00:00 ( Traspasos efectivamente recibidos, Recepci=C3=B3n de orden de compra, O= rdenes de Fabricaci=C3=B3n, Devoluciones en Cancelaci=C3=B3n de Ticket de Tienda) 3.- Restar todos los movimientos que resten inventario previos al 2015-10= -10 00:00 ( Traspasos a Composta, Traspasos enviados, Consumos, Consumos, ...= ) 4.- El resultado ser=C3=A1 el punto de partida o primer registro para la = consulta 5.- A partir de ese momento ubicar todos los movimientos que afecten inve= ntario que se han mencionado as=C3=AD como los de ajuste de inventario - corresp= ondientes al inventario f=C3=ADsico - y ordenarlos por Fecha y hora, reflejarlos en= la pantalla de consulta de movimientos y as=C3=AD hasta que se llegue a la f= echa final solicitada para el reporte)=20 ----------------------------------------------------------------------=20 (0002944) jdurazo (administrator) - 2015-10-22 20:45 http://108.161.131.202/mantis/view.php?id=3D1089#c2944=20 ----------------------------------------------------------------------=20 Ejemplo a considerar: Subir ajuste de inventario f=C3=ADsico con fecha 5 de Octubre Subir ajuste de inventario f=C3=ADsico con fecha 10 de Octubre Hacer varios movimientos de traspasos, recepciones de ordenes de compra, consumos , entre el 5 y el 19 de octubre Y luego pedir un reporte del 7 de octubre al 16 y ver si toma en cuenta e= l ajuste de inventario del 5 de octubre....=20 ----------------------------------------------------------------------=20 (0002995) jdurazo (administrator) - 2016-02-24 19:24 http://108.161.131.202/mantis/view.php?id=3D1089#c2995=20 ----------------------------------------------------------------------=20 NO SE TOMAN EN CUENTA LOS CONSUMOS, tabla consumo se debe de tomar en cue= nta.=20 Issue History=20 Date Modified Username Field Change = =20 =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=20 2015-02-01 18:13 jdurazo New Issue = =20 2015-02-01 18:13 jdurazo Status new =3D> assigne= d =20 2015-02-01 18:13 jdurazo Assigned To =3D> rsansores = =20 2015-02-01 18:13 jdurazo N=C3=BAmero Completo de Versi=C3=B3n =3D>= 1.7.258 =20 2015-02-01 18:14 jdurazo Relationship added related to 00010= 60 =20 2015-02-01 18:20 jdurazo Relationship added related to 00005= 65 =20 2015-02-02 16:25 jdurazo Note Added: 0002764 = =20 2015-10-19 17:15 jdurazo Relationship added parent of 000081= 2 =20 2015-10-19 17:27 jdurazo Note Added: 0002937 = =20 2015-10-19 17:30 jdurazo Assigned To rsansores =3D> c= hristian 2015-10-22 20:45 jdurazo Note Added: 0002944 = =20 2015-10-26 16:00 jdurazo File Added: Ejercicio visualizaci=C3=B3n = movimientos de inventario.ods =20 2016-02-24 19:24 jdurazo Note Added: 0002995 = =20 =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D