Open Forum

Expand all | Collapse all

Quantity in Bin Contents NOT in on-hand

  • 1.  Quantity in Bin Contents NOT in on-hand

    GOLD CONTRIBUTOR
    Posted 16 days ago
      |   view attached
    I have a bit of a mess with this one. We have a Purchase Order with two lines on it. Item 60420 with Qty 101,200 and a line for item 60420 with a quantity of -101,200. Posted Purchase Receipt has both on it, however only the 101,200 line has been applied to anything. We have another Posted Purchase Receipt for the same PO same Item and same two lines which also had been Received. Third Purchase Receipt with the correct Qty of 101,200 received, put-away and Invoiced. The On-Hand Inventory in NAV is correct however with these two received lines of 100,200 each totaling 202,400 is now what is showing in the Bin Content/Warehouse Entries. I do not want or cannot post an inventory adjustment as the inventory matches the physical inventory. This anomaly 200,400 qty is just sitting there. I have tried to do a Purchase Return which FAILED as there is no Inventory to "return". I tried to delete Bin Content that also FAILED. Any suggestions would be great.

    We are using NAV 2017 On-Prem

    Thank you,

    ------------------------------
    Troy Harkness
    Miller Baking Company
    Milwaukee, WI
    ------------------------------


  • 2.  RE: Quantity in Bin Contents NOT in on-hand

    NAVUG ALL STAR
    Posted 12 days ago
    Troy,

    Happy New Year. I think I'm following your steps but a few questions... The Location you are posting too is Bin Mandatory and uses Advanced WMS? Also, you state that the negative PO Lines were posted on the same Posted Purchase Receipt, correct? The reason I ask is that the negative quantity, with Bin Mandatory, will not find a Bin with such a quantity until its received. I am just guessing this was a 2-step process?

    Next question - I see the pic with the Bin Contents of the received 202,400, from the Posted Purchase Receipts. Can you look at the Posted Purchase Receipts and Navigate to the Item Ledger Entries and look at Location and Bin to see where the entry was posted too. Again, just asking questions to trace the steps.

    Thanks,
    Steve

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



  • 3.  RE: Quantity in Bin Contents NOT in on-hand

    GOLD CONTRIBUTOR
    Posted 12 days ago
    Happy New Year Steve,
    I have screenshots of Warehouse Entries and ILE to hopefully clear up the questions. The original receipt date was 10/18 however there are entries on both ILE and Warehouse Entries that involve the issue.


    ------------------------------
    Troy Harkness
    Miller Baking Company
    Milwaukee, WI
    ------------------------------



  • 4.  RE: Quantity in Bin Contents NOT in on-hand

    NAVUG ALL STAR
    Posted 12 days ago
    Troy,

    Using the images below, I see in the ILE 3 Purchase Receipts and 2 with an offsetting Negative Qty. On the Warehouse Entries, which are for the Bin entries, I see 3 Receipts, 1 Transfer from Location 01 to Location 03 and 1 Pos/Neg that washes to itself. My question now is where did the 2 Negative PO Lines from the Receipts get posted too in Location 01. My gut is telling me they are NOT in a Bin or Bin = '' (this means Blank). Can you Navigate on the 2 Posted PR document and see what Bin each record shows?


    Thanks,
    Steve

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



  • 5.  RE: Quantity in Bin Contents NOT in on-hand

    GOLD CONTRIBUTOR
    Posted 12 days ago
    Steve,
    When I navigate on the Posted Purchase Receipt I find a couple of things.
    1. I find that there are 2 ILE postings for each "Receipt" BUT only 1 Warehouse Entry
        PR114208
               ILE              Warehouse Entry
        a. -101,200        NO ENTRY ON TABLE
        b.  101,200        Posted to Packaging (Bin)
        PR114212
        a. -101,200        NO ENTRY ON TABLE
        b.  101,200        Posted to Packaging (Bin)

    After seeing this I did find out that the Warehouse Manager added the -101,200 on he receipt to try to "fix it" TWICE. Now I am thinking that these are not applied entries however I took a quick look (I spent a whole 2 minutes looking around) and didn't really see what to apply.

    ------------------------------
    Troy Harkness
    Miller Baking Company
    Milwaukee, WI
    ------------------------------



  • 6.  RE: Quantity in Bin Contents NOT in on-hand

    NAVUG ALL STAR
    Posted 12 days ago
    Troy,

    OK, this answers my question. The negative entries DID NOT post to the Warehouse Entries as the Bin Code was blank. Your goal is to take the Location 01, Bin Code = Packaging, and eliminate the 202,400, correct? If yes, here is my suggestion...

    1. Using an Item Journal, first reverse the 2 Negative Entries which DO NOT have a Bin Code (create a Positive Adjustment). Please make sure you use the correct Posting Date as the next entry is the correction one.
    2. Now that the 2 negative entries are eliminated from the Item, using the same Posting Date so this all washes to 0, lets create a correct Negative Adjustment entry, which points to Location 01 and Bin Code = Packaging. Post this entry and you will see the Bin have a Qty = 0.

    This should solve the issue you are trying to acheive.
    Thanks,
    Steve


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



  • 7.  RE: Quantity in Bin Contents NOT in on-hand

    GOLD CONTRIBUTOR
    Posted 11 days ago
    Steve,
    I see where this would work however I cannot post to a Bin Code that is blank. NAV will not allow. I also tried to post this all in one with a reclass journal just to try it. That did not work either. (I know grasping at straws but I had to try).


    ------------------------------
    Troy Harkness
    Miller Baking Company
    Milwaukee, WI
    ------------------------------



  • 8.  RE: Quantity in Bin Contents NOT in on-hand

    NAVUG ALL STAR
    Posted 11 days ago
    Troy,

    This is perplexing as without looking at the Location Card, you have Bin Mandatory = TRUE, yet the Location has entries without a Bin posted. You cannot turn this Boolean off after Bins are populated. I do know of a way to fix this but it will require a programmer to update the tables directly populating the Bin Code field for those 2 negative entries in the Bin Content Table and Warehouse Entry Table.  The ILE and Value Entry do not have Bin Code on the table. It is not a hard request back to your Partners programmer.

    This is the best suggestion to resolve this issue given the Location is locked with Bin Mandatory and you have these 2 entries that need resolution.
    Thanks,
    Steve

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



  • 9.  RE: Quantity in Bin Contents NOT in on-hand

    SILVER CONTRIBUTOR
    Posted 12 days ago
    Troy,

    You could try Whse. Phys. Invt. Journal and perform Calculate Inventory for just that one item.
    You may find a two bins, one you can adjust negative, and one you can adjust positive, then register.
    That won't affect your inventory. The negative may be sitting in your receive bin.

    ------------------------------
    Joseph Flynn
    Sr. Dynamics NAV Developer
    Gold Star Foods INC
    Ontario CA
    ------------------------------



  • 10.  RE: Quantity in Bin Contents NOT in on-hand

    GOLD CONTRIBUTOR
    Posted 12 days ago
    Joseph,
    We do not have advanced warehouse turned on. The WHSE Phy Journal will not work.

    Thank you for the idea.

    ------------------------------
    Troy Harkness
    Miller Baking Company
    Milwaukee, WI
    ------------------------------



  • 11.  RE: Quantity in Bin Contents NOT in on-hand

    GOLD CONTRIBUTOR
    Posted 12 days ago
    Can you do a Warehouse Inventory Journal?  I saw that you can't do the Whse. Phys. Inv. Journal.

    In our system, I would do a negative Warehouse Inventory Journal entry, and then do a positive Item Journal Entry to offset it.  Your inventory should not change, but you will have removed it from the bin.

    ------------------------------
    Eric Moe
    Global Supply Chain Manager
    Industrial Revolution
    Tukwila WA
    ------------------------------



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