New to AX - How to create a job to update a table

(0) Share

Report

Posted on by Robert Herrmann

790

I'm new to AX development. I am using AX 2012. I want to create job that will update a field in table ProdRoute. When I do a search on "AX jobs", I get employment jobs! :)

Here is the business logic:

1. Loop thru all ProdRoute rows.

2. Check field QtyGood. If greater than 0 then update boolean field OprFinished = True.

3. If QtyGood is 0, then do nothing.

Seems like this should be easy but I cannot find an example.

*This post is locked for comments

I have the same question (0)

All responses (1)

Answers (1)

Verified answer

Muhammad Afsar Khan 2,676 on at

Like (1)

Report

Here is the code format of solution:

public static updateRoutejb(Args args)

{

ProdRoute ProdRoute ;

while select forupdate ProdRoute

{

if (ProdRoute .QtyGood > 0)

{

ProdRoute.OprFinished = true;

ProdRoute.update();

}

info ("Done");

}

}

Was this reply helpful? Yes No