Tracing Inventory Item ID

Previous Topic Next Topic
 
classic Classic list List threaded Threaded
7 messages Options
Reply | Threaded
Open this post in threaded view
|

Tracing Inventory Item ID

james-2

By looking at an inventory item ID in the system I am trying to track
what Purchase Order that product was received from.  Is there any
relationship in the database that allows me to see the inventory item ID
from the receipt of the purchase order.  ?

Thanks,

James

Reply | Threaded
Open this post in threaded view
|

Re: Tracing Inventory Item ID

Ankush Upadhyay-2
Hello James,

You can directly find Purchase Order from Catalog > Inventory Summary screen.
Here is the URL:
Please replace with your productId.

In this screen, you will find outstanding purchase orders under "Outstanding Purchase Order" section. 
And After product receive, you will be able to find purchase order by Inventory under "Inventory Item for product name" section.



Regarding database point of view, On purchase order receive, Shipment Receipt gets generated and linked with inventory Item so you can find Purchase Order from ShipmentReceipt entity by searching from inventoryItemId




Thanks
--
Ankush Upadhyay

On Thu, Oct 5, 2017 at 2:29 AM, <[hidden email]> wrote:

By looking at an inventory item ID in the system I am trying to track
what Purchase Order that product was received from.  Is there any
relationship in the database that allows me to see the inventory item ID
from the receipt of the purchase order.  ?

Thanks,

James


Reply | Threaded
Open this post in threaded view
|

RE: Tracing Inventory Item ID

james-2
In reply to this post by james-2
the images did not come through...can you resend?  Thabnks

-------- Original Message --------
Subject: Re: Tracing Inventory Item ID
From: Ankush Upadhyay <[hidden email]>
Date: Wed, October 04, 2017 7:04 pm
To: [hidden email]

Hello James,

You can directly find Purchase Order from Catalog > Inventory Summary
screen.
Here is the URL:
https://demo-trunk.ofbiz.apache.org/catalog/control/EditProductInventoryItems?productId=GZ-1000&showAllFacilities=Y

Please replace with your productId.


In this screen, you will find outstanding purchase orders under
"Outstanding Purchase Order" section.
And After product receive, you will be able to find purchase order by
Inventory under "Inventory Item for product name" section.





Regarding database point of view, On purchase order receive, Shipment
Receipt gets generated and linked with inventory Item so you can find
Purchase Order from ShipmentReceipt entity by searching from
inventoryItemId







Thanks
--
Ankush Upadhyay








On Thu, Oct 5, 2017 at 2:29 AM, <[hidden email]> wrote:

 By looking at an inventory item ID in the system I am trying to track
 what Purchase Order that product was received from.  Is there any
 relationship in the database that allows me to see the inventory item
ID
 from the receipt of the purchase order.  ?
 
 Thanks,
 
 James
Reply | Threaded
Open this post in threaded view
|

Re: Tracing Inventory Item ID

Ankush Upadhyay-2
Ok, I am attaching them.


Thanks
--
Ankush Upadhyay

On Thu, Oct 5, 2017 at 7:48 AM, <[hidden email]> wrote:
the images did not come through...can you resend?  Thabnks

-------- Original Message --------
Subject: Re: Tracing Inventory Item ID
From: Ankush Upadhyay <[hidden email]>
Date: Wed, October 04, 2017 7:04 pm
To: [hidden email]

Hello James,

You can directly find Purchase Order from Catalog > Inventory Summary
screen.
Here is the URL:
https://demo-trunk.ofbiz.apache.org/catalog/control/EditProductInventoryItems?productId=GZ-1000&showAllFacilities=Y

Please replace with your productId.


In this screen, you will find outstanding purchase orders under
"Outstanding Purchase Order" section.
And After product receive, you will be able to find purchase order by
Inventory under "Inventory Item for product name" section.





Regarding database point of view, On purchase order receive, Shipment
Receipt gets generated and linked with inventory Item so you can find
Purchase Order from ShipmentReceipt entity by searching from
inventoryItemId







Thanks
--
Ankush Upadhyay








On Thu, Oct 5, 2017 at 2:29 AM, <[hidden email]> wrote:

 By looking at an inventory item ID in the system I am trying to track
 what Purchase Order that product was received from.  Is there any
 relationship in the database that allows me to see the inventory item
ID
 from the receipt of the purchase order.  ?

 Thanks,

 James

Reply | Threaded
Open this post in threaded view
|

RE: Tracing Inventory Item ID

james-2
In reply to this post by james-2
I dont thing the user group allows attachments.  Can you send directly
to [hidden email]?

Thanks!

-------- Original Message --------
Subject: Re: Tracing Inventory Item ID
From: Ankush Upadhyay <[hidden email]>
Date: Wed, October 04, 2017 7:20 pm
To: [hidden email]

Ok, I am attaching them.

Thanks
--
Ankush Upadhyay








On Thu, Oct 5, 2017 at 7:48 AM, <[hidden email]> wrote:
the images did not come through...can you resend?  Thabnks
 
 -------- Original Message --------
 Subject: Re: Tracing Inventory Item ID
 From: Ankush Upadhyay <[hidden email]>
 Date: Wed, October 04, 2017 7:04 pm
 To: [hidden email]
 
 Hello James,
 
 You can directly find Purchase Order from Catalog > Inventory Summary
 screen.
 Here is the URL:
 https://demo-trunk.ofbiz.apache.org/catalog/control/EditProductInventoryItems?productId=GZ-1000&showAllFacilities=Y
 
 Please replace with your productId.
 
 
 In this screen, you will find outstanding purchase orders under
 "Outstanding Purchase Order" section.
 And After product receive, you will be able to find purchase order by
 Inventory under "Inventory Item for product name" section.
 
 ​
 
 
 
 Regarding database point of view, On purchase order receive, Shipment
 Receipt gets generated and linked with inventory Item so you can find
 Purchase Order from ShipmentReceipt entity by searching from
 inventoryItemId
 
 ​
 
 
 
 
 
 Thanks
 --
 Ankush Upadhyay
 
 
 
 
 
 
 
 
 On Thu, Oct 5, 2017 at 2:29 AM, <[hidden email]> wrote:
 
  By looking at an inventory item ID in the system I am trying to track
  what Purchase Order that product was received from.  Is there any
  relationship in the database that allows me to see the inventory item
 ID
  from the receipt of the purchase order.  ?
 
  Thanks,
 
  James
Reply | Threaded
Open this post in threaded view
|

Re: Tracing Inventory Item ID

Aditya Sharma
Hi Ankush,

You can not send any attachment to the mailing list but you can upload an
image to google drive & share the link here.

https://commons.apache.org/mail-lists.html

*Note:* please don't send patches or attachments to any of the mailing
lists. Patches are best handled via the *Issue Tracking* system. Otherwise,
please upload the file to a public server and include the URL in the mail.

Thanks and Regards,

*Aditya Sharma* | Enterprise Software Engineer
HotWax Systems <http://www.hotwaxsystems.com/>
<https://www.linkedin.com/in/aditya-sharma-78291810a/>

On Thu, Oct 5, 2017 at 8:00 AM, <[hidden email]> wrote:

> I dont thing the user group allows attachments.  Can you send directly
> to [hidden email]?
>
> Thanks!
>
> -------- Original Message --------
> Subject: Re: Tracing Inventory Item ID
> From: Ankush Upadhyay <[hidden email]>
> Date: Wed, October 04, 2017 7:20 pm
> To: [hidden email]
>
> Ok, I am attaching them.
>
> Thanks
> --
> Ankush Upadhyay
>
>
>
>
>
>
>
>
> On Thu, Oct 5, 2017 at 7:48 AM, <[hidden email]> wrote:
> the images did not come through...can you resend?  Thabnks
>
>  -------- Original Message --------
>  Subject: Re: Tracing Inventory Item ID
>  From: Ankush Upadhyay <[hidden email]>
>  Date: Wed, October 04, 2017 7:04 pm
>  To: [hidden email]
>
>  Hello James,
>
>  You can directly find Purchase Order from Catalog > Inventory Summary
>  screen.
>  Here is the URL:
>  https://demo-trunk.ofbiz.apache.org/catalog/control/EditPro
> ductInventoryItems?productId=GZ-1000&showAllFacilities=Y
>
>  Please replace with your productId.
>
>
>  In this screen, you will find outstanding purchase orders under
>  "Outstanding Purchase Order" section.
>  And After product receive, you will be able to find purchase order by
>  Inventory under "Inventory Item for product name" section.
>
>  ​
>
>
>
>  Regarding database point of view, On purchase order receive, Shipment
>  Receipt gets generated and linked with inventory Item so you can find
>  Purchase Order from ShipmentReceipt entity by searching from
>  inventoryItemId
>
>  ​
>
>
>
>
>
>  Thanks
>  --
>  Ankush Upadhyay
>
>
>
>
>
>
>
>
>  On Thu, Oct 5, 2017 at 2:29 AM, <[hidden email]> wrote:
>
>   By looking at an inventory item ID in the system I am trying to track
>   what Purchase Order that product was received from.  Is there any
>   relationship in the database that allows me to see the inventory item
>  ID
>   from the receipt of the purchase order.  ?
>
>   Thanks,
>
>   James
>
Reply | Threaded
Open this post in threaded view
|

Re: Tracing Inventory Item ID

Ankush Upadhyay-2
Thanks Aditya for the information.

Thanks
--
Ankush Upadhyay

On Thu, Oct 5, 2017 at 9:44 AM, Aditya Sharma <
[hidden email]> wrote:

> Hi Ankush,
>
> You can not send any attachment to the mailing list but you can upload an
> image to google drive & share the link here.
>
> https://commons.apache.org/mail-lists.html
>
> *Note:* please don't send patches or attachments to any of the mailing
> lists. Patches are best handled via the *Issue Tracking* system. Otherwise,
> please upload the file to a public server and include the URL in the mail.
>
> Thanks and Regards,
>
> *Aditya Sharma* | Enterprise Software Engineer
> HotWax Systems <http://www.hotwaxsystems.com/>
> <https://www.linkedin.com/in/aditya-sharma-78291810a/>
>
> On Thu, Oct 5, 2017 at 8:00 AM, <[hidden email]> wrote:
>
> > I dont thing the user group allows attachments.  Can you send directly
> > to [hidden email]?
> >
> > Thanks!
> >
> > -------- Original Message --------
> > Subject: Re: Tracing Inventory Item ID
> > From: Ankush Upadhyay <[hidden email]>
> > Date: Wed, October 04, 2017 7:20 pm
> > To: [hidden email]
> >
> > Ok, I am attaching them.
> >
> > Thanks
> > --
> > Ankush Upadhyay
> >
> >
> >
> >
> >
> >
> >
> >
> > On Thu, Oct 5, 2017 at 7:48 AM, <[hidden email]> wrote:
> > the images did not come through...can you resend?  Thabnks
> >
> >  -------- Original Message --------
> >  Subject: Re: Tracing Inventory Item ID
> >  From: Ankush Upadhyay <[hidden email]>
> >  Date: Wed, October 04, 2017 7:04 pm
> >  To: [hidden email]
> >
> >  Hello James,
> >
> >  You can directly find Purchase Order from Catalog > Inventory Summary
> >  screen.
> >  Here is the URL:
> >  https://demo-trunk.ofbiz.apache.org/catalog/control/EditPro
> > ductInventoryItems?productId=GZ-1000&showAllFacilities=Y
> >
> >  Please replace with your productId.
> >
> >
> >  In this screen, you will find outstanding purchase orders under
> >  "Outstanding Purchase Order" section.
> >  And After product receive, you will be able to find purchase order by
> >  Inventory under "Inventory Item for product name" section.
> >
> >  ​
> >
> >
> >
> >  Regarding database point of view, On purchase order receive, Shipment
> >  Receipt gets generated and linked with inventory Item so you can find
> >  Purchase Order from ShipmentReceipt entity by searching from
> >  inventoryItemId
> >
> >  ​
> >
> >
> >
> >
> >
> >  Thanks
> >  --
> >  Ankush Upadhyay
> >
> >
> >
> >
> >
> >
> >
> >
> >  On Thu, Oct 5, 2017 at 2:29 AM, <[hidden email]> wrote:
> >
> >   By looking at an inventory item ID in the system I am trying to track
> >   what Purchase Order that product was received from.  Is there any
> >   relationship in the database that allows me to see the inventory item
> >  ID
> >   from the receipt of the purchase order.  ?
> >
> >   Thanks,
> >
> >   James
> >
>