Fastest way to clean InventSumLogTTS

Fastest way to clean InventSumLogTTS table.

Just drop the table from SQL management studio.

DROP TABLE InventSumLogTTS

and then from AX re-synchronize InventSumLogTTS table.

Comments

Post a Comment

Popular posts from this blog

🚀 Export All D365 F&O Custom Models with a Single Batch File

  In Microsoft Dynamics 365 Finance and Operations (D365 F&O), managing and exporting models can be a repetitive task, especially when you're dealing with a large number of custom models. To streamline this process, you can automate model exports using a simple batch file. In this blog, I’ll walk you through how to create a .bat file that exports all your custom models in one go—without needing to execute each command manually. This is especially helpful during regular backups or before code deployments. 🧠 Why Use a Batch File? A batch file allows you to: Export multiple models in one go Create backups with date-based folders automatically Reduce human error and save time Reuse and modify easily 📂 Folder Structure Assumption In this example, we're assuming the following: D365 metadata is located at K:\AosService\PackagesLocalDirectory ModelUtil.exe is located in K:\AosService\PackagesLocalDirectory\bin You want to store exported models in  ...
Read more

Dynamics 365 - Create, Update or delete records directly from database

Image
As we all know that we don't have the access to the database and there are times where we need to create update or delete a record directly from database. So, In order to get this thing done. I created a form from which I can directly execute the query. It can be enhanced but just to give you the idea how to do it.  Here is the form design. Set QueryControl's allow declaration property to YES. Override ExecuteBtn's click event and write the following code. List            queryList = new List(Types::String); ListIterator    iterator; str             sqlQuery; DialogButton    diagBut; str             strMessage = "Are you sure you want to execute this query?"; str             strTitle = "Execute" ; super(); diagBut = Box::yesNo(strMessage, DialogButton::No,  strTitle); if (diagBut == DialogButton::...
Read more