Dynamics F/SCM Customer Experience (CRM) Dynamics GP Dynamics Business Central (NAV) Dynamics SL Power Platform Fabric Copilot

[Pam Bird]

Does anyone else have an issue where an item has a different remaining quantity in the ILEs than the quantity on hand showing in the items list?  We have a few items that show a quantity on the item list but remaining quantity in the ledger entries is zero and does not allow a negative adjustment.

Thanks

——————————
Pam Bird
System Administrator
Clean Control
Warner Robins GA
——————————

[David Wiser]

That’s odd since the quantity on the item list should just be a flowfield looking at the quantity field in the ILE.  One thing that could impact it is if you have “Limit total” set on the list.  This will limit the values included in any flowfield to only those that meet the criteria set.  You could be limiting by a location or one of the other filters.

——————————
Dave Wiser
Controller
Beckwith & Kuffel
Seattle WA
——————————
——————————————-

[Pam Bird]

It is very odd and I would love to know what causes it to happen.  We do not use bin locations and most of our items are in only one warehouse.  Our partner has corrected the quantities on items in the past but it continues to happen randomly.

——————————
Pam Bird
System Administrator
Clean Control
Warner Robins GA
——————————
——————————————-

[Jason Wilder]

Wasn’t quite sure by your post but the “Quantity On Hand” flowfield totals the Quantity field in the ILE.  If you are you saying the “Remaining Quantity” has some values in the ILE then that is a different field and has nothing to do with the “Quantity On Hand”.  If what I said is true then it sounds more like an item application issue, hard to tell without more info.

——————————
Jason Wilder
Senior Application Developer
Stonewall Kitchen
York ME
——————————
——————————————-

[Pam Bird]

On this particular item, “Remaining Quantity” in the ILE is all zero.  The Item List shows quantity on hand as 12.  A negative adjustment is not allowed due to insufficient inventory.

——————————
Pam Bird
System Administrator
Clean Control
Warner Robins GA
——————————
——————————————-

[Ted Johnston]

Do you ever drop ship the item?

In an older version of NAV, some flowfields used the Drop Ship field in the Item Ledger Entry table to filter and other’s did not.  A prior solution center modified our NAV allowing users to break the drop ship process so we had purchase transactions marked Drop Ship and sales transactions not. Thus we ended up with mismatches.

I hope this is not the case for you as the ledger entries are the easier fix. The workflow causing the problem also needs to be fixed.

——————————
Ted Johnston
IT Director
Streicher’s
Minneapolis MN
——————————
——————————————-

[Jason Wilder]

The quick fix would be to have your partner pick the most recent positive entry and stick 12 on the remaining qty field which is sounds like you have done this in the past.  Of course this doesn’t solve the root issue.

I am guessing that the entry that is messed up does not have an item application entry associated with it (Navigate, Applied Entries).  If you could find out which entry fits this scenario you might be able to get closer to the issue.

Sorry, not much help.

——————————
Jason Wilder
Senior Application Developer
Stonewall Kitchen
York ME
——————————
——————————————-

[Greg Enns]

Hi Pam,

In order to find the source of the problem, I would start by reviewing the definition of the “Quantity On Hand” field in the Item table to make sure it has not been changed/customized in a way that is causing this problem. In the Item table this field is actually called “Inventory” (Field#68). 
In stock NAV this field is defined as follows: 

Sum(“Item Ledger Entry”.Quantity WHERE (Item No.=FIELD(No.),Global Dimension 1 Code=FIELD(Global Dimension 1 Filter),Global Dimension 2 Code=FIELD(Global Dimension 2 Filter),Location Code=FIELD(Location Filter),Drop Shipment=FIELD(Drop Shipment Filter),Variant Code=FIELD(Variant Filter),Lot No.=FIELD(Lot No. Filter),Serial No.=FIELD(Serial No. Filter)))

Next I recommend comparing all the Item Ledger Entries for this Item and looking for any differences that could be causing this. I would filter the Item Ledger Entries just on the Item No. and then export to Excel for analysis. Be sure to show as many columns as possible–and definitely be sure to have Global Dim 1, Global Dim 2, Location, Drop Shipment, Variant Code, Lot No, Serial No. since these fields are part of the filter for Quantity on Hand.

I would also check the Change Log on the problematic Item. Perhaps someone/something changed something that is causing this?
I would also compare this Item against other similar items that are not having the problem. Look for a difference between the items that could be causing this.

I hope you’re able to find the source of the issue. Best of luck!

——————————
Greg Enns
ERP Coordinator
Technical Prospects
Kaukauna WI
——————————
——————————————-