Skip to main content

Notifications

Supply chain | Supply Chain Management, Commerce
Unanswered

Latest records are displaying in database of UAT

Posted on by 392
Hello All,
 
We are trying to check the latest transaction records in the ax.RetailTransactionSalesTrans table by accessing UAT database in the development environment. Unfortunately we are not accessing the latest data in sql. It is showing till 2019 data but when we search in the Show Journal of POS, we are able to see the 2023 data. 
 
Also, when we are trying to access the SQL server profiler of UAT in dev environment, we are getting below error mentioned in the screenshot.
 
 
Could you please let us know why this issue is occurring? 
 
Thanks in Advance...
  • Suggested answer
    Shafeeque P. Profile Picture
    Shafeeque P. 6,508 Super User 2024 Season 2 on at
    Latest records are displaying in database of UAT
    tables and view in ax and crt schema on HQ AXDB will not hold any data as these are used for the embedded retail servers in the tier 1 box. If you want to see the data, query the axdb  by removing the "ax" prefix from RetailTransactionSalesTrans

    "If my response was helpful, please consider marking it as verified. You'll earn 2 points 🌟, and I'll get 5 points 🙏. Thank you! 😊"
  • Pankaj_93 Profile Picture
    Pankaj_93 392 on at
    Latest records are displaying in database of UAT
     
    Thank you for your response. 
     
    I am not saying that the data is not available in HQ. As per my investigation, the show journal is operating calling the crt.Journaltransactionview to display the receipts in the pos.
    To run a query directly in the sql, i have connected the uat db directly from dev environment using sql authentication. Unfortunately I am not getting the latest data in the transactions tables while it is showing in the pos.
  • Shafeeque P. Profile Picture
    Shafeeque P. 6,508 Super User 2024 Season 2 on at
    Latest records are displaying in database of UAT
    The question is not very clear. If you are saying you can see the new transactions on Show Journal in POS, but not in HQ DB. It could be because the data was not pulled back to FnO. 

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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Community AMA December 12th

Join us as we continue to demystify the Dynamics 365 Contact Center

New! Quick response templatesâš¡

Save time with the new custom templates!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,056 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans