operand types are not compatible with the operator

(0) Share

Report

Posted on by Community Member

Hi everyone,

I occasionaly create job that's why i'm not familiar with this type of error, could you please help me ?

public static void LAF_Update_Sales_Orders(Args _args)
{


SalesTable           SalesTable;
int CPT;

ttsBegin ;

while select forUpdate SalesTable where
                        SalesTable.SettleVoucher == "Open transactions"
                        && SalesTable.Salesstatus == "Open Order"


{
    SalesTable.SettleVoucher = None
    CPT = CPT+1;
}

ttsCommit ;

    info(strfmt("fin du script LAF_Update_Sales_Orders '%1'", CPT));

}

Thanks !

*This post is locked for comments

I have the same question (0)

All responses (5)

Answers (1)

Suggested answer

Martin Dráb 237,939 Most Valuable Professional on at

Like (1)

Report

Please don't forget next time to mention which line of code is throwing the error.

Fortunately I see the bug - it's salesTable.SalesStatus == "Open Order".

SalesStatus is an enum field and comparing enums with strings isn't allowed. Use an enum value instead: salesTable.SalesStatus == SalesStatus::Backorder.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Hi Martin,

Thanks for your answer, i will pay attention next time.

One last question, how am i supposed to find the value of the enums SalesStatus::Backorder ?

Thanks again

Was this reply helpful? Yes No
Verified answer

Martin Dráb 237,939 Most Valuable Professional on at

Like (1)

Report

If you want to work with SalesStatus field of SalesTable, open the table in AOT and look at the field. You'll see that in this case, it doesn't have any Extended Data Type, but it has Enum Type == SalesStatus. Then you can find this enum type under Data Dictionary > Base Enums in AOT and see which elements it has.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Thanks a lot !

Was this reply helpful? Yes No
Suggested answer

Community Member on at

Like (0)

Report

The final code :

public static void LAF_Update_Sales_Orders(Args _args)

{

SalesTable SalesTable;

int CPT;

ttsBegin ;

while select forUpdate SalesTable where

SalesTable.SettleVoucher == SettlementType::OpenTransact

&& SalesTable.Salesstatus == SalesStatus::Backorder

{

SalesTable.SettleVoucher = SettlementType::None;

CPT = CPT+1;

}

ttsCommit ;

info(strfmt("fin du script LAF_Update_Sales_Orders '%1'", CPT));

}

Was this reply helpful? Yes No

Community site session details

operand types are not compatible with the operator

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

Featured topics

Product updates

Community site session details

operand types are not compatible with the operator

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Subscribe to this forum!

Select categories

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

Featured topics

Product updates