Filtering by Sales Order Status from D365 Table

[raoraheel]

How can I go about extracting only orders that have not been invoiced? Extracting all data is not working due to large number of orders and i'm seeing there is a limit of 10k records.

I've tried these but none seem to have worked. Any suggestions will be appreciated. Thanks

ne 3

ne '3'

ne 'Invoiced' 

One of the error is : An error has occurred. A binary operator with incompatible types was detected. Found operand types 'Microsoft.Dynamics.DataEntities.SalesStatus' and 'Edm.String' for operator kind 'NotEqual'.

[krootz · Accepted solution]

@raoraheel  can you try this?

CustomerGroupID eq 'DIRECT' and SalesOrderStatus ne Microsoft.Dyanmics.DataEntities.SalesStatus'Invoiced'

[raoraheel]

@krootz that didn't work. Getting this error when I do that.

An error has occurred. The string 'Microsoft.Dyanmics.DataEntities.SalesStatus'Invoiced'' is not a valid enumeration type constant.
clientRequestId: 57982152-3717-4a38-8e1e-14c3f7e04ba7

[krootz]

@raoraheel  sorry I assumed it was an enum. Is that a lookup?

An error has occurred. A binary operator with incompatible types was detected. Found operand types 'Microsoft.Dynamics.DataEntities.SalesStatus' and 'Edm.String' for operator kind 'NotEqual'.

So I'm not sure. 

[raoraheel]

@krootz it is an enum. This is how my unfiltered data is being extracted right now that i'm trying to limit.

"IsSalesProcessingStopped":"No","SalesOrderStatus":"Invoiced","CustomerGroupId":"Direct" 

[abm · Accepted solution]

Hi @raoraheel 

@krootz  suggestion there was a typo in Dynamics spelling. 

Try using the correct spelling and see if that works.

Thanks

[abm]

Is it  SalesOrderStatus or SalesStatus? Make sure you using the correct field name as well.

[krootz]

@abm good catch! I didn't even notice. 😅

[raoraheel]

@krootz @abm i tried all possible combinations already to see if something might works lol

the entity has it SalesOrderStatus so tried that too.

[raoraheel]

@krootz @abm fixing the typo worked!!! thanks both of you!!!