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

[Samuel Champoux]

?Hi,
Still a little new to NAV, I was wondering how we could have this :

Where are the missing 4?

——————————
Samuel Champoux
Drummondville QC
——————————

[Lewis Rosenberg]

?Do you have any other (Warehouse) Locations that do not have bins?

——————————
Lewis Rosenberg
IT Manager
Mars Fishcare
Chalfont PA

NAVUG Board of Advisors, Programming
NAVUG Programming Committee
NAVUG Membership Committee
——————————
——————————————-

[Samuel Champoux]

?Yes it seems some of the locations do not have bins.
I tested and added a bin to each of them but I still don’t see where the inventory is.
Is there a list of inventory per warehouse somewhere?

——————————
Samuel Champoux
Drummondville QC
——————————
——————————————-

[Lewis Rosenberg]

?Locations can only use bins if the Bin Mandatory box is checked on the Location Card.

To see inventory by (Warehouse) Location, go to the Item List or Item Card and Navigate to Items By Location:

xxx

——————————
Lewis Rosenberg
IT Manager
Mars Fishcare
Chalfont PA

NAVUG Board of Advisors, Programming
NAVUG Programming Committee
NAVUG Membership Committee
——————————
——————————————-

[Samuel Champoux]

?The 10 units show up in USINE in the Items by Location.
And the Bin Mandatory is checked on the USINE location.

——————————
Samuel Champoux
Drummondville QC
——————————
——————————————-

[David Wiser]

Navigate to the Warehouse Entry table and filter for that Item number.  Does this show the 10 units?  If so, what bins are shown for the item?  If they do not show, is it possible that the “Bin Mandatory” flag was set after quantity was added to the location?  This shouldn’t be possible, but you never know.  Whenever the Bin Mandatory flag is set for the location, the Warehouse Entry table start capturing transactions involving the movement into or out of bins, so hopefully your answer will manifest itself there.

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

[Katarzyna Rola]

Hi Guys,

Item By Locations uses Item Ledger Entry.
Quantity on Hand uses Item Ledger Entry.
Bin contents uses Warehouse Entry.
Bin contents does not show Adjustment Bin Code.

My guess is that someone has already registered Warehouse Item Journal but forgot about Item Journal.

What you can do is to check Bin Contetns once again. On the bottom of the page,there should be a flowfield created: Qty. on Adjustment Bin. If not available there – export Warehouse Entries to Excel, create pivot table and check on which bin qty is positive or run Calculate Whse. Adjustment (Item Journal Page) for Bin Mandatory Locations and check whether something is in Adjustment Bin

——————————
Katarzyna Rola
Dynamics NAV Developer
Trio Line Polska Sp. z o. o.
——————————
——————————————-

[Samuel Champoux]

?I’m on NAV 2013. I don’t see any mention of Adjusment bin or Calculate Warehouse Adjustment.

I guess I would have to find a way to compare item transactions with warehouse transactions and find where it doesn’t match.

——————————
Samuel Champoux
Drummondville QC
——————————
——————————————-

[Lewis Rosenberg]

?Whenever there is a registered entry on the Warehouse Item Journal, it must be followed up with a Item Journal posting using Actions > Calculate Whse Adjustments to popuate the Item Journal.

——————————
Lewis Rosenberg
IT Manager
Mars Fishcare
Chalfont PA

NAVUG Board of Advisors, Programming
NAVUG Programming Committee
NAVUG Membership Committee
——————————
——————————————-

[Samuel Champoux]

I’m not sure we can even use Item journals, when I try I get this:

The locations for warehouse employee SCHAMPOUX are not enabled for WMS.

——————————
Samuel Champoux
Drummondville QC
——————————
——————————————-

[Val Gameiro]

The Item Journal shouldn’t require WMS. Are you trying to use t he Warehouse Item Journal? 

Are you guys using Advanced Warehousing, or just Bins? If you’re using Advanced Warehouse then there’s more setup needed.

——————————
Val Gameiro
Senior NAV Analyst
BPL Plasma Inc.
Austin, Texas
NAVUG Austin Chapter Leader
——————————
——————————————-

[Val Gameiro]

Like said, if the items were  entered without a Bin, then you’ll need to “move” them into a Bin.

If they are in a Bin, is it a valid Bin? Or did someone delete that Bin name? If it matches the Location and Bin codes on your Page, they should show up.

If you drill down on the 0 quantity, look at the filters there. Drop one and then the other until you see your Quantity. That’ll tell you which filter/field is incorrect and needs fixing.

——————————
Val Gameiro
Senior NAV Analyst
BPL Plasma Inc.
Austin, Texas
NAVUG Austin Chapter Leader
——————————
——————————————-

[Samuel Champoux]

I can’t find any Warehouse Entry that would have a deleted bin.

I’m not sure how I can move them into a bin without adding an Item Ledger Entry, is it possible to do?

——————————
Samuel Champoux
Drummondville QC
——————————
——————————————-