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

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Microsoft Dynamics NAV (Archived)

Automatic Cost Adjustment

(1) ShareShare
ReportReport
Posted on by 443

Dear All,

In our organization, we used to manually run the 'Adjust cost - Item Entries'. Since we missed to run for one month, we felt making it automatic might be the better choice. So, In Inventory Setup, did the following:

Automatic Cost Posting - TRUE

Expected Cost Posting to G/L - TRUE

Automatic Cost Adjustment - Always

Average Cost Calc Type - Item

Average Costing Period - Month.

Question is how far making this automatic, will affect the productivity of the organization, performance wise.

Do I need to go to General Ledger Setup and tick 'Use Legacy G/L Entry Locking' as well??

Consider, I'm posting a Sales Order with 400 lines (as we do bulk posting of all Sales Orders together and the average no. of line item is around 400) and does it affect all other users from accessing posting to G/L Entry till the posting of Sales Order gets completed?

How long this auto adjustment will take? Will it be just couple of minutes more or more than 30 minutes because I posted on Sales Return Order with 2 line Items and it started running Adjustments for all the Items taking much time.

Request suggestions on the implications of this process who faced similar situation.

*This post is locked for comments

I have the same question (0)
  • Verified answer
    Amol Salvi Profile Picture
    18,698 on at

    This link will help you

    www.archerpoint.com/.../effects-inventory-setup-microsoft-dynamics-nav

  • Suggested answer
    Roberto Stefanetti Profile Picture
    12,998 on at

    hi,

    if your tax regime does not require a real-time cost update, schedule the 'Adjust cost" report in the evening by NAS.

  • Sarav Profile Picture
    443 on at

    Thank you both,

    Based on the link, I prefer to change the Average Costing Period from Month to Day for faster posting but does it impact in the Cost accuracy to a lot?

  • Suggested answer
    Roberto Stefanetti Profile Picture
    12,998 on at

    i use normally "day" buckets with location and variants setup for calculation (not only item),  i don't know the best setup for your country.

    in italy "item ledger entries" are not posted on G/L (are only auxiliary entries), we have also a localization for fiscal inventory evaluation.

  • Sarav Profile Picture
    443 on at

    Hi,

    Thank you for your reply.

    We don't have Item Variants and we define Sales price for all the location as same. That's why I used Calc Type as 'Item'. Please correct me if I'm wrong, so that I can change to Item&Loc&Variants combo.

    Glad that 'Day' periods are used. (Hope, the accuracy will be very minute difference compared to Month, if it so). Will change it to 'Day' for better performance. Thanks much.

    I'm using Australian localisation in Singapore.

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…

Leaderboard > 🔒一 Microsoft Dynamics NAV (Archived)

#1
HoangNam Profile Picture

HoangNam 7

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans