SCENARIO :
Goods Received Notes shows blank Transfer to, but then still showing Transferred
SOLUTION:
Please Execute Below Script, to find all transactions which have similar issue.
Script:
select GD.Transferred , G.Transfertoinfo,G.GoodsReceivedNoteCode from GoodsReceivedNoteDetails GD
Join GoodsReceivedNotes G
ON GD.GoodsReceivedNoteId=G.id
where GoodsReceivedNoteId in (select id from GoodsReceivedNotes G where TransferToInfo ='' or TransferToInfo is null)
and transferred != 0
order by G.GoodsReceivedNoteCode asc
Note: This Script will list out all GRN which have similar issue, user may need to record down this two transactions code.
Please Execute Below Script, to find all transaction which still capture Transfer link in table Purchasetransferlink.
Script:
Select PT.Id, GD.Transferred, G.GoodsReceivedNoteCode from purchasetransferlink PT
join GoodsReceivedNoteDetails GD
ON PT.GoodsReceivedNoteDetail = GD.Id
Left JOIN GoodsReceivedNotes G
ON GD.GoodsReceivedNoteId = G.id
where GD.GoodsReceivedNoteId in (Select id from GoodsReceivedNotes where TransferToInfo = '' or TransferToInfo is null)
and GD.Transferred !=0
order by G.GoodsReceivedNoteCode asc
Please Execute 1st script to remove Transferlink in PurchaseTransferlink Table.
Script:
---1st
delete PT
from purchasetransferlink PT
join GoodsReceivedNoteDetails GD
ON PT.GoodsReceivedNoteDetail = GD.Id
Left JOIN GoodsReceivedNotes G
ON GD.GoodsReceivedNoteId = G.id
where GD.GoodsReceivedNoteId in (Select id from GoodsReceivedNotes where TransferToInfo = '' or TransferToInfo is null)
and GD.Transferred !=0
Then execute second script to correction the Transferred Column in GRN details Table.
Script:
---2nd
update GD set transferred = 0
from GoodsReceivedNoteDetails GD
Join GoodsReceivedNotes G
ON GD.GoodsReceivedNoteId=G.id
where GoodsReceivedNoteId in (select id from GoodsReceivedNotes G where TransferToInfo ='' or TransferToInfo is null)
and transferred != 0
Result:
No more showing 'Transferred'
