I've been having issues with the planning worksheet and I cannot understand what I am missing.
I have an item setup as Maximum inventory.
I have 2 on hand and 4 on Sales order.
Planning is setup as reorder point as 10, I have maximum inventory as 12 since we do not want to stock more than 12.
Min order qty is 10 and max is 12 and I have multiple of 2. Lead time is 7 days
When I run the planning worksheet it keeps on telling me I only need to create an assembly order for 2, which will be enough for the order, but I have specified maximum inventory and order parameters. Should it not suggest an order up to the maximum qty level (unless of course I have more items on SO?)