How to reclass items which are trapped in "In Transit" location

indypuspita
Member Posts: 6
Dear Mibuso Forum,
I have been facing for the items which are trapped in "In Transit" location.
We have got report from our client, that they found their Transfer Order Receipt was gone. After some checkings, we found that Transfer Order was deleted already, Transfer Shipment was posted first, it affected those items were parked in "In Transit" location, but never can be posted for the receipt because its Trasnfer Order was deleted.
my assumption is, it might because user canceled when the posting receipt was in process, and Nav failed to get the roll back, thus it ended up with "Transfer Order" was deleted, while "Transfer Receipt" was not created yet.
Kindly please, if you ever have the same case, or might share your idea, how to release out those items from "In Transit" location, as I have tried to do Item Reclass, but Nav could not process for item in "In Transit" location.
this case uses NAV 2013R2 version.
Thanks for y'all help.
Indriani
I have been facing for the items which are trapped in "In Transit" location.
We have got report from our client, that they found their Transfer Order Receipt was gone. After some checkings, we found that Transfer Order was deleted already, Transfer Shipment was posted first, it affected those items were parked in "In Transit" location, but never can be posted for the receipt because its Trasnfer Order was deleted.
my assumption is, it might because user canceled when the posting receipt was in process, and Nav failed to get the roll back, thus it ended up with "Transfer Order" was deleted, while "Transfer Receipt" was not created yet.
Kindly please, if you ever have the same case, or might share your idea, how to release out those items from "In Transit" location, as I have tried to do Item Reclass, but Nav could not process for item in "In Transit" location.
this case uses NAV 2013R2 version.
Thanks for y'all help.
Indriani
0
Best Answers
-
To get the items out of the In-Transit location you could do the following (make sure others are not posting Transfer orders at the time though)...
1) Untick the "Use As In-Transit" field on the Location card for the In-Transit location
2) Create & Post a Reclass journal - make sure you apply to the correct Item Ledger Entries i.e. the ones for the deleted Transfer Order. If you don't do this then the system could apply against other Item Ledger Entries that may be sitting in the In-Transit location for other Transfer Orders - this would then cause a problem when trying to post the Transfer Shipment for those Transfer Orders.
3) Tick the "Use As In-Transit" field again on the Location card for the In-Transit location6 -
Yes, there's a saftety block in that if any Transfer Orders exist with the location code set as the In-Transit code then you can't untick it.
The quick workaround is to run the Location table (14) from the Development Environment and untick the field directly from the Table instead of the Location Card page. Remember to tick it back again and make sure no-one is working with Transfer Orders in the meantime.5
Answers
-
To get the items out of the In-Transit location you could do the following (make sure others are not posting Transfer orders at the time though)...
1) Untick the "Use As In-Transit" field on the Location card for the In-Transit location
2) Create & Post a Reclass journal - make sure you apply to the correct Item Ledger Entries i.e. the ones for the deleted Transfer Order. If you don't do this then the system could apply against other Item Ledger Entries that may be sitting in the In-Transit location for other Transfer Orders - this would then cause a problem when trying to post the Transfer Shipment for those Transfer Orders.
3) Tick the "Use As In-Transit" field again on the Location card for the In-Transit location6 -
Hi Kishorm,
Many thanks for your solutions, but I got an issue, which is the "Use As In-Transit" could not be "Unthick" even in Cronus..
Please help me on this.
Thanks,
Indriani0 -
Yes, there's a saftety block in that if any Transfer Orders exist with the location code set as the In-Transit code then you can't untick it.
The quick workaround is to run the Location table (14) from the Development Environment and untick the field directly from the Table instead of the Location Card page. Remember to tick it back again and make sure no-one is working with Transfer Orders in the meantime.5 -
many thanks for your help and advice Kishorm, finally it is solved0
-
[Topic moved from 'Navision Financials' forum to 'NAV Three Tier' forum]
Regards,Alain Krikilion
No PM,please use the forum. || May the <SOLVED>-attribute be in your title!0 -
To get the items out of the In-Transit location you could do the following (make sure others are not posting Transfer orders at the time though)...
1) Untick the "Use As In-Transit" field on the Location card for the In-Transit location
2) Create & Post a Reclass journal - make sure you apply to the correct Item Ledger Entries i.e. the ones for the deleted Transfer Order. If you don't do this then the system could apply against other Item Ledger Entries that may be sitting in the In-Transit location for other Transfer Orders - this would then cause a problem when trying to post the Transfer Shipment for those Transfer Orders.
3) Tick the "Use As In-Transit" field again on the Location card for the In-Transit location
0 -
To get the items out of the In-Transit location you could do the following (make sure others are not posting Transfer orders at the time though)...
1) Untick the "Use As In-Transit" field on the Location card for the In-Transit location
2) Create & Post a Reclass journal - make sure you apply to the correct Item Ledger Entries i.e. the ones for the deleted Transfer Order. If you don't do this then the system could apply against other Item Ledger Entries that may be sitting in the In-Transit location for other Transfer Orders - this would then cause a problem when trying to post the Transfer Shipment for those Transfer Orders.
3) Tick the "Use As In-Transit" field again on the Location card for the In-Transit location
Though you posted this more than 5 years ago, it helped me even today. Many thanks!0
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.6K Microsoft Dynamics NAV
- 18.7K NAV Three Tier
- 38.4K NAV/Navision Classic Client
- 3.6K Navision Attain
- 2.4K Navision Financials
- 116 Navision DOS
- 851 Navision e-Commerce
- 1K NAV Tips & Tricks
- 772 NAV Dutch speaking only
- 617 NAV Courses, Exams & Certification
- 2K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 320 Dynamics CRM
- 111 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 990 SQL General
- 383 SQL Performance
- 34 SQL Tips & Tricks
- 35 Design Patterns (General & Best Practices)
- 1 Architectural Patterns
- 10 Design Patterns
- 5 Implementation Patterns
- 53 3rd Party Products, Services & Events
- 1.6K General
- 1.1K General Chat
- 1.6K Website
- 83 Testing
- 1.2K Download section
- 23 How Tos section
- 252 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions