power automate flow error due date is before ending date

(3) Share

Report

Posted on by CU15010506-0

I wanted to create an assembly order from a purchase order using power automate flow. I got error, due date is before ending date.

There was no error when I manually created an assembly order with the same item for the testing purchase.

When executing the flow, I got due date is before ending date error.

Input .

{

    "host": {
        "connectionReferenceName": "shared_dynamicssmbsaas",
        "operationId": "PostItemV3"
    },
    "parameters": {
        "bcenvironment": "SANDBOX-1",
        "company": "xxxxxxx",
        "dataset": "xxxxx",
        "table": "assembly_Headers",
        "item/itemno_": "1005",
        "item/startingdate": "2025-01-12T04:37:56.1596442Z",
        "item/endingdate": "2025-01-12T04:37:56.1596580Z",
        "item/quantity": 1
    }
}

output

"body": {
        "status": 400,
        "message": "ErrorCode: Application_DialogException  Due Date  is before Ending Date 01/14/25.  CorrelationId:  xxxxx.\r\nclientRequestId: xxxx",
        "error": {
            "message": "ErrorCode: Application_DialogException  Due Date  is before Ending Date 01/14/25.  CorrelationId:  xxx"
        },
        "source": "api.businesscentral.dynamics.com",
        "errors": []
    }
 
Is there anyway to turn off the date validation ? Or other solutions ?

Categories:

Dynamics 365 Business Central

I have the same question (0)

All responses (4)

Answers (1)

KasparsSemjonovs 4,782 Super User 2025 Season 2 on at

Like (0)

Report

I would assume the error is because You are not providing any value for the Due Date.
When doing it manually, it gets filled in, but if You are just pushing values, then You cannot process the Confirmation dialogs.

Was this reply helpful? Yes No
Verified answer

Inkey Solutions 2,100 on at

Like (1)

Report

I think this error is not from the Power Automate flow; this error is from Business Central.
you should check the purchase order. The error could be related to the dates in the purchase order, particularly if the due date is set before the ending date. Business Central enforces date validation, so verifying and correcting the dates in the purchase order may resolve the issue.
When manually creating the assembly order, it might automatically adjust these dates, but in Power Automate, those validations might not be applied the same way

Was this reply helpful? Yes No
Suggested answer

Khushbu Rajvi. 20,838 Super User 2025 Season 2 on at

Like (1)

Report

If it helps: https://community.dynamics.com/forums/thread/details/?threadid=828f4d17-6672-ee11-9ae7-00224827e220

Was this reply helpful? Yes No
CU15010506-0 30 on at

Like (1)

Report

I created a blank assesmbly_header with no dates, then created an update to the assembly_header with due date, ending date and item. It worked.

Was this reply helpful? Yes No