mibuso.com
Home› NAV/Navision Classic Client

Inventory showing in Item LE but not in bin

ajmalsherifajmalsherif Member Posts: 111
edited 2013-01-09 in NAV/Navision Classic Client
Belated happy new year everyone

I am trying to write of some stock using an Item Journal. We use lot numbers, locations and bins. On the journal line i am using Applies- to-Entry to link to the Item LE. I am also using Item tracking line to identify the stock from the Lot number. However i am unable to post - the error is saying there is no stock in the bin. No stock is confirmed by Bin Content table.

Comments

  • krzychub83krzychub83 Member Posts: 120
    Try to execute Functions -> Calculate Whse. Adjustments on the Item Journal for that item. Maybe you will get your LOT from there? Maybe it was already written off from the inventory and you only need to move warehouse adjustments to the ILE.

    In the past I had seen this issue few times, but:
    - it was related to bugs in customization, and with that we are not able to help you.
    - it was related to user, who had a habit to switch 'Qty. per Unit of Measure' instead of creating a new Unit of Measure. This can be checked by the Qty. per Unit of Measure field on the ILE and WE.
    Good luck
    KB
  • krzychub83krzychub83 Member Posts: 120
    Try to execute Functions -> Calculate Whse. Adjustments on the Item Journal for that item. Maybe you will get your LOT from there? Maybe it was already written off from the inventory and you only need to move warehouse adjustments to the ILE.

    In the past I had seen this issue few times, but:
    - it was related to bugs in customization, and with that we are not able to help you.
    - it was related to user, who had a habit to switch 'Qty. per Unit of Measure' instead of creating a new Unit of Measure. This can be checked by the Qty. per Unit of Measure field on the ILE and WE.
    Good luck
    KB
  • ajmalsherifajmalsherif Member Posts: 111
    Many thanks - please elaborate :-k :

    "Maybe it was already written off from the inventory and you only need to move warehouse adjustments to the ILE."

    Please describe this scenario in basic steps.

    THANKS
  • krzychub83krzychub83 Member Posts: 120
    There is not much to elaborate here. It might happened that somebody had removed inventory from the warehouse (for example) by posting a journal line with negative quantity on Whse. Item Journal. When you post a Whse. Item Journal line NAV posts everything to the adjustment bin on the WE instead of making any posts directly to the ILE. To update the ILE quantities (move adjustments from adjustment bin from WE to ILE) you should be executing Functions -> 'Calculate Whse. Adjustments' on the Item Journal on a regular base. This function is checking entries in the adjustment bin and then it is creating Item Journal Lines to correct quantities on ILE.

    If somebody did it you will have 0 quantities on the bins, but some quantities on the ILE.

    BTW. There is a third situation when a difference might appear. This is related rounding differences between Base Unit of Measure and used Unit of Measure. For example if you will use unit of measure PCS, with QTY per Base Unit of Measure is 0.01 and then post few transactions for that unit of measures for quantity 0.12345 (etc). This will end with differences between quantities in Unit of Measure and Base Unit of Measure.

    Good Luck
    KB
Sign In or Register to comment.