0007202: Automatic creation of a Sales Order from a Purchase Order

Openbravo Issue Tracking System - Openbravo ERP

View Issue Details

Project

Category

View Status

Date Submitted

Last Update

0007202

Openbravo ERP

07. Sales management

public

2009-01-28 17:06

2011-02-04 09:15

Reporter

emartinez

Assigned To

rmorley

Priority

normal

Severity

minor

Reproducibility

always

Status

acknowledged

Resolution

open

Platform

OS Version

Product Version

2.40

Target Version

Fixed in Version

Merge Request Status

Review Assigned To

OBNetwork customer

Web browser

Modules

Core

Support ticket

Regression level

Regression date

Regression introduced in release

Regression introduced by commit

Triggers an Emergency Pack

Summary

0007202: Automatic creation of a Sales Order from a Purchase Order

Description

Imagine the following case for understanding why this feature is requested. Let's say we have different organizations A and B which correspond to different companies. In this situation, let's imagine company A buys a product to company B. By means of this automation, when company A completes a Purchase Order where its provides is organization B, a Sales Order would be automatically generated in organization B.

We have developed this automatization for a client. Contact us in case you need.

Steps To Reproduce

To develop this automation you would have to:

*Modify the process which is executed when "completing" a purchase order.
*We suggest to leave in state "Draft" the sales order generated automatically. Thus, a user of company B should validate it personally, even it has been generated automatically.
*In case that company A reactivates the purchase order (already completed), the changes will not be transferred automatically to the sales order in company B (already created).
*In order to inform users in company B that new sales order have been generated automatically, new alerts can be created.

Proposed Solution

Then, going to more technical details:

In the procedure C_ORDER_POST you will have to add the following:

*If it is a purchase order
*which is being complete
*and there is not a sales order already related to it (you should add a new column in C_ORDER in order to inform of the Sales Order ID related to the current purchase order)
*and it is a transaction between two organizations belonging to the same client (the business partner of the purchase document, organization B, is related to an organization in AD_ORGINFO)

Then:

**Then create the header of the sales order
**Create the lines with the same products in the lines the purchase order lines contain. For this, the products should be defined by organization "*", in order to see them in both organizations A and B.

Finally, when the sales order is generated in organization B, you should inform the field POREFERENCE with the DocumentNo of the purchase order of organization A. In the same way, you will have to inform the POREFERENCE field of the purchase order of organization A with the DocumentNo of the sales order of organization B.

Additional Information