web

You’re offline. This is a read only version of the page.

News and Announcements icon

Dynamics 365 CommunityForums Finance | Project Operations, Human Resources, ... Invalid range value in...

Finance | Project Operations, Human Resources, ...

Unanswered

Invalid range value in AOT Query

(0) Share

Report

Report

Posted on by AnithaEswaran

2,032

Hi ,

I have a weird issue using AOT query range.

Below query lists the sales orders which are not cancelled. If you see the range value below, it is misspelled as ''Cancelled' instead of 'Canceled' .

The query is fetching cancelled sales orders as well in dev and UAT environments , but not in Prod .

On debugging in Dev, it is assigning 255 for the above range value (as the value cancelled doesn`t exist in the system) and it proceeds to fetch the cancelled sales orders.

Why is the behavior different in prod ?

I have the same question (0)

All responses Img

All responses (1)

Answers Img

Answers (0)

André Arnaud de Cal... 305,157 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi Anitha,

I'm not able to answer why something would be different in your production environment. Is the code base exactly the same? As this seem to be related to a customization, I can't verify this in a standard environment.

Was this reply helpful? Yes No

Join the conversation

Helpful resources

Quick Links

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

#1

Giorgio Bonacorsi 797

#2

André Arnaud de Cal... 589 Super User 2026 Season 1

#3

Last 30 days Overall leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

License usage reporting (in-app and PPAC) with Entra dynamic groups

Product updates

Dynamics 365 release plans