Skip to main content

Notifications

Announcements

No record found.

Business Central forum
Suggested answer

Shortage Report

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.

Categories:
  • Suggested answer
    Inge M. Bruvik Profile Picture
    Inge M. Bruvik 32,744 Moderator 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 69,639 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 69,639 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

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