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

[Lewis Rosenberg]

How do you fix inventory when the total qty for an item in the open Item Ledger Entries balances with the Warehouse Entries, but the Warehouse Entries have three lots (with inventory) that don’t exist in the Item Ledger Entries….  Also, another lot has a completely different warehouse location in the item ledger entries than the warehouse entries?

 

So to simplify that statement:

 

I have three lots for an item, we’ll call them Lot A, B, and C.

The inventory in lots A,B, and C have open (on hand) inventory amounts in the Item Ledger Entries that equal the inventory in lot Z in the warehouse entries.

Lot Z does not have any inventory according to the Item Ledger Entries.

 

Also – Lot H is in the QA warehouse in the Item Ledger Entries but the Warehouse Entries show it in Whse FG.

 

When I run Calculate Whse Adjustments in the Item Journal, I do not get anything.

 

NAV2013r2
Base UOM=EA
FG Whse is directed putaway and pick, putaway UOM=CS (Item has 6ea per cs)
QA whse just has bin control

It must be Monday…I don’t believe what the calendar says.

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

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

[Jason Wilder]

Can you use the Item Reclass Journal or the Whse. Rclqss Journal to fix this?

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

[Crystal Tollison]

?I’m with Jason, use the Reclass Journals.

——————————
Crystal Tollison
Consultant
ArcherPoint Inc.
Lawrenceville GA
——————————
——————————————-

[Eric Moe]

I would do a Warehouse Journal adjustment to zero all inventory of the item, then do the corresponding Item Journal adjustment.  Then, add the item back in to the proper bins with the Warehouse Journal and do the Item Journal again, being sure the costs match on steps 2 & 4.  

You will break the cost tracking, but it should clean up the inventory/location entries.

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

[Lewis Rosenberg]

?Thanks for the imput!

We had our partner help with this.  Standard NAV functionality would not work because the lot numbers did not match up between whse entries and item ledger entries.  As for the item that was in the QA location in the ILE and FG in whse entries, that fixed itself.  (Someone was probably in the middle of a transaction when I was looking at it).

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

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