I would appreciate your insights regarding a scenario in Dynamics 365 F&O – Retail (Commerce) related to the Business Day configuration.
In the Store setup, there is a parameter called “Post as a business day”, along with another related parameter “End of business day.”
In this field, I set the value to 02:00 AM, which means the store’s business day should end at 2:00 AM.
To test this scenario, I performed several transactions across two dates, for example: 31-05 and 01-06. However, the transactions performed on the new calendar day (01-06) were before 02:00 AM.
The sales was :
For example:
- Sales on 31-05 = $1000
- Sales during the first two hours of 01-06 (before 02:00 AM) = $100
After that, the following steps were completed:
- The shift was closed
- Data was synchronized from POS to Back Office
But in other hand , I reviewed the Retai & Commerce Reports such as :
- Store transactions
- Store Sales
- Channel summary report
- Organization Summary Report.
- 31-05 → $1000
- 01-06 → $100
In the reports, the results should appear as:
- 31-05 → $1100
Therefore, I have two questions:
1️⃣ Is anyone faced this issue before , as The default should be based on Business date not based on Calendar date
2️⃣ Regarding GL posting, will the sales be posted based on the calendar date (i.e., $1000 for 31-05 and $100 for 01-06), or will they be posted as $1100 under 31-05 based on the Business Day configuration?
Any insights, recommendations, or best practices from your experience would be highly appreciated.
Thank you in advance.

Report
All responses (
Answers (