cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
New Member

Error creating order line in Dynamics 365 for Operations

Hi

 

I am using the Dynamics 365 for Operations - Create record connector to create an order in AX 7. I am able to create SalesOrderHeader record but in the second step when I try to create SalesOrderLines, I get the following error:

Body

{ "status": 400, "message": "Write validation failed for table row of type 'SalesOrderLineEntity'. Infolog: .", "source": "xxxxxxx.cloudax.dynamics.com", "errors": [] }
 
One thing I noticed is the connector does not allow me to pass SalesOrderNumber parameter. Can someone please help with this issue.
 
Thanks
3 REPLIES 3
Highlighted
Community Support
Community Support

Re: Error creating order line in Dynamics 365 for Operations

Hi Mirhassanali,

 

Are you creating a flow with Dynamics 365? For better understanding, could you show me a screenshot of your flow configuration to reproduce this issue?

 

Best regards,
Mabel Mao

Community Support Team _ Mabel Mao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Highlighted
New Member

Re: Error creating order line in Dynamics 365 for Operations

Hi,

 

I think you are unintentionally importing a sales order line without the sales order header. For example, you are importing SO line with salesId "SO-000009" and "SO-000009" doesnt exists in the SalesTable. The reason could also be that you are trying to import SO line in a non-default company without setting the "dataAreaId". Basically if the system couldnt find the SO you are trying to import, it throws this error.

 

Regards

Diwakara

Highlighted
Administrator
Administrator

Re: Error creating order line in Dynamics 365 for Operations

Hey, @mirhassanali!

 

It appears as though @v-yamao-msft would like some more information in order to further assist you properly with your issue. Please share any additional information that was requested in order to decrease the amount of time that it will take for you to be assisted!

 

Thank you for being an active member of the Flow Community!

-Gabriel
Flow Community Manager

- Gabriel
Community Manager
Power Automate | Power Virtual Agents
Super User Program Manager
Power Platform Communities

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Power Platform ISV Studio

Power Platform ISV Studio

ISV Studio is designed to become the go-to Power Platform destination for ISV’s to monitor & manage published applications.

Upcoming Events

Experience what’s next for Power Automate

See the latest Power Automate innovations, updates, and demos from the Microsoft Business Applications Launch Event.

Users online (6,828)