Dynamics Business Central (NAV)
Experts:
UOM
-
UOM
-
Using NAV 2017 – We have an Item were the base UOM is in Gals and the Invoicing UOM is in Gals but the issue is this – we use the Base UOM and mix that with water and create another UOM which is sold in Gals, however. if only consume 75% of a gallon, we sill Invoice the customer for a whole gallon. This is causing inventory to go into the negative. They are using an assembly BOM to dilute the first Item with water and produce the second Item.
Anyone have any ideas?——————————
Xan
Fort Worth
—————————— -
To be clear, are you saying that you have one item record (ITEM-A) as a raw material that goes into producing another item (ITEM-B)?? If yes, the BOM for Item-B should call for 0.75 GAL of Item-A, correct? For Item-A, what is the Rounding Precision (by default it can be viewed in Replenishment Fast Tab of the Item Card page)? If set to 1, this means that every time you use 0.75, it will actually consume 1. Try entering it as 0.01.
——————————
Jason Luchka
Senior Enterprise Applications Analyst
siffron
Twinsburg OH
——————————
——————————————- -
1 gal of item A is 1gal regardless of what you do to it. If you are buying item A in 1 gal, and you want to sell item A at 75% A plus 25% water you must have either a different item or a different unit of measure, FGGAL (finished good) with a conversion factor that takes 75% of as gal.Sent from my T-Mobile 4G LTE Device
——Original Message——
Using NAV 2017 – We have an Item were the base UOM is in Gals and the Invoicing UOM is in Gals but the issue is this – we use the Base UOM and mix that with water and create another UOM which is sold in Gals, however. if only consume 75% of a gallon, we sill Invoice the customer for a whole gallon. This is causing inventory to go into the negative. They are using an assembly BOM to dilute the first Item with water and produce the second Item.
Anyone have any ideas?——————————
Xan
Fort Worth
—————————— -
Do you have the rounding precision on the item card for the gallon item set to be able to consume less than 1? It should state .01 so that it can consume .75 of a gallon. If it states 1, no matter what is entered on the BOM, it will always take a whole gallon.
Diane Schulz
Cost Analyst
Office: 262-814-7312
Cell: 414-745-0171
Diane@tapconet.com——Original Message——
Using NAV 2017 – We have an Item were the base UOM is in Gals and the Invoicing UOM is in Gals but the issue is this – we use the Base UOM and mix that with water and create another UOM which is sold in Gals, however. if only consume 75% of a gallon, we sill Invoice the customer for a whole gallon. This is causing inventory to go into the negative. They are using an assembly BOM to dilute the first Item with water and produce the second Item.
Anyone have any ideas?——————————
Xan
Fort Worth
——————————
-
-
0 Replies
Sorry, there were no replies found.
The discussion ‘UOM’ is closed to new replies.
