Skip to main content

Notifications

Small and medium business | Business Central, N...
Suggested answer

Shortage Report

(0) ShareShare
ReportReport
Posted on by 5

Does anyone know of a good shortage report in business central? I need to know which POs are missing for each production order. Looking for something like the MD4C report in SAP.

  • Suggested answer
    Inge M. Bruvik Profile Picture
    Inge M. Bruvik 32,748 Super User 2024 Season 1 on at
    RE: Shortage Report

    Have you tried the "Purchase Reservation Avail." report?

    That can be an option if your purchase orders have reservations against the production orders.

  • Suggested answer
    Amit Baru Profile Picture
    Amit Baru 3,025 on at
    RE: Shortage Report

    Hi,

    Shortage functionality is not available in standard system.

    Regards

    Amit Sharma

  • Robert Jolliffe Profile Picture
    Robert Jolliffe 859 on at
    RE: Shortage Report

    Normally someone would run MRP via Planning Worksheet to generate suggesting purchases.  There are a number of reports in the planning area that might work - but I have no idea what MD4C from SAP is and I'd be surprised if there were more than 1 or 2 people on this forum who do.

    When you say "PO's are missing for each production order" that is a bit confusing. Production Orders assume that material will be drawn from inventory and it's unusual to peg Supply to the Prod. Order Demand.

    What kind of projects are you doing that you match POs to Prod Orders?

  • Suggested answer
    YUN ZHU Profile Picture
    YUN ZHU 74,036 Super User 2024 Season 2 on at
    RE: Shortage Report

    As Amit said, if the standard reports don't work for you, you need to customize them.

    You can try using Report Extension to extend standard report.

    More details:

    https://docs.microsoft.com/en-us/dynamics365/business-central/dev-itpro/developer/devenv-report-ext-object

    https://yzhums.com/10723/

    Hope this helps.

    Thanks.

    ZHU

  • Suggested answer
    Amit Baru Profile Picture
    Amit Baru 3,025 on at
    RE: Shortage Report

    Hi,

    Depends, what type of functionality mapped in the system. If you do some custom fields for mapping Shortage against Production. Then you should develop custom report.

    Regards

    Amit Sharma

    www.erpconsultors.com

  • Alex McGilvray Profile Picture
    Alex McGilvray 5 on at
    RE: Shortage Report

    Thank you for the reply, this doesn’t show the PO numbers that meet the demand of the production orders.

  • Suggested answer
    YUN ZHU Profile Picture
    YUN ZHU 74,036 Super User 2024 Season 2 on at

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

News and Announcements

Announcing Category Subscriptions!

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Verified Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,370 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans