Anonymous | Login
News | My View | View Issues | Roadmap | Summary

View Issue DetailsJump to Notes ] Issue History ] Print ]
TypeCategorySeverityReproducibilityDate SubmittedLast Update
feature request[Openbravo ERP] 03. Procurement managementminoralways2009-01-28 18:022011-02-04 09:11
ReporteremartinezView Statuspublic 
Assigned Tormorley 
PrioritynormalResolutionopenFixed in Version
StatusacknowledgedFix in branchFixed in SCM revision
ProjectionnoneETAnoneTarget Version
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product Version2.40SCM revision 
Review Assigned To
Web browser
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo

0007205: Automatic creation of a Goods Receipt from a Goods Shipment

DescriptionImagine 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. We suggest to automate the following: Create automatically the Goods Receipt in company A When company B completes the corresponding Goods Shipment.

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

Steps To ReproduceTo develop this automation you would have to:

*Modify the process which is executed when "completing" a goods shipment.
*We suggest to leave in state "Draft" the goods receipt generated automatically in organization A. Thus, a user of company A should validate it personally, even it has been generated automatically.
*In case that company B voids the goods shipment (already completed), this will not affect to the goods receipt generated in company A.
*In order to inform users in company A that new goods receipts have been generated automatically, new alerts can be created.
Proposed SolutionThen, going to more technical details:

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

*If it is a goods shipment
*which is being complete
*and there is not a goods shipment already related to it (you should add a new column in M_INOUT in order to inform of the Goods Receipt ID related to the current goods shipment document)
*and it is a transaction between two organizations belonging to the same client (the business partner of the goods shipment document, organization A, is related to an organization in AD_ORGINFO)


**Then create the header of the goods receipt in organization A
**Create the lines with the same products as in the goods shipment of organization B. For this, the products should be defined by organization "*", in order to see them in both organizations A and B.
***First of all, we will have to take care of the attributes, since they should be defined twice in the tables M_ATTRIBUTESETINSTANCE, M_ATTRIBUTEINSTANCE y M_ATTRIBUTEVALUE. Thus, if we change the attributes of products in organization B should not affect the attribute definition of the same products in organization A.
***When creating each line, we will observe if each product is contained in the corresponding Purchase Order line. If not, we will create the line in the goods receipt and in its description field we will write "We could not related this product to any Purchase Order". Thus, the user of organization A will have to modify manually the corresponding purchase order.

Finally, when the goods receipt is generated in organization A, you should inform the field POREFERENCE with the DocumentNo of the goods shipment of organization B. In the same way, you will have to inform the POREFERENCE field of the goods shipment of organization B with the DocumentNo of the goods receipt of organization A.
TagsNo tags attached.
Attached Files

- Relationships Relation Graph ] Dependency Graph ]
related to feature request 0007202 acknowledgedrmorley Automatic creation of a Sales Order from a Purchase Order 
blocks feature request 0007248 acknowledgedrmorley Intercompany shipments 

-  Notes
camcal (reporter)
2009-10-10 18:55


I'm actually working with the Intercompany module and i wonder if you can send me the code to create the shipments and the receipts.

Plus i want to mention that i found a bug in the procedures, they are trying to store the name of the product into a varchar(32) and the table m_product uses varchar(60), so when the product has more than 32 characters it crashes.

To solve this just change "v_productName VARCHAR(32)" to "v_productName VARCHAR(60)" in both procedures, "interco_create_order" and "interco_create_invoice".

Theres no need to compile openbravo since the modification it's on the procedure and it doesn't involves additional parameters or fields.

- Issue History
Date Modified Username Field Change
2009-01-28 18:02 emartinez New Issue
2009-01-28 18:02 emartinez Assigned To => rafaroda
2009-01-28 18:02 emartinez sf_bug_id 0 => 2543437
2009-01-29 11:04 rafaroda Relationship added related to 0007202
2009-01-29 11:05 rafaroda Assigned To rafaroda => pjuvara
2009-01-29 21:52 pjuvara Relationship added blocks 0007248
2009-01-29 21:53 pjuvara Status new => acknowledged
2009-10-10 18:55 camcal Note Added: 0020927
2011-02-04 09:11 jpabloae Assigned To pjuvara => rmorley

Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker