Anyone understand the 10,000 demand planning item ...
# manufacturing
g
Anyone understand the 10,000 demand planning item limit? What if we have 500 items, each with 20-100 components, with some overlap, so we have roughly 15000 items. If we run supply plan by picking those 500 items, will the system just crash at 10k items when it is drilling into the BOMs and such? or is the 10k limit on which initial items are selected?
s
Pretty simply put, it sucks if you have over 10k parts
g
We told the sales rep we had over 10k parts and required MRP. Kind of the most integral part of our process...
I'm researching whether I can create a suitescript to kick off a supply plan generation. So I could have the suitescript select the top level items and start it.
"sucks" but is that because the UI doesn't show all of your items in the generate supply plan paged list? That's the current thing I've noticed. Current concern that I can't test today (pending demo for a subset of data), is whether it will just stop when it gets to 10k parts, or if it will keep running and just the UI is difficult to select the top level parts.
s
I personally was unsuccessful with demand/supply planning in an account with over 10k parts when I was an admin. Just couldnt make it work at all like we wanted. We built a solution in our own account to tailor to our needs instead.
g
What kind of solution? Separating boms and items and running supply plan on a smaller set of things? Or, rewriting supply plan logic to something custom, or something different?
s
it could only process 10k parts from what I saw, but it was a couple years ago and we had no outside assistance
g
Cool, thanks for the experience/info.
s
we cancelled demand planning and built what we wanted it to do
g
Cool, thanks. Yea, we've got a complicated case with 3-5+ bom layers, and components with 6+ months lead time (some with 1+ year of leadtime, which netsuite also can't support, but oh well.) But, we can't really manually generate the purchase orders, transfer orders, and work orders for all of these things.
s
What do you mean by NS cant support a year lead time? Also how the hell do you run a business with a part with 1 year leadtime
g
If you try to put more than 365 days in the purchase order lead time, it errors out.
We build electronics, with covid, some things have increased in lead time. Some small parts already had 3-6 month lead times, just gotta order them ahead of time, but then with components and raw materials shortages, those have increased. We have existing orders in for these parts, so we're receiving them all the time. But, if we were to put in a brand new PO today, we've got some 18 month promise dates for some things.
Yes it makes me wonder why that company can't spin up production, but.... idk.
We could pay 10x the cost to have them expedited or buy them from another vendor, but that's purchasing decisions that I'm not involved in.
s
Ah makes some sense given the circumstance
g
message has been deleted
If anyone else has any experience with 10k+ items and supply planning, I'd be interested to hear.
r
These are hard limits within the engine (10k items, 365 days). Utilizing the MRP engine instead of Time Phased gets past those limitations. IN the 365 days case, you could run a supply plan past the 365 then one for 0-365 days. It's a bit messy and you're doing dual work.
a
I believe the 10k items is a limitation on the top level selection. It does not apply to all the components related to the 10k items We created a workflow that would flag an item as demand plan needed. (This may not apply to you but all our demand planning was based off actual orders not forecasts so we just flagged any item on a WO or SO) Then we filtered the generate supply plan list to only the items marked as “Demand Plan Needed = T”. This filter our 90k parts down to about 8k which fit nicely in the 10k limit In the end we also have turned off demand planning because it was VERY difficult to use. I think MRP might be better but haven’t had a chance to fully test
g
Then we filtered the generate supply plan list to only the items marked as “Demand Plan Needed = T”.
That's awesome, and that may be what we need. We can filter on our top level items.
Utilizing the MRP engine instead of Time Phased
Hm, I guess I didn't realize there was something else in the system for MRP that was different than Demand Plan and Generate Item Supply Plan.
a
Yes MRP is a newer feature they came out with in the last 2-3 releases. If you look up Supply Planning or Planning Workbench in SuiteAnswers that will get you to the articles to read more about it. I got lost in the Planning Workbench and never go back to it to figure it out. There was a lot there.
a
New MRP engine looks far more like what other systems provide with MRP, has far greater visibility around exceptions... a few additional fields to be configured on the item record, can also schedule MRP to run at a set interval frequency** requires Advanced BOM enabled