Inventory Move Between Two Warehouse On Two Organization

[edwin_ang]

Hi All,

We've been working on several solution on previous project regarding to this case.The case is we have two warehouse on two location. Lets say it is on two different organization so we have two different people with authority over the warehouse.

How do we move Inventory between these two warehouses? Would like to hear how others tackle this issue.

Regards,

Edwin Ang

[Dy]

Hi Edwin,

i think what you need is Adempiere Libero - Distribution Order feature.
Refer to http://sourceforge.net/p/adempiere/discussion/610546/thread/34400201 and http://www.adempiere.com/index.php/Sponsored_Development:_Distribution_Resource_Planning

Regards,
Dyanto

[HansAnton Riess]

I agree, but at the moment libero is not official inckuded in Idempiere.
Hopefully it will be available in V 1d ...

Regards
Hans

[Carlos Antonio Ruiz Gomez]

Hi Edwin, we have modeled the process in several ways depending on the implementation needs.

1 - define a material movement document with flag "In transit" - then completing the move will create a confirmation and the receiving party must complete the confirmation in order to allow the movement to be completed

2 - another approach we used in a different implementation was to create a transit warehouse, this was because the sending warehouse wanted to discharge the inventory immediately and the transit take some days, so flow is:
- sending party move the items from wh1 to transit
- complete movement
- some days pass - truck on road
- receiving party move the items from transit to wh2
- complete movement
the transit is precisely the truck - and maybe if you want to control inventories on truck that can help too


Hans / Dyanto, I would like to see also a working mfg extension pluggable into idempiere.
Edwin already made a call for work here:
https://groups.google.com/forum/#!msg/idempiere/QazaGsnVHrE/hvnLA6of8tEJ
As I understood from Jan's message it requires some work on 2pack, so, any volunteers?


Regards,

Carlos Ruiz

[Edwin Ang]

Hi Everyone,

Thanks for the response. I've tried almost all the suggested solution in several implementation :D

However the major problem lies in the user access and created journal

I'll illustrate using simple scenario:

User A, in Org A, having authorities  on Warehouse A and Locator A1, A2, and A3.

User B, in Org B, having authorities on Warehouse B and Locator B1, B2, and B3.

Access for both users are restricted to their own Org. Meaning User A cannot see Warehouse B and vise versa. How can they set the destination warehouse / locator if they cannot see it? If you give both users access to all Orgs, then how do you restrict user A not to use Warehouse / Locator B as source?

My latest workaround is:

1. create some dummy table --> XX_Locator with entries identical to of M_Locator. All entries of XX_Locator has AD_Org_ID = *

2. We pre-define an intransit locator for each warehouse

3. We create a custom Inter-Org Move Out window, adding a custom field Target_Locator pointing to XX_Locator. User A then can select Locator A1 as 

its source locator, and locator B1 as Target_Locator indirectly through XX_Locator. The LocatorTo default to intransit locator on Warehouse A, lets say A3. Document Inter-Org Move Out will be in Org A.

4. When completed, we will autocreate a Inter-Org Move In transaction, locator From is A3 (locked from editing) while locator To is B1 (actual from M_Locator). Document is in Org B. User B can update the Qty to confirm the move and update the paper work. 

5. If the confirmed qty is less than the moved qty, upon receiving the confirmation, user A must move back the remaining qty into A1. 

I know there's quite some steps. But it is less disruptive development, and we can have access restriction and the journals are correct. But then, I am looking for a more generic solution that can be integrated into iDempiere. 

So, please share your thoughts. It will be highly appreciated.

Regards,

Edwin Ang

--
You received this message because you are subscribed to the Google Groups "iDempiere" group.
To unsubscribe from this group and stop receiving emails from it, send an email to idempiere+...@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.
 
 

[Carlos Antonio Ruiz Gomez]

So Edwin, the problem is not in the document, but in the field access?

I've seen similar problem with bank transfers too.

I think there can be a way to solve that without code, not tested, just draft steps as the idea that I would try:
- create a view M_Locator_Auth_V based on M_Locator and changing the organization to those records that you want to show to users
- create the corresponding table on dictionary for that view
- create a reftable for that view
- overwrite the reference of the locator_to field  on window to point to this new reference -> reference=table, refkey=reference created -

Regards,

Carlos Ruiz

[Fco. Javier Vannini Robelo]

Link bp to organization and make a sales order from org a to org b (the receiving organization). I think yiu can use contra documents to create a purchase order from org b to org a.

[Dy]

For your case my configuration will be:

1. Create Dummy Organization "In Transit" (And gave user from other org to access this org)
   
2. Create Warehouse "In Transit" in Organization In Transit, and create in transit locator
   
3. Link Org A to BP A
4. Link Org B to BP B

In the scenario moving some products from Org A to Org B, the steps will be:

1. Create Inventory move base on Org A, fill the Business Partner field with BP B, from warehouse A - locator A to Locator In Transit.
   
2. When the product arrive at org B, then PIC in Org B, create Inventory move base on Org B, with BP A, from locator in Transit to warehouse B - locator B.

with that approach, in the end we will have:

1. intercompany Due From BP B in the org A
2. intercompany Due to BP A in the Org B
3. Intercompany Due From BP A and intercompany due to BP B in the Org In Transit. We can ignore the journal in this org, since it is only a dummy org.
   

Regards,

Dyanto