Navision 4.00 Manufacturing Issue

CtrlShiftF11
CtrlShiftF11 Member Posts: 29
edited 2005-12-21 in NAV/Navision Classic Client
I am trying to conduct a simple business process using Navision Mfg. I want to take 1 Inventory Item of Item No. A and output the following...

Desired Output...
Item No. Qty.
Item B 10
Item C 10
Item D 10

Consumption...
Item A 1

Answers

  • kine
    kine Member Posts: 12,562
    And you want needed setup from us?

    If yes, you need to setup some Production BOM for the items whcih will say that Item B is created from Item A (for quantity 1 of Item B you need 0,033333333333333333333333333333333 of item A etc.)...
    Kamil Sacek
    MVP - Dynamics NAV
    My BLOG
    NAVERTICA a.s.
  • DenSter
    DenSter Member Posts: 8,307
    If I were you I'd change the Base Unit of Measure of Item A to the same unit that you use for the A component within B, C and D, so your inventory is in the same unit, and you don't get funky rounding issues.
    Daniel Rimmelzwaan
    RIS Plus, LLC
  • CtrlShiftF11
    CtrlShiftF11 Member Posts: 29
    So you can't create Items B, C and D and consume exactly 1 of Item A without altering the Qty. Per of one of the items. Do you see my point?

    .33333 Consumption of Item A to output 10 of Item B+
    .33333 Consumption of Item A to output 10 of Item C +
    .33333 Consumption of Item A to output 10 of Item D +

    = .99999 Total Consumption of Item A

    My inventory will always be off unless I stop - take the time to subtract whatever the total actual consumption will be from the desired consumption then make an adjustment using that figure. This is incredibly inefficient for a custom manufacturing shop. There has to be a better way to do this.
  • CtrlShiftF11
    CtrlShiftF11 Member Posts: 29
    That's what I thought too Denster until I tried it. Fire up Navision and plug in the Items and you will see that it is truly impossible to make consumption come out even without making a manual adjustment.
  • DenSter
    DenSter Member Posts: 8,307
    No I don't think so. If you buy One box of something that has 3 eaches inside, then inventory will say 3 eaches. Then when you consume one each for D, C and D, it will consume 3 eaches in total and you should not have a rounding issue
    Daniel Rimmelzwaan
    RIS Plus, LLC
  • CtrlShiftF11
    CtrlShiftF11 Member Posts: 29
    No, if you create a Family that consists of B, C and D and then you try to take Item A (which is already comprised of B, C and D) and break it down back into B, C and D then you can't do it with whole numbers. The Base UOM for all items is an EACH.

    It would take 1/30th to make 1 unit of B, C or D.

    Try it out.
  • CtrlShiftF11
    CtrlShiftF11 Member Posts: 29
    Ok, I have figured out how to do this now...

    I have a Family that is comprised of Items B, C and D (all of these items have a qty. of 10). Now I've made a dummy inventory item called Phantom. Phantom's qty on the prod. line will always be equal to however many families we need to output. In our example this value is 1. Items B, C and D will NOT have any components attached to them. Phantom will have two component lines attached, one for Item A (the finished good that is being broken down) and one for phantom (so that the dummy item can consume itself). I was able to do this and achieve the desired output and consumption without yielding any decimated numbers!

Categories