ofbiz-notifications mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Deepak Dixit (JIRA)" <j...@apache.org>
Subject [jira] [Updated] (OFBIZ-9464) Accounting quantity transfer should not be zero while transferring inventory from one facility to another
Date Sat, 08 Jul 2017 17:23:00 GMT

     [ https://issues.apache.org/jira/browse/OFBIZ-9464?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]

Deepak Dixit updated OFBIZ-9464:
--------------------------------
    Fix Version/s:     (was: Upcoming Release)
                   16.11.04

> Accounting quantity transfer should not be zero while transferring inventory from one
facility to another
> ---------------------------------------------------------------------------------------------------------
>
>                 Key: OFBIZ-9464
>                 URL: https://issues.apache.org/jira/browse/OFBIZ-9464
>             Project: OFBiz
>          Issue Type: Bug
>    Affects Versions: Trunk
>            Reporter: Vaibhav Jain
>            Assignee: Divesh Dutta
>             Fix For: 16.11.04
>
>         Attachments: OFBIZ_9464.patch
>
>
> when we transfer inventory, the accountingQuantityTotal field of _InventoryItem_ entity
is always ZERO. There is no reflection of ATP/QOH in accountingQuantityTotal.
> This will create following issues in the system.
> # Accounting quantity total will mismatch with the original quantity in the facility
which shows the wrong result when we calculate facility specific inventory valuation.
> # Inventory reservation also throws an error in some specific case like when AQT of respective
product is zero in the specific facility from when reservation happens.
> As we manage 5 different statuses of inventory transfer in OFBiz and according to my
current understanding these processes are associated with the respective statuses, which are
as show below
> Requested: As inventory transfer is requested for another facility. 
> a)ATP, QOH and AQT should decrease from the inventory item of From Facility and QOH of
To Facility should increase.
> b)ATP and AQT should be Zero in To Facility as inventory is not transferred yet. But
QOH should increase at To Facility because QOH shows the xferquantity later. At the time of
the completion of the transfer
> ATP = ATP + (QOH - ATP) (Adjustment in case of backorder)
> AQT = QOH
> b)AQT should not decrease because AQT is used for accounting purpose and as of now quantity
is still in From Facility as the transfer is not done yet. which shows the xferQuantity later

> Scheduled: As inventory transfer is Scheduled for another facility. ATP, QOH and AQT
should not affect in both From Facility and To Facility.
> En-route: As inventory is routed to reach at To Facility. Even in this case ATP, QOH
and AQT should not affect in both From Facility and To Facility.
> Complete: As inventory transfer is completed 
> a)ATP, QOH and AQT should not affect at From Facility. 
> b)QOH will be same but ATP and AQT should affect respectively
> ATP = ATP + (QOH - ATP)
> AQT = QOH
> Cancelled: As inventory transfer is cancelled and inventory item record is already created
 so 
> a) ATP, QOH and AQT should decrease from old inventory item and ATP, QOH and AQT should
increase in the newly created inventory item.
> Key points: 
> If the whole ATP and QOH is moved then new inventory item will not create. Only Facility
and location are changed for existing inventory item.
> Before Changes:-
> As I know there are following processes are associated with respective statuses 
> **Note:   ATP-> Available to promise    QOH-> Quantity on hand    AQT-> Accounting
quantity total
> 1. Requested:-
>     ATP =0                                        QOH=Transferred quantity       AQT=0
> 2. Scheduled:-
>     ATP =0                                        QOH=Transferred quantity       AQT=0
> 3.En-Route:-
>     ATP =0                                        QOH=Transferred quantity       AQT=0
> 4.Complete:-
>     If the partial quantity of any inventory item is transferred.
>     ATP =Transferred quantity       QOH=Transferred quantity       AQT=0
>     If the whole quantity is transferred then only facility id and location will change
no new inventory item record will create. 
> 5.Cancelled:-
>     No new inventory item record will create. An inventory transfer record is created
with whole ATP/QOH in cancelled status.
> After Changes:-
> As shown above, accounting quantity transfer will not affect in transfer inventory. After
the following changes, records will be updated a shown below.
> 1. Requested:-
>     ATP =0                                        QOH=Transferred quantity       AQT=0
> 2. Scheduled:-
>     ATP =0                                        QOH=Transferred quantity       AQT=0
> 3.En-Route:-
>     ATP =0                                        QOH=Transferred quantity       AQT=0
> 4.Complete:-
>     If the partial quantity of any inventory item is transferred.
>     ATP =Transferred quantity       QOH=Transferred quantity       AQT=Transferred quantity
>     If the whole quantity is transferred then only facility id and location will change
no new inventory item record will create. 
> 5.Cancelled:-
>     No new inventory item record will create. An inventory transfer record is created
with whole ATP/QOH in cancelled status.



--
This message was sent by Atlassian JIRA
(v6.4.14#64029)

Mime
View raw message