Description |
Steps:
1. Create Load Out ticket where distribution is Hold and Distribute.
2. Check the item stock tab
Issue:
Qty goes to In Transit Outbound
Acceptance:
Should reflect qty under the Reserved
=============================================================
[~emerson.versoza] , [~matt.wielinski] , and [~ajith.dharan]
In Zeeland - Creston, scale ticket is posting and receiving stocks. I believe scale ticket aren't allowed to do it, except, it should create the IR to receive the stocks.
This will cause stock and gl data issue.
See record below.
!pastedImage_d108626_0.png!
The query below will show all the scale tickets impacting the IC directly. It appears to be In-Transit stocks.
{noformat}select t.strTransactionId
,t.strBatchId
,t.dtmDate
,t.dblQty
,t.dblCost
,t.dblValue
,t.intInTransitSourceLocationId
,t.ysnIsUnposted
,[Transaction Type] = ty.strName
,t.strTransactionForm
from tblICInventoryTransaction t left join tblICInventoryTransactionType ty
on t.intTransactionTypeId = ty.intTransactionTypeId
where t.strTransactionForm = 'Scale Ticket'
and t.ysnIsUnposted = 1
select t.strTransactionId
,t.strBatchId
,t.dtmDate
,t.dblQty
,t.dblCost
,t.dblValue
,t.intInTransitSourceLocationId
,t.ysnIsUnposted
,[Transaction Type] = ty.strName
,t.strTransactionForm
from tblICInventoryTransaction t left join tblICInventoryTransactionType ty
on t.intTransactionTypeId = ty.intTransactionTypeId
where t.strTransactionForm = 'Scale Ticket'
and t.ysnIsUnposted = 0
select SUM(t.dblQty)
from tblICInventoryTransaction t left join tblICInventoryTransactionType ty
on t.intTransactionTypeId = ty.intTransactionTypeId
where t.strTransactionForm = 'Scale Ticket'
and t.ysnIsUnposted = 0 {noformat}
!pastedImage_d108626_1.png!
*Issue:*
* These are not included in the stock rebuild. In the testing today, the in-transit got lost after the stock rebuild.
!pastedImage_d108626_2.png!
* However, I don't know if it should be included in the stock rebuild. I have some concerns:
** The ticket is increasing the in-transit qty but I don't see it reducing the on-hand. Is it an in-transit inbound?
** When does the in-transit qty got reduced? Is it when the scale ticket is received in IR or when converted to Invoice?
** Perhaps I just need to understand why Scale Ticket needs to post in-transit qty.
*** If the ticket status is on-hold, why it needs to put the stock as in-transit? Is the stock really in-transit? If the stock is not going anywhere, can the system do a stock reservation instead of an in-transit?
*Expected:*
Comment out the code that does the in-transit outbound since the requirements are not yet final. The goal is to prevent the code from causing data issue into inventory.
|