RE: RE: Quantity missing for inventory transfer records

[Swapnil Shah]

Let me try adding few more insights/details with regard to stock transfer
flow.



As we are referring to intra-organizational goods movement i.e., so
movement of goods would be for and within the same business entity. Here
are few pointers (if it can help in assessing any kind of technical
trade-off that needs to be made with respect to current implementation) :

   - Stock Transfer per se are going to involve goods exchange but there is
   no real time money exchange involved between shipper and receiver as they
   are both the very same business entity in the legal sense. So business
   might not be necessarily interested in generating any sales or purchase
   invoice against such transactions. Nor will there be any real time payment
   or invoice settlement required at either end.
   - In financial terms there are tax implications but its applicability
   varies depending upon the laws of the land or country/state-specific tax
   regulations. For example:
  - In US the very same item transferred in certain state might be
  taxable at certain rate but totally exempted or taxed at
different rate in
  another (someone with better understanding of US or EUR tax
regulations can
  throw more light and let us know if currently intra-company
goods transfer
  are even taxable or not)
  - In India, the tax implications in the case of goods transfer is now
  shifted on the supply of goods. As a result:
 - For inter-state transfer *there is tax liability and in this
 case, only a separate “Tax Invoice”* needs to be issued along with
 stock transfer note and supporting document (depending on the
inter-state
 regulations while crossing the state borders)
 - For intra-state transfers if business entity is having single
 registration for originating and receiving branches with tax
authority then *there
 is no tax liability and hence no Tax Invoice *needs to be issue.
 Only Delivery Note should suffice to transfer the goods.
 - For intra-state transfers if business entity is having different
 registration for originating and receiving branches with tax
authority then *there
 is tax liability and in this case, only a separate “Tax Invoice”*
 needs to be issued along with stock transfer note.
  - Any kind of applicable tax (if any) needs to be paid to the state
  only and a separate Tax Invoice needs to be generated in this case.
   - The transfer shipment needs to follow certain status transitioning
   i.e. ‘Requested’ à ‘In-review’ à ‘Shipped’ (from originating facility) à
   ‘In-transit’ à ‘Received’ (at destination facility). As it needs to be
   tracked internally.
   - The deemed transaction value and tax liability against the transferred
   goods should hit the accounting books against appropriate GL accounts per
   store and a separate GL account against the tax authority (in accordance
   with business rules).
   - Later at some point of time we may also like to systemically build the
   Transfer Requirement Planning and consolidate all the individual
   product-wise transfer ad-hoc or planned requests/requirement for a common
   destination facility (i.e., once any feature like
   https://issues.apache.org/jira/browse/OFBIZ-6964 gets implemented)



I hope it should help to come up with a generic enough solution that can
work across geographies with required level of flexibility.



Thanks,

Swapnil



-Original Message-
From: James Yong [mailto:jamesy...@apache.org]
Sent: Wednesday, October 18, 2017 9:56 PM
To: dev@ofbiz.apache.org
Subject: Re: RE: Quantity missing for inventory transfer records



Hi Vaibhav,



My random thoughts on the possible implementation:



We can have a new InventoryTransferHeader (ITH) entity as mentioned earlier
to manage group transfer.



Having Quality attribute to InventoryTransfer entity is reasonable since we
may have an approval process before actual transfer.



User doing inventory transfer can have an Shipment option to enable
shipment.



When inventory transfer is approval and Shipment option is selected, a
corresponding Sales Order (SO) and Purchase Order (PO) will be created.



You may want to use a different Order Type for these transfer SO & PO.



No direct changes are allowed for transfer SO & PO. Changes can only be
made at ITH and the associated Inventory Transfer entities.



There should be an attribute in SO & PO to link to ITH.



There is also a need to enhance the reservation function of SO to specify
the inventory item id for reservation.



Regards,

James Yong



On 2017-10-16 23:05, Vaibhav Jain  wrote:

> Hello Swapnil/James,

>

> There are many dependencies of inventory transfer in Business

> Requirements

> like:

>

>1. In Inventory transfer generally, there is more than one product in

>any inventory transfer.

>2. Inventory transfer should have an association 

buildbot failure in on ofbiz-trunk-framework-plugins

[buildbot]

The Buildbot has detected a new failure on builder 
ofbiz-trunk-framework-plugins while building . Full details are available at:
https://ci.apache.org/builders/ofbiz-trunk-framework-plugins/builds/591

Buildbot URL: https://ci.apache.org/

Buildslave for this Build: orcus_ubuntu

Build Reason: The AnyBranchScheduler scheduler named 
'on-ofbiz-framework-commit' triggered this build
Build Source Stamp: [branch ofbiz/ofbiz-framework/trunk] 1812609
Blamelist: jleroux

BUILD FAILED: failed shell_4

Sincerely,
 -The Buildbot

buildbot success in on ofbiz-trunk-framework-plugins

[buildbot]

The Buildbot has detected a restored build on builder 
ofbiz-trunk-framework-plugins while building . Full details are available at:
https://ci.apache.org/builders/ofbiz-trunk-framework-plugins/builds/592

Buildbot URL: https://ci.apache.org/

Buildslave for this Build: silvanus_ubuntu

Build Reason: The AnyBranchScheduler scheduler named 
'on-ofbiz-framework-commit' triggered this build
Build Source Stamp: [branch ofbiz/ofbiz-framework/trunk] 1812612
Blamelist: jleroux

Build succeeded!

Sincerely,
 -The Buildbot