Relate Purchase Order with Sales Order

[Jonathan Javier]

Hello,
Knowing that an order can link an invoice,
I would like to know if there is an opportunity in OFBiz to be able to link
a Sales Order to a Purchase Order.

[taher]

Hi Jonathan,

What would be the purpose of linking these two orders with each other? What
information do you want to retrieve?

Cheers,

Taher Alkhateeb

On Wed, Mar 29, 2017 at 6:05 PM, Jonathan Javier <[hidden email]>
wrote:

> Hello,
> Knowing that an order can link an invoice,
> I would like to know if there is an opportunity in OFBiz to be able to link
> a Sales Order to a Purchase Order.
>

[Pierre Smits]

Hi Jonathan,

Yes, there is. But it involves effort. And I doubt whether that should be
in the transactional part of OFBiz. Maybe brought together in the BI
component.

Best regards,

Pierre Smits

ORRTIZ.COM <http://www.orrtiz.com>
OFBiz based solutions & services

OFBiz Extensions Marketplace
http://oem.ofbizci.net/oci-2/

On Wed, Mar 29, 2017 at 5:05 PM, Jonathan Javier <[hidden email]>
wrote:

> Hello,
> Knowing that an order can link an invoice,
> I would like to know if there is an opportunity in OFBiz to be able to link
> a Sales Order to a Purchase Order.
>

[cardenasvar]

Here in our organization a purchase order can be generated for stock or by order of a customer in a sales order.
That is why the need to be able to link both documents

[Pierre Smits]

Thanks for quick reply.

Now I get the picture. This is something you can achieve through inventory
management by applying lot/batch tracking in the warehousing application.

Best regards,

Pierre Smits

ORRTIZ.COM <http://www.orrtiz.com>
OFBiz based solutions & services

OFBiz Extensions Marketplace
http://oem.ofbizci.net/oci-2/

On Wed, Mar 29, 2017 at 8:14 PM, cardenasvar <[hidden email]>
wrote:

> Here in our organization a purchase order can be generated for stock or by
> order of a customer in a sales order.
> That is why the need to be able to link both documents
>
>
>
> --
> View this message in context: http://ofbiz.135035.n4.nabble.
> com/Relate-Purchase-Order-with-Sales-Order-tp4704120p4704139.html
> Sent from the OFBiz - User mailing list archive at Nabble.com.
>

[taher]

Hi Jonathan,

So I'm sure there are multiple ways to achieve this.

In the case where the order is backed by an order instead of stock in your
warehouse maybe one way perhaps is to have a Customer Request linked to a
WorkEffort which is linked to the orders. I suggested a Customer Request
because it seems you need a good workflow for this process (receive the
order, put it in inventory, re-package, invoice, etc ...)

Perhaps others can provide some other useful ideas, the data model is big
and so there are probably multiple ways to get a solution.

Cheers,

Taher Alkhateeb

On Wed, Mar 29, 2017 at 9:14 PM, cardenasvar <[hidden email]>
wrote:

> Here in our organization a purchase order can be generated for stock or by
> order of a customer in a sales order.
> That is why the need to be able to link both documents
>
>
>
> --
> View this message in context: http://ofbiz.135035.n4.nabble.
> com/Relate-Purchase-Order-with-Sales-Order-tp4704120p4704139.html
> Sent from the OFBiz - User mailing list archive at Nabble.com.
>

[SkipDever]

See the OrderItemAssoc and OrderRequirementCommitment entities.

-----Original Message-----
From: Jonathan Javier [mailto:[hidden email]]
Sent: Wednesday, March 29, 2017 8:06 AM
To: [hidden email]
Subject: Relate Purchase Order with Sales Order


Hello,
Knowing that an order can link an invoice,
I would like to know if there is an opportunity in OFBiz to be able to link
a Sales Order to a Purchase Order.

[SkipDever]

This is primarily used to associate backorders with the sales order.

-----Original Message-----
From: Taher Alkhateeb [mailto:[hidden email]]
Sent: Wednesday, March 29, 2017 10:45 AM
To: [hidden email]
Subject: Re: Relate Purchase Order with Sales Order


Hi Jonathan,

What would be the purpose of linking these two orders with each other? What
information do you want to retrieve?

Cheers,

Taher Alkhateeb

On Wed, Mar 29, 2017 at 6:05 PM, Jonathan Javier <[hidden email]>
wrote:

> Hello,
> Knowing that an order can link an invoice,
> I would like to know if there is an opportunity in OFBiz to be able to link
> a Sales Order to a Purchase Order.
>

[Jacopo Cappellato-5]

Hello Jonathan,

you can look at the following entities:

OrderItemAssoc
OrderItemAssocType

The currently available association types (orderItemAssocTypeId) are:

PURCHASE_ORDER
DROP_SHIPMENT
REPLACEMENT
NEW_VERSION
EXCHANGE

I hope it helps,

Jacopo


On Wed, Mar 29, 2017 at 5:05 PM, Jonathan Javier <[hidden email]>
wrote:

> Hello,
> Knowing that an order can link an invoice,
> I would like to know if there is an opportunity in OFBiz to be able to link
> a Sales Order to a Purchase Order.
>

[Jonathan Javier]

Thanks for the advice and help, I will review these entities and see how procedure is done in the UI.

Regards