News and Announcements icon

Dynamics 365 CommunityForums Small and medium business | Business Central, N... Over buying when using...

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

Suggested answer

Over buying when using Worksheet

(0) Share

Report

Report

Posted on by VELTUFF

90

I Have these planning setting

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

I cant figure it out

All responses Img

All responses (3)

Answers Img

Answers (0)

Suggested answer

Community Member Microsoft Employee on at

Like (0)

Report

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 90 on at

Like (0)

Report

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 33,159 on at

Like (0)

Report

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.

Helpful resources

News and Announcements

Announcing Category Subscriptions!

Quick Links

Leaderboard

#1

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

#2

Martin Dráb 230,370 Most Valuable Professional

#3

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans