Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Commerce forum / Dates in Retail Transa...
Commerce forum

Dates in Retail Transaction table, Sale Table and Sale Line

(0) ShareShare
ReportReport
Posted on by Haribaskar 56

Hi all,

I have an doubt in dates, which are the dates need to take for report from sales table, Sales line and Retail Transaction Table. 

I have checked the dates in these three tables, But I faced one issue on this. 

1. Sales table - createddate -taken

2. Sales Line - createddate -taken

3. Retail Transaction Table - Transdate -Taken

But, I have checked datas the tables in SQL. The Salestable and Salesline dates are same for same sale order id , But in the retailtransactiontable, the trans date shows wrong date. (which means Retailtransactiontable transdate='24-06-2019' but in Salestable and salesline the createddatetime is '23-06-2019').  what may be the problem?

Categories:
Other
Point-of-sale Functionality
  • Suggested answer
    Algie67 Profile Picture
    Algie67 90 on at
    RE: Dates in Retail Transaction table, Sale Table and Sale Line

    Couple of thoughts,

    I think I have seen a hot fix about this recently relating to modes of delivery in pos coming out plus one day. Think the fix is in 10.0.3

    Also check that the legal entity timezone setting is exactly the same as the store timezone beyond the point on business day. This has an effect as well.

  • Suggested answer
    Shafeeque P. Profile Picture
    Shafeeque P. 6,512 Super User 2024 Season 2 on at
    RE: Dates in Retail Transaction table, Sale Table and Sale Line

    Can you confirm if the Post as Business Day is check in Retail store setup for the store you are facing the issue ? Also confirm, what is the date you see in the business date field on RetailTransactiontable ? Please refer the attached link below to understand how posting date change based on the business date setup.

    cloudblogs.microsoft.com/.../retail-store-post-as-business-day-function-for-end-of-day-posting

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

November Spotlight Star - Khushbu Rajvi

Congratulations to a top community star!

Forum Structure Changes Coming on 11/8!

In our never-ending quest to help the Dynamics 365 Community members get answers faster …

Dynamics 365 Community Platform update – Oct 28

Welcome to the next edition of the Community Platform Update. This is a status …

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,280 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,214 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans