Open Forum

  • 1.  Item ledger bin content mismatch

    Posted Oct 27, 2021 09:18 AM
    HI All- We upgraded from NAV4.03 to NAV2018 in June 2020. In the old system, we did not purchase all the inventory and warehouse granules and we encountered alot of mismatches on a lot basis between the warehouse entry and the item ledger entry (the lot and qties and bins in the bin content screen did not match the lot qties in item ledger. ) We were told that it was because we did not purchase all the granules and could not run the adjustment periodically to match them up (I cant remember the specific name fo the activity)
    Anyway, we now have all the modules. Our location is set up  for Warehouse: Require receive, Require Put away, Require Pick, Bin Mandatory, BINS: Receipt bin code REC, open SFBin code- WIP, To production bin code- Issue Prod, From Prod Bin Code OUTPUT; Bin Policies: Bin Capacity Policy Never check capacity, and Pick According to FEFO.  Warehouse SetUp: Nothing is checked, (NOT require receive, require putaway, require shipment or require pick)
    We are still getting alot of errors with mismatched between item ledger and bin contents on a lot, bin and qty basis. We believe we are only experiencing this from the consumption activity from our work orders ( we have not seen evidence yet of this from the sales orders process)
    Our consultant has looked and thinks it is a bug and that it will be difficult to figure out because it is somewhat sporadic so it is like " a needle in a haystack" - however we just looked at the list of items mismatched for two categories of our inventory and it is a lot more than we first suspected. This is hugely disappointing for us- one of hte main reasons we upgraded was to correct this issue.
    Does anyone else have this issue? Can anyone suggest a fix, or even a way to troubelshoot and identify the cause?
    We found this post that seems to describe the same issue https://www.dynamicsuser.net/t/item-ledger-entry-and-warehouse-entry-out-of-synch-non-wms/28580
    #Manufacturing #NAV2018

    Thank you
    Jeanmarie​​​

    ------------------------------
    Jeanmarie Curley
    Sr Director Bus Ops
    Quality Biological Inc
    Gaithersburg MD 20878
    ------------------------------


  • 2.  RE: Item ledger bin content mismatch

    NAVUG ALL STAR
    Posted Oct 27, 2021 11:41 AM
    Jeanmarie,

    Question - As you have noted you are using Advanced Warehousing. Have you run the Item Journal/Calculate Warehouse Adjustments? This syncs Warehouse to ILE, which sounds like the issue. Warehouse registering and posting effect Warehouse tables and the Item Journal will update the ILE/VE.

    Thanks,
    Steve

    ------------------------------
    Steven Chinsky
    Manager
    Wipfli
    Mansfield MA
    NAVUG/BC Programming Committee Member
    NAVUG All-Star, Granite Award Recipient, MCP, DCMP
    ------------------------------



  • 3.  RE: Item ledger bin content mismatch

    Posted Oct 27, 2021 04:11 PM

    Hi Steve- thank you so much for replying- I always get confused about the warehousing terminology- we are not using directed pick and put away- (is that advanced warehousing? ) I have attached an example of our putaway doc below. We do for sure use warehouse receipt for receiving-

    Can you explain when we would need to run Item Journal/Calculate Warehouse Adjustments? Every time we do consumption? At the end of each day? Or every time we post an item journal? Thanks for the help I really appreciate it

     






  • 4.  RE: Item ledger bin content mismatch

    NAVUG ALL STAR
    Posted Oct 27, 2021 09:17 PM

    Jeanmarie,

    I make sure I teach someone to run the Item Journal/Calculate Warehouse Adjustments at a minimum daily. If you want the information to be posted more often, you can work with your Partner to create a Job Queue for the function that runs on a schedule and posts. Below is a summary of the Calculate Whse. Adjustment Batch Job.

    Calculate Whse. Adjustment Batch Job
     
    Sums up item by item all the quantity adjustments found in the warehouse adjustment bin. If the sum of the adjustments for an item is a positive or negative quantity, the program creates a line in the item journal for posting. When you post the adjustment lines, the item ledger and the warehouse records for the items, variants and locations that you selected in the batch job correspond exactly. To run this batch job, open the Shortcut icon Item Journal window and click Actions, point to Functions, and then click Calculate Whse. Adjustment.

    Fill in the fields on the Options FastTab as follows:
    •Posting Date: Enter the date for the posting of this batch job. The program automatically enters the work date in this field, but you can change it.

    •Document No.: Here you must manually enter a document number that will be entered in the Document No. field on the journal lines created by the batch job. Because no number series has been set up for this batch job, use the number scheme set up by the warehouse, or enter the date (year-month-date) followed by your initials.

    All this can be setup in a Job Queue.
    Thanks,

    Steve



    ------------------------------
    Steven Chinsky
    Manager
    Wipfli
    Mansfield MA
    NAVUG/BC Programming Committee Member
    NAVUG All-Star, Granite Award Recipient, MCP, DCMP
    ------------------------------



  • 5.  RE: Item ledger bin content mismatch

    NAVUG ALL STAR
    Posted Oct 27, 2021 10:05 PM
    <<Can you explain when we would need to run Item Journal/Calculate Warehouse Adjustments? >>
    You'll need to run it after any time you REGISTER a Whse. Item Journal and also after REGISTERING a Whse. Phys. Inventory Journal.

    When you register a "Warehouse" Journal you are only adjusting warehouse entries and there is no financial impact.  In fact, when you see the term REGISTER, that means no financial impact.

    The term POST means there is a financial impact, so when you run the Calculate Whse Adjustments in the Item Journal and then POST the results, you are "truing up" the Item Ledger (so that it matches the warehouse entries in terms of quantities) and there is a financial impact (change in the value of your inventory).


    The imbalance between Warehouse Entries and Item Ledger Entries is something we used to experience a lot in NAV 4.00.  We never figured out the cause ("undocumented system features" or bad modifications).  The problem seemed to go away as we upgraded to newer versions, BUT we carried some of that bad data forward with our upgrades.

    Did you upgrade or re-implement?  I ask this because you might have brought some bad data forward.  I would be concerned if you started fresh with an empty Warehouse Entry and Item Ledger Entry tables and still have the issues (unless the issue has been caused by not calculating whse entries and posting the item journal).

    I would recommend asking your partner to run a report that will identify any imbalances between the two tables and run it on a regular basis...weekly or if things are really bad, maybe ene daily. Also ask your partner to fix any issues after the first run of the report. If you can get to a "clean point in time" and then monitor for problems, you may determine the issue, or hopefully determine that the problem no longer exists.

    ------------------------------
    Lewis Rosenberg
    IT Manager
    Mars Fishcare
    Chalfont PA
    www.apifishcare.com
    ------------------------------------------------------------------------
    D365UG-BC/NAVUG All-Star
    D365UG-BC/NAVUG Former Board of Advisors, Chairperson
    D365UG-BC/NAVUG Programming Committee

    Twitter: @RosenbergL
    LinkedIn: https://www.linkedin.com/in/rosenbergl
    ------------------------------------------------------------------------
    ------------------------------



  • 6.  RE: Item ledger bin content mismatch

    Posted Oct 29, 2021 09:55 AM

    Thanks again- does it make sense that we are only seeing the issue with production orders consumption/raw materials and not sales orders and finished items?

     






  • 7.  RE: Item ledger bin content mismatch

    NAVUG ALL STAR
    Posted 27 days ago
    Jeanmarie,

    Any Warehouse transaction must follow the Calc. Warehouse Adjustments so it updates ILE and GL.

    Thanks,
    Steve

    ------------------------------
    Steven Chinsky
    Manager
    Wipfli
    Mansfield MA
    NAVUG/BC Programming Committee Member
    NAVUG All-Star, Granite Award Recipient, MCP, DCMP
    ------------------------------



  • 8.  RE: Item ledger bin content mismatch

    Posted 27 days ago

    Steve, I believe I have figured this out. We process our sales order directly from the sales order posting(the pick "instruction" is just a report not a warehouse pick). I think this is why we are only seeing the issues with raw material receipt and consumption, of which we use warehouse receipts, picks and put aways.  

    I guess if we just run the calculate inventory now, it won't correct all the issues we have accumulated to this point, correct (it has been over a year!) We need to correct the tables manually form a physical inventory and then begin using the new process of running the calculate inventory

    I really appreciate your help

    Jeanmarie

     

     






If you've found this thread useful, dive deeper into User Group community content by role