[AX 2012 R3] Runtime Error in WHERE-clause "Parameter is incorrect"

(0) Share

Report

Posted on by Community Member

Hi everyone,

i run into a runtime error with the following WHERE-clause. Do you have any idea how to solve this? Aim is to get all the orders that are older than "expirationDays".

It works if i shift the red marked condition into the loop but thats very ineffective i think.

5488.pic1.png

Regards

Nils

*This post is locked for comments

I have the same question (0)

All responses (7)

Answers (1)

Verified answer

André Arnaud de Cal... 301,075 Super User 2025 Season 2 on at

Like (1)

Report

Hi Nils,

You can't use the today()- transferTable.Shipdate.

You can create a new variable called e.g. dueDate and calulate a date based on today() and expiration days. Then you can do a where clause comparing the Shipdate with the dueDate.

Was this reply helpful? Yes No
Sohaib Cheema 49,438 User Group Leader on at

Like (0)

Report

if nothing works as calculated field, last approach can be to replace line of where clause with If condition inside { }

Of course seems a stupid approach, but needed sometimes in AX.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
Hi Andre,

thank you...works like a charm.

public void adjustExpiredTransferOrders(KVHandleUnsatisfiedOrdersDataContract _dataContract) { InventTransferTable transferTable; InventTransferLine transferLine; WHSInventTransferLine whsTransferLine; date dueDate; dueDate = today() - _dataContract.parmExpirationDays(); ttsBegin; while select * from transferTable where transferTable.ShipDate < dueDate && transferTable.TransferStatus == InventTransferStatus::Created join forUpdate * from transferLine where transferLine.TransferId == transferTable.TransferId join whsTransferLine where whsTransferLine.InventTransferLine == transferLine.RecId && whsTransferLine.ReleasedQty < transferLine.QtyRemainShip && whsTransferLine.OnWave == NoYes::No { transferLine.QtyRemainShip = 0.0; transferLine.updateDeliverRemainder(); } ttsCommit; }

Regards Nils

Was this reply helpful? Yes No
Jesus R. ABASCAL 1,450 on at

Like (0)

Report

I aggree with Sohaib you should verify it with if condition.

Was this reply helpful? Yes No
Sohaib Cheema 49,438 User Group Leader on at

Like (0)

Report

Jesús R. Abascal ,

if condition only needed when we are out of all options for creating a query and joins are very complex

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Thanks for your efforts. I think Andre's approach is the most elegant.

Was this reply helpful? Yes No
Sohaib Cheema 49,438 User Group Leader on at

Like (0)

Report

Nils Kuttkat,

yes I agree with you

Was this reply helpful? Yes No