Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Small and medium business | Business Central, N... / UOM creating strange P...
Small and medium business | Business Central, N...
Answered

UOM creating strange Purchase Requests

(1) ShareShare
ReportReport
Posted on by LM-04121437-0 10
Can anyone help me understand the issue from my MRP run? I have an item where the UOM is "PCS" on the item card, and that is what we want to purchase in. When we consume this item on a BOM through a Production Order we consume in "mm" 1 pcs = 50,000mm (5 mtr rolls). My MRP is giving me messages to ordrer PCS based on fixed reorder on the item card, but it is also asking me to order in "mm" based on Productoin requirements. But the costings is not as expected. Below is a screenshot showing the purchase suggestions:
Categories:
Dynamics 365 Business Central
  • Verified answer
    Ben Baxter Profile Picture
    Ben Baxter 5,073 Super User 2024 Season 2 on at
    UOM creating strange Purchase Requests
    You have your UOM conversion backward.  MM is the smaller unit, you currently have 1 MM = 50000 PCS, you stated it should be 1 PCS = 50000 MM.  The Quantity Per Unit on the MM line should be 1/50000; which will leave you with a decimal in your Quantity on Hand as soon as you consume some.
     
    Ideally you would have had MM as your Base Unit of Measure, which would avoid fractional inventory.  You could have used Lots to track the "PCS" (rolls) and how much was left in each roll.
     
    At this point updating your Quantity Per Unit on the MM UOM will resolve your purchasing issue, as long as you are okay with seeing decimals in your Quantity.
     
    I'd still encourage using Lot Tracking if you want visibility into the number of rolls and remaining quantity per roll, but this also requires your team recording which roll was used during consumption to stay accurate.
     
    As for the system suggesting to purchase in MM, I'm not sure it is.  I think you need to add the UOM to your Planning Worksheet line to verify.  If it is suggesting MM, check your Reordering Policy settings for the SKU record.
     
    Best Regards,
    Ben Baxter
    Accent Software Inc
  • LM-04121437-0 Profile Picture
    LM-04121437-0 10 on at
    UOM creating strange Purchase Requests
    The item card shows the correct purchase UOM (PCS), and I beleieve the base UOM is also PCS.
     
    Screenshot below is of the UOM table:
     
    Below is the BOM screenshot:
  • Yi Yong Profile Picture
    Yi Yong 1,704 Super User 2024 Season 2 on at
    UOM creating strange Purchase Requests
    Hello,
     
    Can you attach the item unit of measure table and the production BOM table?
  • Suggested answer
    Valentin Castravet Profile Picture
    Valentin Castravet 25,426 Super User 2024 Season 2 on at
    UOM creating strange Purchase Requests
    On the item card you can have a base unit of measure, and a purchase unit of measure. Are both set as PCS or is your purchase unit of measure set as mm?
     

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

Congratulations 2024 Spotlight Honorees

Kudos to all of our 2024 community stars! 🎉

Meet the Top 10 leaders for December

Congratulations to our December super stars! 🥳

Start Your Super User Journey Pt 2

Join the ranks of our community heros! 🦹

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,605 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans