Description |
Version: 17.3.1130.
Database: 01
Steps to Recreate:
1. Bring up TR-64.
2. Post.
Issue: Error message Negative Quantity not allowed for the location.
This is a transport load, the receipt detail matches the distribution. The item is not going negative.
Same issue for
Tr-52
Tr-61
Tr-63
Tr-64
h1. *Investigation from IC-4630:*
There is a bug in Transport where it is creating duplicate transfers. These duplicate transfers are the ones causing the negative stock.
!pastedImage_d88036_0.png! !pastedImage_d88036_1.png!
!pastedImage_d88036_2.png! !pastedImage_d88036_3.png!
[~lawrence.zabala] ,
Please use the query below. There are several more transfers that is having the same issue. I can fix the following transfers. A data fix can unpost all of these transfers. However, please find out and fix how does transport load is doing the duplicate transfers.
{quote} {{SELECT }}
{{th.strTransferNo}}
{{, td.intItemId}}
{{, td.intSourceId}}
{{, expectedLH.strTransaction}}
{{FROM }}
{{tblICInventoryTransfer th}}
{{INNER JOIN tblICInventoryTransferDetail td}}
{{ON th.intInventoryTransferId = td.intInventoryTransferId}}
{{LEFT JOIN tblTRLoadReceipt lr}}
{{ON lr.intInventoryTransferId = th.intInventoryTransferId}}
{{LEFT JOIN ( }}
{{tblTRLoadHeader expectedLH INNER JOIN tblTRLoadReceipt expectedLR}}
{{ON expectedLH.intLoadHeaderId = expectedLR.intLoadHeaderId}}
{{)}}
{{ON expectedLR.intLoadReceiptId = td.intSourceId}}
{{WHERE }}
{{th.intSourceType = 3}}
{{AND lr.intInventoryTransferId IS NULL}}
{{AND td.intSourceId IS NOT NULL}}
{{AND th.ysnPosted = 1}}
{quote}
|