web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics AX (Archived) / Inventory Close
Microsoft Dynamics AX (Archived)

Inventory Close

(0) ShareShare
ReportReport
Posted on by lally 8

Hi All ,

I have some questions regarding the above query , i hope you can answer me.

a) What is the  meaning of number of helpers in the Inventory parameters?

b) What is batch threads and generally How many batch threads  are configured on in batch server settings?

c) How does batch threads useful ?

d) Generally What values we will  give in the closing options? (e.g. maximum throughputs?

e) What is Maximum throughput and min throughput ?

Please explain in detail about the above queries ?

*This post is locked for comments

I have the same question (0)
  • Suggested answer
    André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 301,130 Super User 2025 Season 2 on at

    Hi Lally,

    Many question on a difficult topic...

    a) When you specify the number of helpers, you can speed up the process as AX will divide the work in to multiple threads with bundles of items.

    b) This question is related to the first question. You can setup the number of batch threads. This will determine the maximum you can specify as workers within the inventory parameters. The default value is 8, but if you have good hardware specifications, you can increase it.

    You can find more related to inventory closing and batch threads in this document: www.microsoft.com/.../details.aspx

    c) See also the document provided

    d) There is a page on technet, explaining the options: technet.microsoft.com/.../aa553192.aspx

    Normally I choose a period end date. Select total as specification to have less accounting transactions in the general ledger. The specification is available per item in the Settlements form related to a Close/Recalculation.

    e) The maximum throughput determines the number of iterations per item. If you are using BOMs, the recalculation will calculate per BOM level. Unless you specify enough throughputs. If you have 5 levels in a BOM and specify a maximum of 3, the lowest levels will not be recalculated. The default is 100 (according the documentation 50). This is too high in many cases. You can eventually debug or add some logic to monitor which iteration gives additional settlements.  It has no use to have 100 iterations if it turns out to have no additional settlements after the third iteration. Additional useless loops will only cause longer process time.

    I'm not sure what the impact would be when you change the default of the minimum throughput value. I have never analyzed it. Until now I could manage to have the closing calculating the correct amounts. Otherwise, I would have to look into this parameter.

  • lally Profile Picture
    lally 8 on at

    Hi Andre ,

    Thank you for the reply.

    Our client has almost 45000 items in different warehouses of one company in one database.

    Can i know that how many Batch helpers need to create and  what would be highest value i can enter in the field of  Number of Items per bundle ?

    Could explain how does process run in the functional point of view ?

    [quote user="Andre Arnaud de Calavon"]If you have 5 levels in a BOM and specify a maximum of 3, the lowest levels will not be recalculated.[/quote]

    What do you mean by lowest levels ?

    Thanks in advance.

  • lally Profile Picture
    lally 8 on at

    Hi All ,

    Can one explain the answers to the above questions ?

  • André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 301,130 Super User 2025 Season 2 on at

    Hi Lally,

    For the number of batch helpers, see my previous answer on question a and b. You now only mention the customer has 45000  items. What is the current setting of the batch threads? This would be your maximum. You can do some testing to increase or decrease this number, to see if it has much impact. If you run this job in batch mode, you can see the actual start and end time once it has been executed.

    Lately I had done a test on a system with over 60000 items and used 4 batch helpers as a start. The execution time was OK (10 minutes), so we did not change this. As it is running in batch overnight, this customer does not yet care about the duration. The number of batch helpers could be increased when you need to perform the task quicker.

    In this test I did not change other default settings and also the bundle was not set.

    About your last question with the lowest level: It is about the BOM levels. If you have semi-finished goods used in other BOM items, you have multiple levels.

  • lally Profile Picture
    lally 8 on at

    Thank you Andre for the explanation ,

    Could i know the answer for generally what would be highest value can enter in the field of  Number of Items per bundle ?

    What about your experience ?

    Thanks in advance.

  • André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 301,130 Super User 2025 Season 2 on at

    Hi Lally,

    The maximum value is 2147483647. But this is not recommended. Documentation has this section about this setting:

    The optimal bundle size is almost impossible to predict. Use the following guidelines to determine when you should increase or decrease the bundle size:

     Increase the bundle size if the number of items with few or no transactions is high (for example, approximately 100,000 items), and if the number of items with an average number of transactions is low (for example, approximately 2,000 items).

     Decrease the bundle size if one or more “Processing calculation level” tasks are completed a significant amount of time before the others. In this case, a decrease in the bundle size will increase parallelization.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1
Martin Dráb Profile Picture

Martin Dráb 4 Most Valuable Professional

#1
Priya_K Profile Picture

Priya_K 4

#3
MyDynamicsNAV Profile Picture

MyDynamicsNAV 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans