Finance | Project Operations, Human Resources, ...

Data is not showing in table browser but in SQL

(0) Share

Report

Posted on by irfan sial

116

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.

All responses (4)

Answers (0)

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.
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/.../
Suggested answer

nmaenpaa 101,156 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.
Suggested answer

Gunjan Bhattachayya 35,421 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.