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

Community site session details

Session Id :
Dynamics 365 Community / Forums / Business Central forum / Physical Inventory Cou...
Business Central forum

Physical Inventory Count by Unit of Measure

(0) ShareShare
ReportReport
Posted on by Jacynthe 3

Hi,

I saw that with the calculate inventory function, it brings the quantity in stock for the base unit of measure. Is it possible to count the inventory for an other unit of measure and enter the quantity in this uofm?

in exemple, lets say I have an item 1 with a base uofm = pcs. An other item uofm is case (6 pcs in a case).

Could I enter that I have 6 cases of that item 1 in the phys. inventory journal? Or do I have to enter 36 pcs??

I would like to be able to enter both uofm, is there a way? When I try to enter the uofm, I receive an error message "phys. inventory must be equal to 'no' in item journal line."

Thanks

Categories:
Other
Business Central
Inventory and warehouse management
I have the same question (0)
  • Hannes Holst Profile Picture
    Hannes Holst 5,767 on at
    RE: Physical Inventory Count by Unit of Measure

    Hi,

    This depends how do you manage your inventory and the setup of your items.

    Do you use Bins & Zones?

  • Jacynthe Profile Picture
    Jacynthe 3 on at
    RE: Physical Inventory Count by Unit of Measure

    It's a possibility for one of the locations to use bins & zones, so I have to look at all the options..

  • Hannes Holst Profile Picture
    Hannes Holst 5,767 on at
    RE: Physical Inventory Count by Unit of Measure

    Hi,

    In general it is possible, yes. You always have a field called "Quantity" and a field "Quantity (Base)".
    "Quantity (Base)" holds the quantity in the base unit. E.g. when entering 6 in "Quantity" and select Case in "Unit Of Measure", the field "Quantity (Base)" would contain 36. Keep in mind that you have to maintain the "Item Unit Of Measure" per item to tell BC how many single units are in a Case-unit.

    When using Zones & Bins, the Bin Contents would be in the unit you have counted. This can cause problems, because the inventory (and reservations) is maintained in the base unit.

    E.g. you have a total of 36 which is available as 6 cases. You enter a Sales Order with 35 and create the Warehouse Documents. In this situation you would have to allow a breakbulk. Because one of the cases, must be opened and 5 pcs must taken out to fulfill the order. This process must be supported by your warehouse.

    As an alternative, you would have to make sure that you enter the correct unit in the Sales Order. So instead of 36 pcs, you would have to enter 6 cases. This must be supported by your sales team of course as this might clash with the original order of the customer.

  • Jacynthe Profile Picture
    Jacynthe 3 on at
    RE: Physical Inventory Count by Unit of Measure

    Thank you but when I try to change the uofm, I receive an error message "phys. inventory must be equal to 'no' in item journal line."

    Would you know why I receive that?

  • Suggested answer
    Teddy Herryanto (That NAV Guy) Profile Picture
    Teddy Herryanto (Th... 14,253 Super User 2025 Season 2 on at
    RE: Physical Inventory Count by Unit of Measure

    don't think you can change your unit of measure during stock taking. it is going to be base unit of measure, unless you customize it.

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 > Business Central

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans