Skip to main content

Notifications

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

Over buying when using Worksheet

(0) ShareShare
ReportReport
Posted on by 90

I Have these planning setting

Sk_E600_rmbillede-2022_2D00_03_2D00_24-091633.png

 when i run the worksheet i am starting to get proposals which i do not need and is over the reordering point

Sk_E600_rmbillede-2022_2D00_03_2D00_24-091657.png

I cant figure it out

  • Suggested answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Over buying when using Worksheet

    VELTUFF,

    The Purchase Orders that are open, when is the Expected Receipt Date for them? I see the 60 and I see you use SKU, so curious their receipt Date vs. Due Date needed.

    Thanks

    Steve

  • VELTUFF Profile Picture
    VELTUFF 90 on at
    RE: Over buying when using Worksheet

    Hi Josh

    But why does it the give me 3 lines x 30 as i only need 30 (1 line)

  • Suggested answer
    JAngle Profile Picture
    JAngle 33,159 on at
    RE: Over buying when using Worksheet

    That looks correct to me. Here is why.

    40 is below your stock requirement

    60 on PO does take it to that required level

    but 9 on SO takes it beneath again.

    You order in multiples of 30.

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