How is the BOM version field "From qty." used in Microsoft Dynamics Ax?

(0) Share

Report

Posted on by Community Member

Hello Microsoft Dynamics Community!

I was wondering if someone could give, or direct me to, a more thorough explanation or example of what the "From qty." field could be used for when using it as a criteria for setting up which BOM version to use. I've been doing some research and experimenting with a few ideas, but I'd like to find out more about the "From qty." field before I invest the time in implementing several changes to my BOMs. Most of my search results have just directed me to the brief Microsoft Technet description:

"From qty. = The minimum quantity that is valid for this BOM version. When generating orders, Microsoft Dynamics AX selects a BOM version based on this and other criteria that you define. If the field is cleared, this BOM version is valid for all quantities."

I'll try to provide some more detail about what exactly I'm trying to implement, but any insights you might have in the meanwhile I would love to hear. If it makes a difference, I'm using Microsoft Dynamics Ax 2009.

Thanks

*This post is locked for comments

I have the same question (0)

All responses (7)

Answers (0)

Suggested answer

Fredrik Sætre 12,644 on at

Like (1)

Report

Hi there Taggart,

The thing about from qty is that you can have multiple BOMs activated but with different intervals (same as date from-to). You can only have one unique record for the item and from qty active and within a date interval. The production that is created will trigger a different BOM when the qty is equal to or above this quantity and the date requirements are reached. You can have several steps like this... I have seen customers have 5 quantity variation levels like this for an item.

A good case is when an item comes over a given quantity it can be more cost efficient to order the item from a supplier, then to do an inhouse production of the item on your own "small" manufacturing resource.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Ah, I see. Thanks for the explanation. If one were to order 2 items, and you had a BOM version with "From qty." = 1, and one for "From qty." = 2, would both BOM versions be used (one for the first item ordered, and the second being the default for the items ordered in excess of 2+), or are all of the ordered items configured according to the second BOM version? I imagine the later is correct.

My problem is that I was hoping to manipulate/change my BOMs for a particular item based on the quantity ordered in a slightly different way. Allow me to explain:

I have an item/BOM "Firmware_upgrade" that consists of four items; chip, box, extractor, and manual. If the customer orders one "Firmware_upgrade", the build needs to contain all of those items. For larger quantities, the customer still only requires one box, extractor, and manual, but they need multiple chips. Here are a few example orders:

Customer order #1: 1 X "Firmware_upgrade"

Customer receives: 1 X chip

1 X box

1 X extractor

1 X manual

Customer order #2: 2 X "Firmware_upgrade"

Customer receives: 2 X chip

1 X box

1 X extractor

1 X manual

Customer order #3: 3 X "Firmware_upgrade"

Customer receives: 3 X chip

1 X box

1 X extractor

1 X manual

etc.

I had initially hoped that maybe the "from qty." field held the key to doing this, but now it seems clear that it does not work that way. Does anybody know how I might achieve this?

Was this reply helpful? Yes No
Suggested answer

Daniel Weichsel on at

Like (0)

Report

Hi Mr_Alex,

It sounds like you should change the consumption type of the box, extractor, and manual from "Variable" to "Constant". This can be maintained on the BOM lines form, Setup tab.

Was this reply helpful? Yes No
Suggested answer

Weaveriski 23,620 Moderator on at

Like (0)

Report

It does not use both BOM's because the quantity on the order is 2 the BOM with the from quantity will be applied to the order. The quantity field will do this, but you are creating hundreds of BOM's until your highest quantity, the setting described by Daniel works better in your example, because you only need 1 box (until you get to a certain size unless the chips are not in the box!)

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

What impact would changing the consumption in the fashion you've described have on the final process? I'm not really the system architect. I'm more or less responsible for item and BOM creation and maintenance, but I'd like to know the sort of down-the-line impact such a change would make and other things that we'll need to keep in mind for the treatment of this particular product offering of ours. Are there other things that have to be kept in mind when setting up an order?

Let's say my finished product "Firmware_upgrade" costs $50. If the customer orders three "Firmware_upgrade", I want them to be charged $150. We're essentially including the manual, extractor, and box as complimentary items on all orders, but we still want to track their consumption. Does the following hold true?

Customer order: 3 X "Firmware_upgrade"

Invoice shows: 3 X "Firmware_upgrade" ordered

Customer charged: 3 x "Firmware_upgrade" cost = 3 x $50 = $150

Customer receives: 3 X chip

1 X box

1 X extractor

1 X manual

Inventory: -3 chip

-1 box

-1 extractor

-1 manual

If it makes any difference at all, none of the sub-parts of the "Firmware_upgrade" are saleable on their own (they are more or less just components, not "finished goods" in their own right).

Also, thanks for the help so far everybody. I'll be sure to like and/or validate your posts and suggested answers once I have time to implement this.

Was this reply helpful? Yes No
Weaveriski 23,620 Moderator on at

Like (0)

Report

Well the main thing is your "constant" items never change no matter how many of the parent item you make. This means the contribution cost of the item is always whatever it is costed at.

The customer charge comes from the value assigned to the Firmware_Upgrade item through item sales price or trade agreement. The cost is the rolled up cost of the components depending upon your costing method.

It makes no difference that you cannot sell them by themselves and I presume you will block them from sales.

In essence having the box as a constant of 1 means your cost and consumption is static at 1. Your only consideration is if someone orders 1000 is it still 1 box.

Was this reply helpful? Yes No
Suggested answer

Fredrik Sætre 12,644 on at

Like (0)

Report

Hello again,

So the issue is you don't want multiple boxes for each order, but how many fit in a box? Let's hypothesize that 1 box for every 10 chip.

There are multiple ways of going about this.

1) Use multiple BOMs with "from qty"

Then you will have to create a BOM for every 10 pcs and have the constant for the box be 1/10 of the from qty.

Might work if you have few steps like this (2 or 3)

2) Use formula instead of BOM

The formula has the possibility of steps for a single bom line, where you can say: Use 1 box for every 10 chip for instance...

3) Use the calculated field

There are some fields that are calculated based on the parameters set on the top level BOM items setup. You can use this and make a nice formula that will calculate the consumption for every 10 pcs produced. Would need to try this out. Check on the calculated fields in your BOM and play around with values on your finished goods (in the engineering tab height, width, length, density.

4) Use a constraint based product builder

Create a master item, Add your BOM and create the rules for creating the BOM you need. The boxes can then be calculated based on the qty of chips and even vary the type of box or packaging time. Like if you sell 1000 you need 100 small boxes and 10 big boxes + a pallet.

:)

Was this reply helpful? Yes No