Why RetailTransactionsTable No Records

(0) Share

Report

Posted on by DYNUser121

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.

I have the same question (0)

All responses (5)

Answers (0)

Mea_ 60,284 on at

Like (1)

Report

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

Was this reply helpful? Yes No
Blue Wang on at

Like (1)

Report

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.

Was this reply helpful? Yes No
DYNUser121 12 on at

Like (0)

Report

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

Was this reply helpful? Yes No
Blue Wang on at

Like (0)

Report

HI DYNUser,

I'm very glad to hear that.

Please verify the answer and close the thread, thanks.

Was this reply helpful? Yes No
DYNUser121 12 on at

Like (0)

Report

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:

Was this reply helpful? Yes No