No route found from ERP error when creating route [LN Interface_GetRouteStepListSql]

Creation date: 11/11/2025 1:18 AM    Updated: 11/27/2025 12:17 AM   #erp #route not found info ln route
When user creating route for a product and when clicking the Validate button then encounter this error.



When this kind of error happens, please check:
1.  If you had just published the route in In, please wait 5-10 minutes for database to get the latest info.
2. If the route version selected status is approved and your current datetime is in between the effective date and expiry date


Example: Unable to find route due to exdt (expiry date) and rost_kw (status)


For support: 
select * from tirou400 with(nolock) where mitm = '         3054999'
select * from tirou401 with(nolock) where mitm = '         3054999' and rorv = '000004'
select * from tirou450 with(nolock) where refo in ('070500030303','071300'',030304','070900','070200')