Skip to main content

Notifications

Announcements

No record found.

Supply chain | Supply Chain Management, Commerce
Answered

Run inventory recalculation every day through batch job good/ bad?

(0) ShareShare
ReportReport
Posted on by 130

Hello All, 

we are thinking to set up a batch job which runs overnight and calculates cost against all daily transection. This would help us to report accurately on Margin and Cost. 

Are there any implications we should be concern about before we set this up. 

In a month how many times we can run recalculation? 

  • Tony Yang Profile Picture
    Tony Yang on at
    RE: Run inventory recalculation every day through batch job good/ bad?

    There is no limitation at all, just based on your business requirement. I have seen some client run inventory closing every half year or weekly.

    In additional, run recalculation will give more accurately on Margin and Cost for FIFO, LIFO, or average-weight, but not help for standard valuation method.

  • Suggested answer
    Muthusamy Profile Picture
    Muthusamy 4 on at
    RE: Run inventory recalculation every day through batch job good/ bad?

    Hi Hitesh,

    We can schedule a batch on every night or weekly twice or weekly once or monthly twice or every month once when closing. As Andre said, inventory transactions will be more based on the batch occurrence.

    In addition to that, When you run batch on daily basis, you will get the cost posted exactly in most of the time when issue & receipt. So, it will help you when you are submitting daily reports to management on sales & inventory side.  

    Thanks,

  • Verified answer
    André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 291,885 Super User 2024 Season 2 on at
    RE: Run inventory recalculation every day through batch job good/ bad?

    Hi Hitesh,

    There is no restriction on running the recalculation. Usually, it can run daily or weekly and a closing each month. In one case, where there were too many inventory transactions, we did run it every night and a closing each week.

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

Congratulations 2024 Spotlight Honorees

Kudos to all of our 2024 community stars! 🎉

Meet the Top 10 leaders for December

Congratulations to our December super stars! 🥳

Start Your Super User Journey Pt 2

Join the ranks of our community heros! 🦹

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,885 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,569 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans