Data is not showing in table browser but in SQL

(0) Share

Report

Posted on by Muhammad Irfan Ayoub

134

Hi folks,

Greetings, when I open the TaxJournaTrans table in the table browser then data is not showing in the table but when I open the table in SQL then it contains data.

Please tell me what is the reason why data is not showing in the table browser.

Many thanks,

Muhammad Irfan Ayoub.

I have the same question (0)

All responses (4)

Answers (0)

Suggested answer

Gunjan Bhattachayya 35,423 on at

Like (0)

Report

RE: Data is not showing in table browser but in SQL

Hi Irfan,

Please check the legal entity selected for the user (who is logged into Visual Studio while opening the table browser) in System admin > users. If there are no records for the legal entity, table browser will show zero records.

Was this reply helpful? Yes No
Suggested answer

nmaenpaa 101,160 Moderator on at

Like (0)

Report

RE: Data is not showing in table browser but in SQL

As Gunjan mentioned, the table browser shows data in the current company context only. So please check your company context.

Was this reply helpful? Yes No
Blue Wang on at

Like (0)

Report
RE: Data is not showing in table browser but in SQL

Hi Muhammad ,

In fact,You can check parameters in your URL, TableName and cmp.

Like:

https://usnconeboxax1aos.cloud.onebox.dynamics.com/?mi=SysTableBrowser&prt=initial&limitednav=true&TableName=SalesTable&cmp=DAT

Meaning of parameters: www.axpulse.com/.../

Was this reply helpful? Yes No
Suggested answer

Pratik Srivastava 2 on at

Like (0)

Report

Data is not showing in table browser but in SQL

Please do the complete DB sync. It will reflect the data.

Was this reply helpful? Yes No