Reposting this as I am a bit desperate for anyone who might be able to give me some advice: Hey all, I've got a work order in NetSuite here, for some reason no matter what I do, it is only committing half of the required amount for the quantity set on the work order. Doesn't matter if I have 5 or 30 quantity. I am able to individually edit line items to make it correct, but wondering why I am getting half of my quantities on creation. BOM revision is for 1 quantity and is set to eaches and the 1 item in grams. The units are identical across the board. No weird component yield on them either, it is just straight across. Any ideas?

Is it only for this one work order, or is it happening with all of them?

@Brian Not EVERY work order, its actually a small fraction but has happened 5 times in one week so far.

Could be a number of things. Are you using inventory status? Could some of your components be using different inventory statuses? Are you using supply allocation? Or are your WOs committed on order entry?

@Brian We do use inv statuses, components are all using available inv and the items are in stock. No supply allocation. Inventory is committed on order entry.

Hmm...In your bom structure are you using component yield?

Not using component yield either 😕

And you can commit the remaining inventory when you manually click on the inventory detail button?

All of the inventory is committed, the quantity calculated is not correct. I.e. look at the screenshot above, WO is for 5 quantity, components are 1 eaches, although I am getting 2.5 Quantity in the lines. When I adjust quantity, it scales at 1/2. On other WOs its random, doesn't scale by half but will add .01231451235 quantity...

Could you post a screen shot of the bom revision for this WO?

image.png

Hmmm...pretty strange. Did you double check your units on the revision vs the wo/items? The revision looks like it is 'EAs' and the WO looks to be only 'EA'. Not sure if you have two different units there or just the plural for a single unit. And do you have any scripts running on the WO? You can check that by going to : Customization > Scripting > Scripted Records and look at Work Orders

Same unit, its just the plural. I have some scripts running, I am not super familiar with Suite Script but I've had GPT explain them to me and I don't think they would be effecting it.

What happens if you edit the WO and change the WO build quantity? Do the components fix themselves?

On this 1 ^^^ it continues to scale at 1/2

Sorry, stumped. My best guess is a script is messing with it. Maybe NS support can tell you more.

Appreciate the effort Brian, I will update if I get some answers from NetSuite.