Query is working fine in sql server but not fetching data in ax

(0) Share

Report

Posted on by Shoaib Ashraf

180

Query is working fine in sql server but not in ax, In ax if I execute the query without where cluase it works fine and fetch the first record but on where clause it prints 0.

Below is the attached screenshot for reference. Thanks.

5722.ax.png

8546.sql.png

*This post is locked for comments

I have the same question (0)

All responses (2)

Answers (0)

Suggested answer

Mahmoud Hakim 17,887 on at

Like (0)

Report

Check your legal entity , may be ,this record in anther legal entity

Was this reply helpful? Yes No
Shoaib Ashraf 180 on at

Like (1)

Report

Thank you so much Sukrut Parab,

It worked for me.

Was this reply helpful? Yes No