Skip to main content

Notifications

Announcements

No record found.

Business Central forum
Suggested answer

Adjust Cost only on certain periods

Posted on by 233

Hello everyone, 

I need to close the inventory period of october 2021, I haven't run the cost adjustment in while. The Close Inventory Period - Test says that I have to adjust cost for a certain number of items. 

Is there a way to run the Adjust Cost – Item Entries for only the october movements? 

Many thanks in advance. 

  • Suggested answer
    Inge M. Bruvik Profile Picture
    Inge M. Bruvik 32,744 Moderator on at
    RE: Adjust Cost only on certain periods

    It would really break the system logic if that was possible especially for the items other than standard cost items.

    Running cost adjustment regularly is considered best practise.

  • Suggested answer
    Esteban Navarro  Profile Picture
    Esteban Navarro 233 on at
    RE: Adjust Cost only on certain periods

    Hello everyone, We opened a case with Microsoft and there's no way to cost only certain periods. The only solutios is to take the blow and run the costing process for all items.

  • Suggested answer
    Vaishnavi J Profile Picture
    Vaishnavi J 3,056 on at
    RE: Adjust Cost only on certain periods

    Just to add Kim's point

    The cost adjustment function uses the posting date of the original value entry in the adjustment entry, unless that date is in a closed inventory period. In that case, application uses the starting date of the next open inventory period. If inventory periods are not used, then the date in the Allow Posting From field on the General Ledger Setup page will define when the adjustment entry is posted.

    Below is the link for more information

    docs.microsoft.com/.../inventory-how-adjust-item-costs

  • Suggested answer
    MahGah Profile Picture
    MahGah 15,419 on at
    RE: Adjust Cost only on certain periods

    Thanks Kim. Yes it did.

  • Dallefeld Profile Picture
    Dallefeld 11,423 User Group Leader on at
    RE: Adjust Cost only on certain periods

    BC uses the general ledger allow posting from and to dates for the Adjust Cost routine.

    Let's say that you have that set to 2/1/22 and 2/28/22, when you run adjust cost any entries being adjusted prior to 2/1 will post using the 2/1 date while entries during February will post using their actual dates.

    Does that help you?

  • Suggested answer
    MahGah Profile Picture
    MahGah 15,419 on at
    RE: Adjust Cost only on certain periods

    Hi Kim Dallefeld

    Thanks for info. Can you please provide more info about "However, you can setup your general ledger allow posting from date to 10/31/21 and any entries in October will adjust to the 10/31/21 date". I am interested to learn more about this method.

    Thanks

  • Suggested answer
    Vaishnavi J Profile Picture
    Vaishnavi J 3,056 on at
    RE: Adjust Cost only on certain periods

    Hi ,

    If you have inventory periods then there is no way you can close the inventory period before running the adjust cost item entries manually or adjust the cost item automatically by setting the Automatic Cost Adjustment to true in Inventory setup.

    Refer the below link for more information.

    docs.microsoft.com/.../design-details-cost-adjustment

    Also to add Kim's point.

    if the user who is trying to adjust the entries has some posting date restriction on user setup them make sure â€˜Allow Posting From Date’ within GL Setup must be within the date range of the Users who are posting Inventory Transactions. 

    Posting date on value entries - Business Central | Microsoft Docs

    If my answer was helpful to you, please verify it so that other users know it worked. Thank you very much.

  • Dallefeld Profile Picture
    Dallefeld 11,423 User Group Leader on at
    RE: Adjust Cost only on certain periods

    No. However, you can setup your general ledger allow posting from date to 10/31/21 and any entries in October will adjust to the 10/31/21 date. This will also adjust entries in November to November dates and December to December dates and so on.

    I think this will work for you. You can always create a copy of your company and try before you run it in production.

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

Anton Venter – Community Spotlight

Kudos to our October Community Star of the month!

Announcing Our 2024 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Dynamics 365 Community Newsletter - September 2024

Check out the latest community news

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 290,532 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 228,501 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans