Return-Path: X-Original-To: archive-asf-public-internal@cust-asf2.ponee.io Delivered-To: archive-asf-public-internal@cust-asf2.ponee.io Received: from cust-asf.ponee.io (cust-asf.ponee.io [163.172.22.183]) by cust-asf2.ponee.io (Postfix) with ESMTP id 5E206200D23 for ; Thu, 5 Oct 2017 04:31:02 +0200 (CEST) Received: by cust-asf.ponee.io (Postfix) id 5C3B8160BD7; Thu, 5 Oct 2017 02:31:02 +0000 (UTC) Delivered-To: archive-asf-public@cust-asf.ponee.io Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by cust-asf.ponee.io (Postfix) with SMTP id A00C41609DD for ; Thu, 5 Oct 2017 04:31:01 +0200 (CEST) Received: (qmail 16066 invoked by uid 500); 5 Oct 2017 02:31:00 -0000 Mailing-List: contact user-help@ofbiz.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: user@ofbiz.apache.org Delivered-To: mailing list user@ofbiz.apache.org Received: (qmail 16053 invoked by uid 99); 5 Oct 2017 02:31:00 -0000 Received: from pnap-us-west-generic-nat.apache.org (HELO spamd1-us-west.apache.org) (209.188.14.142) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 05 Oct 2017 02:31:00 +0000 Received: from localhost (localhost [127.0.0.1]) by spamd1-us-west.apache.org (ASF Mail Server at spamd1-us-west.apache.org) with ESMTP id 94C85C893D for ; Thu, 5 Oct 2017 02:30:59 +0000 (UTC) X-Virus-Scanned: Debian amavisd-new at spamd1-us-west.apache.org X-Spam-Flag: NO X-Spam-Score: 2.2 X-Spam-Level: ** X-Spam-Status: No, score=2.2 tagged_above=-999 required=6.31 tests=[KAM_LAZY_DOMAIN_SECURITY=1, KAM_LINEPADDING=1.2, RCVD_IN_DNSWL_NONE=-0.0001] autolearn=disabled Received: from mx1-lw-eu.apache.org ([10.40.0.8]) by localhost (spamd1-us-west.apache.org [10.40.0.7]) (amavisd-new, port 10024) with ESMTP id pkg4sDU9r6Wo for ; Thu, 5 Oct 2017 02:30:57 +0000 (UTC) Received: from p3plwbeout17-01.prod.phx3.secureserver.net (p3plsmtp17-01-2.prod.phx3.secureserver.net [173.201.193.162]) by mx1-lw-eu.apache.org (ASF Mail Server at mx1-lw-eu.apache.org) with ESMTPS id 38F935F485 for ; Thu, 5 Oct 2017 02:30:57 +0000 (UTC) Received: from p3plgemwbe17-04.prod.phx3.secureserver.net ([173.201.193.138]) by :WBEOUT: with SMTP id zvvXdm5m7XkPNzvvXdhwFi; Wed, 04 Oct 2017 19:30:19 -0700 X-SID: zvvXdm5m7XkPN Received: (qmail 16344 invoked by uid 99); 5 Oct 2017 02:30:19 -0000 Content-Transfer-Encoding: quoted-printable Content-Type: text/plain; charset="utf-8" X-Originating-IP: 99.66.21.102 User-Agent: Workspace Webmail 6.8.14 Message-Id: <20171004193018.711664eeb53defe1e7c8f40d07deeb65.442b6bdac1.wbe@email17.godaddy.com> From: To: user@ofbiz.apache.org Subject: RE: Tracing Inventory Item ID Date: Wed, 04 Oct 2017 19:30:18 -0700 Mime-Version: 1.0 X-CMAE-Envelope: MS4wfAYq2Ceyiv/XuyOk+fcEFbCXE8L8JdaMMufC1BUKyLw65SVPVI7w/eCZcxaPs9H1/bTPSx+HZpGAEfIkE+RLphORJvlDO7GhEiifYmj2ws5CCljV/5XS Z3+MEEFrr/MBnFtKXxndrOeuWqDTFIr6HEJJAHDAALaYODKewttvw33WkWVX2pWprCNsyXtSUe0xLkwZkiYmPkZF8/h2wKIFB0Ec0HyVwmEYw29V9FWE3bGO archived-at: Thu, 05 Oct 2017 02:31:02 -0000 I dont thing the user group allows attachments. Can you send directly=0Ato= james@productive1.com?=0A=0AThanks!=0A=0A-------- Original Message -------= -=0ASubject: Re: Tracing Inventory Item ID=0AFrom: Ankush Upadhyay =0ADate: Wed, October 04, 2017 7:20 pm=0ATo: use= r@ofbiz.apache.org=0A=0AOk, I am attaching them.=0A=0AThanks=0A--=0AAnkush = Upadhyay=0A=0A=0A=0A=0A=0A=0A=0A=0AOn Thu, Oct 5, 2017 at 7:48 AM, wrote:=0Athe images did not come through...can you resend? = Thabnks=0A =0A -------- Original Message --------=0A Subject: Re: Tracing = Inventory Item ID=0A From: Ankush Upadhyay =0A Date: Wed, October 04, 2017 7:04 pm=0A To: user@ofbiz.apache.org=0A = =0A Hello James,=0A =0A You can directly find Purchase Order from Catalog >= Inventory Summary=0A screen.=0A Here is the URL:=0A https://demo-trunk.ofb= iz.apache.org/catalog/control/EditProductInventoryItems?productId=3DGZ-1000= &showAllFacilities=3DY=0A =0A Please replace with your productId.=0A =0A = =0A In this screen, you will find outstanding purchase orders under=0A "Out= standing Purchase Order" section.=0A And After product receive, you will be= able to find purchase order by=0A Inventory under "Inventory Item for prod= uct name" section.=0A =0A =E2=80=8B=0A =0A =0A =0A Regarding database point= of view, On purchase order receive, Shipment=0A Receipt gets generated and= linked with inventory Item so you can find=0A Purchase Order from Shipment= Receipt entity by searching from=0A inventoryItemId=0A =0A =E2=80=8B=0A =0A= =0A =0A =0A =0A Thanks=0A --=0A Ankush Upadhyay=0A =0A =0A =0A =0A =0A =0A= =0A =0A On Thu, Oct 5, 2017 at 2:29 AM, wrote:=0A = =0A By looking at an inventory item ID in the system I am trying to track= =0A what Purchase Order that product was received from. Is there any=0A = relationship in the database that allows me to see the inventory item=0A ID= =0A from the receipt of the purchase order. ?=0A =0A Thanks,=0A =0A Jam= es