Dear All, Please explain how does this field helps in calculating the components requirement. Also if possible some practical scenario. Rgs
Hi Abhay It is quite simple really, the calculation formula works out the quantity of the item required where this is based upon measurements of the item rather than a set quantity - the calculation formaula is, as you can see, an option field, so depending upon the nature of your goods, depend upon the quantity per, examples could be for slitting in pharmaceuticals for dressing creation, fertilizer production where volume and factors can be used to claculate the quantity or I suppose paper manufacturer where quantity is taken off rolls. Effectively anywhere where the requirement of the quantity to consume is a format of any combination of height, length, width or depth.
Hi Steven, Thanks for your input but I am trying to relate to a process. Please confirm and clarify the following: As a raw material I am using a metal sheet. This metal sheet I buy in pcs and store in pcs. But when I consume I consume in different sizes. Each sheet size is 1010. I can consume in any size it can be 35 or 54 or 57 and so on. Inventory part is having Base UOM as pcs. at the same time I also created another UOM as SQFT and conversion factor as 0.01, reason being individual sheet size is 1010. I do a positive adjustment of quantity 1. Now in the first production order I consumed 53 sheet . When I consume this sheet I only know the size and not the percentage of sheet, therefore I enter the length and width as mentioned by you. Consumption journal is posted. At this stage when I check the raw material inventory it shows me as 0.85. In the second production order I consumed 5*17. After posting system shows inventory as zero. Please confirm is it ok and also let me know after first production order system shows inventory as 0.85. CAn I see the inventory in size that is what is the lenght and width which is available. Rgs
Hi Abhay If it works for you it works for you - Navision has a strength like that [:D] If you are stocking the metal in sheets - each - then your inventory will be viewed in this manner. Handling metal sheets in this manner can be problematic, becase the percentage of the metal left maybe enough to handle cuttings, but not the size cutting required, even though it falls within the percentage of stock left. You will need to analyse the requirements and benefits of implementing this form of system. Simplicity can be to not use the measurements, as they give you little benefit in off-cut visibility (depending on the engineering and process). If you then need to see stock by metal size - this needs to be recorded, for instance not that you have 0.25 of a sheet left, but the actual parameters, so you need to know the shape of the cut. You woul dneed to modify the process and any views. In a lot of sheet metal manufacturing the sheet is utilised in the press to its full potential and other components - not on the original order are pressed, to gain maximum yield out of hte machines capacity and the sheet. have fun [:D]
Steven, In the initial suggestion you mentioned about pharma and fertilizer industries. I will be thankful if you can give some more inputs on it. What will be UOM at Item card level and UOM at BOM level. Than how does one proceed. I am sorry for lack of knowledge on the pharma and fertilizer industry. It will be of great help for me. Rgs
Hi Abhay UOM do not change [:D] At least in the way I have worked on systems implementations in the past.
What do you mean by saying UOM does not change. I think I was not clear in explaing my query. If I am storing some item in one UOM say in KGs and utilizing this items in grams in production, than as per my understanding in Item card I will enter Kgs but at routing level UOM will be grams. Incase still I am not clear than my request is can you please explaing how does the concept of calculation formula works in the case of pharma or fertilizer industries as mentioned by you. Rgs
Hi Abhay What i mean is that when I have set it up the UOM has not changed from stocking to manufacturing, therefore I will not have your added complications. I have set it up in this manner as it makes the consumption and set up of the BOM’s simple and they work. If you are altering all of these your calculation formula will have to reference the correct UOM to calculate the correct quantity. I can only advise you set it up - process it - see what it does - change anything that is wrong.