Route Version via a job in Dynamics Ax 2009

25 Jul

static void NewRouteVersion(Args _args)
RouteId             fromId,newId,routeId;
InventSiteId        siteId;
InventDim           inventDim;
RouteVersion        routeVersion,routeVersionNew;
InventTable         inventTable;
ItemId              itemId;
ConfigId            configId;
RouteTable          routeTable;
Route               tmpRoute;
RouteOpr            routeOpr;
Route               route;
RouteOpr            tmpRouteOpr;
RecId               RecId;

RouteVersion        locrouteVersion;
int                            i,len;
str                           s;

Select routeVersion where routeVersion.ItemId == “1101”
&&(routeVersion.Approved == Noyes::Yes
&& routeVersion.Active == Noyes::Yes) ;
if (routeVersion)
fromId      = routeVersion.RouteId;
newId       = fromId + “/15” ;

select locrouteVersion
order by RouteId desc
where locrouteVersion.ItemId == routeVersion.ItemId;
len = strlen(locrouteVersion.RouteId);
i = strscan(locrouteVersion.RouteId,’/’,1,len);

s = substr(locrouteVersion.RouteId,i+1,len);
if(s == “”)
newId = fromId + ‘/01’;
i = str2int(s) + 1;
newId = fromId + ‘/’ + int2str(i);

        routeId     = newid;
itemId      = routeVersion.ItemId;
configId    = configId;
siteId      = routeVersion.inventSiteId();
routeVersionNew.Approved   = false;
routeVersionNew.Active     = false;
routeVersionNew.ApprovedBy = “”;
routeVersionNew.RouteId    = newId;
while select routeTable where routeTable.RouteId == fromId
while select tmpRoute
where   tmpRoute.RouteId == fromId
route           =;
route.RecId = 0;
route.RouteId   = newId;
while select tmpRouteOpr
where tmpRouteOpr.RouteRelation == newId
routeOpr                =;
routeOpr.RecId = 0;
routeOpr.RouteRelation   = newId;

Leave a comment

Posted by on July 25, 2011 in X++



Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

All About Dynamics 365

Dynamics 365, D365, Implementor

Syed Rafay Ali

This blog contains information about Functional techniques and guidelines in Microsoft Dynamics AX, including tips, tricks, tutorials, tools and upcoming news enhancement in Microsoft Dynamics Ax

Philippsen's Blog

Everyday findings in my world of .net and related stuff

Microsoft Dynamics AX

A great site

Finite Minds

Adventures in IoT

Dynamics Ax

Technical Knowledge


A blog about implementing Microsoft Dynamics AX and Dynamics 365 for Operations

Microsoft Dynamics 365 Blog

"Learn it all, not Know it all" in Dynamics 365 - Enterprise Edition, A Blog by Sandeep Chaudhury

DEVSerra - Dynamics AX development blog

Your official Microsoft Dynamics AX blog.


Discovering Dynamics


A blog by Hai Nguyen

Learn Dynamics Ax with Johnkrish

Live as if you were to die tomorrow. Learn as if you were to live forever - Mahatma Gandhi ****** The more I learn, the less I know - Albert Einstein

Twisted Untwirled

Just another site


Just another site

guyterry's Dynamics AX blog

Just another Dynamics AX blog

%d bloggers like this: