Supply chain | Supply Chain Management, Commerce

Handling Statement Posting Dates in D365 Commerce for Closed Periods

(1) Share

Report

Posted on by MPOS Activation

Hi everyone,

I’m looking for some insights regarding Dynamics 365 F&O - Commerce statement posting.

I have a client who uses manual statement creation (Trickle feed is not enabled). We have a scenario where POS transactions occurred on April 15th, but the fiscal period for that date is already closed in the back end.

We need the resulting Sales Orders to impact the back end (both Physical and Financial transactions) on April 19th instead of the original transaction date (April 15th).

Is there a standard way to override the posting date during the statement calculation or posting process to ensure it hits the open period? Or does this require a specific configuration in the functional profile/store settings?

Looking forward to your expert advice!

Categories:

Dynamics 365 Commerce

I have the same question (0)

All responses (6)

Answers (0)

Sort by

Daniel Carter 14 on at

Like (0)

Report
Copy link

Link copied!

In standard D365 Commerce, the posting date for statements is typically derived from the statement configuration and the transaction date, and there is no direct out-of-the-box option to override it arbitrarily during posting.

However, to handle closed fiscal periods, you can control this behavior through statement posting settings and financial period validation. In such cases, the system generally requires either:

Reopening the closed fiscal period or Configuring posting to occur in the next available open period, depending on your financial controls.

Additionally, you should review the store parameters, posting profiles, and date validation logic, as these influence how sales orders and financial postings are generated from statements.

If overriding the posting date (e.g., forcing April 19 instead of April 15) is a strict requirement, it may require customization or extension, as standard functionality has limited flexibility in this area.

Was this reply helpful? Yes No
MPOS Activation 25 on at

Like (1)

Report
Copy link

Link copied!

Thanks @ Daniel Carter for your reply, but I have more Question , If there a method or parameter in Retail & Commerce to receive the sales order which create from the store as an open Sales order not Invoiced " in case the Statement is succeeded" .

Thanks in advance

Was this reply helpful? Yes No
André Arnaud de Cal... 304,713 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi MPOS Activation,

The scenario you mentioned should not occur. No company should close the fiscal period in case retail postings are not processed.
As far as I'm aware, there is no parameter to control the posting date. My suggestion is to reopen the period and start the period closing again.

Was this reply helpful? Yes No
Suggested answer

Daniel Carter 14 on at

Like (0)

Report
Copy link

Link copied!

Hi @MPOS Activation
In standard D365 Commerce, once the statement is successfully posted, the system automatically creates and invoices the related sales orders as part of the default workflow.

There isn’t an out-of-the-box parameter to receive those sales orders as open (not invoiced) after statement posting, as invoicing is tightly linked to the posting process itself.

If this is a strict requirement, it would typically need a change in process design or customization, since standard functionality doesn’t provide that level of control.

Was this reply helpful? Yes No
Suggested answer

Danyal Imtiaz Khan 45 on at

Like (0)

Report
Copy link

Link copied!

@MPOS Activation You have to reopen the closed financial period for sales order posting and this will resolve the issue for you. And posting dates are derived from the processing of statement posting and the transaction date so this cannot be manually changed in OOTB process of Microsoft d365.

Was this reply helpful? Yes No
Martin Luks XLN 32 on at

Like (0)

Report
Copy link

Link copied!

There are two entities available on the statement that let you edit the transactions in it - Edit cash and carry transactions and Edit cash management transactions. If you are in a situation that the statement posting failed because of closed period, you can use those to fix the date.

Normally Business date is determining to which date the transaction is posted.

Was this reply helpful? Yes No