Transfer 2 step receipt still showing quantity in transit state after receipt is released

​@muralir  this answer generated with the help of AI hope its helpful.

The issue you’re facing suggests that the inventory transfer process was not fully completed, leaving the quantities stuck in transit. Since manually deleting records from INItemPlan and INTransitLine did not resolve the issue, here are some steps to properly fix it:

1. Verify the Transfer Process Status
Check the Transfer Order related to the Purchase Receipt:
Navigate to Inventory → Transactions → Transfer Orders.
Locate the related Transfer Order and ensure it has been received properly.
If it is still in transit, proceed with receiving it.
2. Manually Process the Transfer Receipt
Go to Inventory → Transactions → Process Transfer Receipts.
If the transfer is pending, manually create and release a Transfer Receipt to complete the movement.
3. Check the INIssues and INReceipts Tables
Run a SQL query to verify if the system has recorded the transfer issue but not the receipt:

sql

CopyEdit

SELECT * FROM INIssue WHERE RefNbr = 'TRANSFER_DOC_NUMBER'; SELECT * FROM INReceipt WHERE RefNbr = 'PURCHASE_RECEIPT_DOC_NUMBER';

If the INIssue exists but not the INReceipt, manually enter an Inventory Receipt to reflect the received quantity.
4. Adjust the Inventory with an Adjustment
If the transfer is not updating correctly, create an Inventory Adjustment:
Navigate to Inventory → Transactions → Inventory Adjustments.
Manually adjust the quantity in the destination warehouse.
5. Run Inventory Integrity Check
Go to System → Data Integrity → Validate Inventory Transactions.
Run the process to identify and correct inconsistencies in inventory balances.