Total Pageviews

Search This Blog

Tuesday, October 4, 2011

Returning rowcount using SysTableRowCount Form in Dynamics AX

Accidentally bumped onto this form called SysTableRowCount in Dynamics AX, It's pretty handy to get the recordcount remaining in AX. And, it's there in all the 3 versions of AX: 4.0, 2009 and 2012. Good to know something new.

Alternatively, if you have SSMS (SQL Server Management Studio), you can always fire, select count(*) from <tablename>

1 comment:

Anonymous said...

You can't filter by dataareaid & also for me dataareid shown is incorrect(i have several companies & therefore there are several records for custTable in this form, but all of them show the same company name)