mibuso.com
Home› NAV/Navision Classic Client
Options

Warehouse Management Module Question

davisjdavisj Member Posts: 38
edited 2007-01-12 in NAV/Navision Classic Client
Hi All...

My company is using the Warehouse Management module and we are having some difficulties with posting inventory transactions (Consumption Journal, Item Journal & Physical Inventory Journal).

The issue is that any time we post one of these types of transactions the system is not updating the Bin Contents with the change to inventory. That leads to a disconnect between the Item Card Inventory (Qty. on Hand) value and what the Bin Contents total up to.

We are on 4.0 with the SP1 execuitable only.

Is this an issue that has been fixed by one of the service packs or is it possibly a setup issue?

Any help would be great

Thanks in advance!

Comments

  • ara3nara3n Member Posts: 9,258
    I have a client that is on sp3 and they are using whse. mgt. and creating warehouse picks for Released production orders, they register the picks and post the consumptions and output, and it works fine.
    Ahmed Rashed Amini
    Independent Consultant/Developer


    blog: https://dynamicsuser.net/nav/b/ara3n
  • raj2000beraj2000be Member Posts: 36
    When you post journal transactions in the warehouse module using the Whse. Item Journal or the whse. Physical Inventory journal the system does not update the Item Ledger Entries. This is a standard feature built in the system to avoid the over population of the Item ledger with a lot of entreis.

    To update the Item Card Quantity, you have to periodically use the Calculate Whse. Adjustment batch job available in the Functions button of the Item Journal. This will calculate and populate one consolidated journal line per item and the item card quantity is updated only when this journal is posted.

    Regards
    Rajesh
  • ara3nara3n Member Posts: 9,258
    the bin content is created or upddated based on warehouse entry table, and not item ledger.
    Ahmed Rashed Amini
    Independent Consultant/Developer


    blog: https://dynamicsuser.net/nav/b/ara3n
  • raj2000beraj2000be Member Posts: 36
    Thats right aran, I never said otherwise. But the Bin contents do not update the Item ledger and hence the quantity on the item card. Thats why you would have to run the calculate whse. adjustment batch job to update the item card quantity to match the bin content.

    Regards
    Rajesh
  • ara3nara3n Member Posts: 9,258
    ic I misread it

    He wrote

    The issue is that any time we post one of these types of transactions the system is not updating the Bin Contents with the change to inventory.



    which led me to believe that the bin content info wasn't correct.



    And yes Item Ledger and Warehouse Entry can go out of sync. If you are doing warehouse adjustment or warehouse physical for location that are setup with pick and putaway.

    Production consumption on the other hand creates the item ledgers so that wouldn't be an issue.
    Ahmed Rashed Amini
    Independent Consultant/Developer


    blog: https://dynamicsuser.net/nav/b/ara3n
  • davisjdavisj Member Posts: 38
    All... Thanks for the feedback :D . I was unaware of the Calculate Whse. Adjustment batch job. I am going to play around with this.
  • ara3nara3n Member Posts: 9,258
    If you are using lot tracked inventory or serial no. Make sure it calculates the correct value. Last time I checked, it didn't, and the report had to be changed.
    Ahmed Rashed Amini
    Independent Consultant/Developer


    blog: https://dynamicsuser.net/nav/b/ara3n
Sign In or Register to comment.