Multi-thread Imports in Dynamics 365 for Finance & Operations

  

Multi-thread Imports in Dynamics 365 for Finance & Operations


There are a few perplexities on how to multi-thread your imports in Dynamics 365 for Finance and Operations. The primary thing to know is that Microsoft prevents you from multi-threading a few entities, which may be a great thing. Usually great since in Flow AX 2012 you'll multi-thread any substance and fundamentally, in case the arrange of the records getting imported is critical, at that point, multi-threading isn’t a great alternative since in case they go out of grouping due to records getting imported in parallel you'll degenerate your data.

The moment the thing to know is how to set up multi-threading in Dynamics 365FO. To do this you essentially go to Workspaces > Information Administration > Tap the System Parameters tile > Substance Settings tab > Press Arrange Substance Execution Parameters.



Within the entity execution parameters, you're defining how numerous strings ought to be utilized after you purport a substance in the group. You wish to get it merely can set up a substance at different times in this frame as seen below.





You're defining three things within the form:

Entity – What substance are you setting multi-threading up for.

Import threshold– The threshold tells the framework how numerous records got to be imported to utilize this line.

Import record count – How numerous strings ought to be utilized; aka how numerous assignments are created. Example Let’s walk through an illustration of bringing in the “Customer Definition” substance with 1360 records.

Next Actions

Create Import project, add the entity you added earlier in the execution parameters form, and import in the batch mode.


To verify multi threading go to the Batch job screen, find your job and check in the view task screen, you will find multiple threads of your task.


Archive inventory transactions D365FO

 

Archive inventory transactions


D365FO Data Archiving


In the 1st Quater of 2021, Microsoft introduced the most wanted feature of data archiving, although it is still not available for all tables and targeting only inventTrans table for the time being.

As per Microsoft's fast track, archiving is a very crucial topic for them, they know very well from time to time data of their client increase and client start registring the performance issues. 

Let's move to the topic:


How you can turn on this feature in your environment?


Navigate to Feature management, and turn on the Inventory transactions archive feature.



Important
Once you enabled the feature then you couldn't disable it again.


Prerequisites

Only during the times when the following conditions are met can inventory transactions be archived:

The ledger period has to come to an end.

Inventory closing must be performed on or after the archive's to-period date.

The period must begin at least one year before the archive's from-period date.

There must be no inventory recalculations in place.

Archive inventory transactions


Follow these steps to save inventory transactions.

To access the inventory transaction archive, go to Inventory management > Periodic chores > Clean up > Inventory transaction archive.

The Inventory Transactions Archive page appears, displaying a list of processed records that have been archived.



To generate an inventory transaction archive, go to the Action Pane and select Inventory transactions archive.

Set the following fields in the Inventory transactions archive dialog box's parameters FastTab:

Follow these steps to save inventory transactions.

  • Choose the earliest transaction date in the closed ledger period to include in the archive.
  • Select the most recent transaction date to include in the archive in the closed ledger period.



Set up batch processing details as needed on the Run in the background FastTab. In Microsoft Dynamics 365 Supply Chain Management, follow the regular batch job instructions.

Choose OK.

You get a notification asking you to confirm that you wish to keep going. If you want to continue, read the information carefully and select Yes.

The Inventory Transaction Logs Archive page shows your complete archive history. Each row in the grid displays information such as the date the file was created, the user who created it, and its status.




Virtual Fields Vs Computed Fields

  Virtual Field: A virtual field in D365FO is a field that doesn't have a direct representation in the database. It's a field that y...