Skip to main content

Notifications

Supply Chain Management forum

Inventory costing by Warehouse

Posted on by 20

Hi

Is there anyone who knows how to manage inventory costing and COGS  by warehouses

We have two warehouses. One (A) is for pick and pack, and the other (B) is for storing stocks temporarily.

I want to exclude the warehouse B for COGS. Under current setting, two warehouses are calculated for COGS.

Thank you.

  • MATTGUO Profile Picture
    MATTGUO 22,306 on at
    RE: Inventory costing by Warehouse

    Hi Hyunjin,

    The FIFO method is applied only with the closing or recalculation of your inventory.

    Please make at least a recalculation of your inventory in the inventory closing form and check your transactions and your COGS again.

    You may get some more information in whitepapers which explains the costing models and the inventory closing: www.microsoft.com/.../details.aspx

  • Hyunjin Profile Picture
    Hyunjin 20 on at
    RE: Inventory costing by Warehouse

    We adapt FIFO, but don't have any tracking dimension at the moment.

    FIFO is just calculated based on inventory date.

  • Hyunjin Profile Picture
    Hyunjin 20 on at
    RE: Inventory costing by Warehouse

    Hi Andre,

    It is because of the difference of the purpose of warehouse.

    Warehouse A is for sale to customer.

    Warehouse B is for inventory keeping.

    I believe that COGS should be applied to the goods sold in warehouse A.

    That's why I want to exclude warehouse B when COGS is calculated.

    I hope this could be answer.

  • MATTGUO Profile Picture
    MATTGUO 22,306 on at
    RE: Inventory costing by Warehouse

    Hi Hyunjin,

    What is the inventory model of item?

    If FIFO or LIFO, COGS will be recalculated after closing or recalculating your inventory.

    If moving average or weighted average, physical and financial inventory need to be checked on storage dimension groups.

  • Suggested answer
    André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 291,253 Super User 2024 Season 2 on at
    RE: Inventory costing by Warehouse

    Hi Hyunjin,

    If you ask if it is possible to have costing per warehouse, then this is possible by enabling the Financial check box on the storage dimension group row for the warehouse. I wonder what exactly you mean with exclude warehouse B for COGS. It will for sure have costs and thus also inventory value posted to the ledger.

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

November Spotlight Star - Khushbu Rajvi

Congratulations to a top community star!

Forum Structure Changes Coming on 11/8!

In our never-ending quest to help the Dynamics 365 Community members get answers faster …

Dynamics 365 Community Platform update – Oct 28

Welcome to the next edition of the Community Platform Update. This is a status …

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,188 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans