How to check how many tables are having data in AX

Please is the sql query to get how many tables having data in AX.

SELECT
    t.NAME AS TableName,
    SUM(p.rows) AS [RowCount]
FROM
    sys.tables t
INNER JOIN     
    sys.indexes i ON t.OBJECT_ID = i.object_id
INNER JOIN
    sys.partitions p ON i.object_id = p.OBJECT_ID AND i.index_id = p.index_id
WHERE 
    i.index_id <= 1
GROUP BY
    t.NAME, i.object_id, i.index_id, i.name
ORDER BY
    SUM(p.rows) DESC

How to check how many tables are there in AX

Sometimes people want to know how many tables exist in an AX environment. Since different environments can vary in regards to the number of tables there can be due to customizations and 3rd party software, below is  the job you can copy and paste in a job and run.

In the code, you can modify the '\\' string to do something like count forms '\\Forms' or EDTs '\\Data Dictionary\\Extended Data Types'

I'm aware of the #TablesPath (in #AOT) being used instead of the '\\Data Dictionary\\Tables' string but I wanted to keep this example simple and straight forward.



static void daxCountTablesInAX(Args _args) { // Count of all the tables. info (strFmt("Tables in AX: %1", treenode::findNode('\\Data Dictionary\\Tables').AOTchildNodeCount())); }

Increase EDT Size in AX 365(Dynamics 365 operations)

EDT extension allow us to increase the EDT size instead of customizing it. Once you increase the size,do the compilation of the model and sync the db

This transaction has been marked for settlement by another user in AX

Error : This transaction has been marked for settlement by another user.

Solution:

Go the spectrans table and filter the record with invoice amount(Ex:  -12345.45) and delete it. Then it should works.


@Rahul Talasila

Download AX 365 VHD's

Hi All,

You can now get downloadable VHDs directly through the LCS Shared Asset Library instead of downloading the VHDs from the Connect site. To get a new VHD, click the Download VHDs tab is the Shared Asset library or the Project Asset library. This functionality is available for both Dynamics 365 for Finance and Operations and Dynamics 365 for Retail projects.  

How to get Reserved Quantity for Sales Line in Ax 2012 x++

Follow the below steps to get the reserved quantity for sales order lines in ax 2012 x++.

If you want to get total of reserved quantity Sales line wise then you can do the following way. First you need to create view as per below picture.

Then you can try below code in job to get reserved quantity for sales line item.

        SW_InventTransView sW_InventTransView;

        SalesLine _salesline1 = SalesLine::findInventTransId('Salesllines inventtransid');

        select sum(Qty) from sW_InventTransView where sW_InventTransView.ReferenceId==_salesline1.SalesId && sW_InventTransView.ItemId==_salesline1.ItemId

                          && sW_InventTransView.InventTransId==_salesline1.InventTransId

                          && sW_InventTransView.StatusIssue == StatusIssue::ReservPhysical;

        info(strFmt("%1 Qty", -(sW_InventTransView.Qty)));

Actual Post : http://msdynamicsxx2012.blogspot.com/2017/06/how-to-get-reserved-quantity-for-sales.html?utm_source=feedburner&utm_medium=feed&utm_campaign=Feed%3A+TechnicalTutorialsForMsDynamicsAxapta2012+%28Technical+Tutorials+for+MS+Dynamics+Axapta+2012%29

A building block group can't be imported while any building blocks are open Error while Importing or Exporting the finance/management reports in AX 365

Recently I got the below error while importing the finance reports into my system.

A building block group can't be imported while any building blocks are open.

Solution:

Close all the active screens. So that the MR client allows the import process.

Make sure you closed all the active screens.