Hi, We are still considering if Navision fits for us. One problem is that we make out planning according the rules of EROT (equilivent run-out time). This works with stock in time (weeks), when one product is running out (< 3 weeks), all products in the same EROT-categorie are produced until all products have the same stock in time (7 weeks). The numbers that are produced can be different, but the run-out time is the same. This is important to decrease the time to prepare a production group. How can we do this in Navision? Is it possible? We have software development skills… — edit: Bottom line, what we need is stock in time, we don’t want to see how much stock we have left, only how much time we have left. If the prognose is we sell 12 bicycles a week, and the stock is 36, we want to see that we have 3 weeks left. If we produce another 3 weeks, this means that the stock grows to 72, 6 weeks.
Hi rasap. I would guess from what you have intimated that you could not do satisfy your requirements as standard in Navision. However in the manufacturing section you do have families, whereby you group similar items together.
quote:
A production family is a group of individual items whose relationship is based on the similarity of their manufacturing processes. Forming production families can optimize material consumption.
Done no playing in this area - but you can see on a production order that you can specify the source type as family - and this will show all the items in the family on the production order. Do not think you can get this to auto-generate onto the planning worksheet, so you would need a trigger - when one item in a family comes up - manufacture the family. I hope this helps.
You’ll need to mod it then [:D]
I know the standard Navision does not have this functionality, but the following is not clear by me: -Is it hard to calculate remeaning stock in time/weeks in Navision? -Can we use a flow-field to do this, and just add this to the item table? -And if we do, what happens when we update Navision? -Is it true that flow fields don’t work in de MsSQL version of Navision?
Hi Rasap I would recommend posting this form of question in the developer forum - you will get a better answer. However with regards to point 1, you would need a setting against the item to tell it stock in weeks, so somewhere you define the weekly quantity (Or you get the system to calculate it based on historical usage). Then you define your requirements with this parameter in mind. A flow field will look at the built up transactions below, so potentially you could have a view that takes the parameter in point 1 and applies this to the physical inventory (below). Unsure if this can be done, or if theoretically it then remains a flow filter - I would guess restrictions apply. However if it is possible as flowfields are fields whose contents are constantly changing - the system calculates the value of the contents of a FlowField each time you open the window containing the field - if it is developed properly, each time you open the window/refresh the screen the value will alter if applicable. As for point 4 - you will be best off asking it in the technical/developer forum. I have no idea [:)]
Could this be approached by setting up WEEK as a unit of measure to be used as the base UM (in conjunction with others)?
It would be messy [:D] You would need to set up UOM relationships between actual quantities and weeks consumptions. Purchasing book in 10 - this is 1 week. Manufacturing consume 2 which is a days worth. Possible but it will make the system confusing - even more so if you have “real” UOM relationships! I would prefer to do it outside in the one place required, rather than set the system up in this manner - but to really decide I would need to analyse the actual requirements and the pro’s and con’s of this. Still Sandra - interesting suggestion - thanks [;)]