Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics NAV (Archived) / ACIE with average cost...
Microsoft Dynamics NAV (Archived)

ACIE with average cost run very slow

(0) ShareShare
ReportReport
Posted on by Alpha Zhang 50

Hi Experts

I'm a consultant of Tectura. Our customer Carlsberg China use NAV2013 build 7.0.36207.0 and they run ACIE with average cost once a month.  It will take more than ten hours ro run the report 795 Adjust Cost - Item Entries, although it run successfully, our customer is unsatified with the performance.

I have checked there are no customerized codeings on standard ACIE function. Costing Method is Average Cost. and there are almost 50000 new records in table 32 item ledger entry each month.

Is there any way to improve the performance?

Thanks

Alpha

 

*This post is locked for comments

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: ACIE with average cost run very slow

    Alpha你好，请问后来有没有查到原因和解决方法呢？ 我们遇到类似问题了。谢谢。

  • Verified answer
    Aleksandar Totovic Profile Picture
    Aleksandar Totovic 16,765 on at
    RE: ACIE with average cost run very slow

    If this is so, you have a big problem. Basic recommendation in implementation process is "Never use average costing method for finish goods". You can try something with database optimization, but I doubt you can do something much better.

    If you still can, try to change costing method, at least for finish goods. Try to change to FIFO or Standard. With 50000 new entries, I'm not sure how it can work with average method.

  • Alpha Zhang Profile Picture
    Alpha Zhang 50 on at
    RE: ACIE with average cost run very slow

    yes, we use manufacturing and use average method for finish goods.

  • Suggested answer
    Aleksandar Totovic Profile Picture
    Aleksandar Totovic 16,765 on at
    RE: ACIE with average cost run very slow

    If you use average costing method, ACIE will be slower. It depends of entry numbers, but this is a fact.

    Are you use manufacturing and if answer is yes, are you use average method for finish goods or not?

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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,198 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans