Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Finance | Project Operations, Human Resources, ... / Why RetailTransactions...
Finance | Project Operations, Human Resources, ...
Unanswered

Why RetailTransactionsTable No Records

(0) ShareShare
ReportReport
Posted on by DYNUser121 12

I am doing development in a FinanceOperations project in VS2015, for FMCustomer table, I can right click to it in AOT view and then select Open Table Broswer, it will show me all records in that table. However for RetailTransactionTable, I did the same and in the browser page it opens, it shows empty records and the message displayed is "We did not find anything to show here". I cannot figured out what is the difference between this two table(besides one is from Fleet Management module and the other is from Application Suite). I also looked at the actual table records number, in RetailTransactionTable  there are about 50000 records and the FMCustomer table only has 6 records. I have spent a lot of time to investigate this, but no success yet.

  • DYNUser121 Profile Picture
    DYNUser121 12 on at
    RE: Why RetailTransactionsTable No Records

    Blue Wang, I got the correct results now, and exactly I am using "FRRT". Another thing I am still figuring is I created a Custom Entity against RetailTransactionSalesTran table, and from this custom entity I did an Export in the application's Data Management workspace. However I did not get it fully success, it shows "Partially Succeeded" with 9461 records exported and 7243 errors. I searched over the page UI and cannot find out where is the error details for those errors. And also I checked server side Event Viewer, and there is no error in Event Viewer for SSIS exporting process. I wonder how do I find out what exactly those errors are ? I pasted the screentshot like below:

    pastedimage1591148057646v1.png

  • Blue Wang Profile Picture
    Blue Wang on at
    RE: Why RetailTransactionsTable No Records

    HI DYNUser,

    I'm very glad to hear that.

    Please verify the answer and close the thread, thanks.

  • DYNUser121 Profile Picture
    DYNUser121 12 on at
    RE: Why RetailTransactionsTable No Records

    Yes, thank you for help, I got the correct results now.

  • Blue Wang Profile Picture
    Blue Wang on at
    RE: Why RetailTransactionsTable No Records

    Hi DYNUser,

    If you choose DAT or USMF or other , then it is indeed empty.

    You can simply adjust it to FRRT, then you can see the data.

    4382.PNG

  • Mea_ Profile Picture
    Mea_ 60,278 on at
    RE: Why RetailTransactionsTable No Records

    Check that company you are looking at is correct. Run select statement in SSMS, check dataaireaid value and open table browser in that company. 

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

Daivat Vartak – Community Spotlight

We are honored to recognize Daivat Vartak as our March 2025 Community…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Kudos to the February Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 293,025 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 231,837 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156 Moderator

Leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans