Items Stuck in Adjustment Bin

JMoritz

Greetings,

We have some items that are stuck in a bin called "Adjustment" that ended up there towards the end of 2011 during an asset sale of our company. These items were all adjusted out of inventory as part of a Zero Inventory/Begin Inventory procedure. All of these items have zero quantity, however the net quantity available is still showing up. From reading here we have determined that this is sort of a temporary location, and Navision is trying to find an equal opposite transaction to re-balance the inventory. We have tried adjusting and moving the items in other locations however we cannot get the inventory to even out using the Inventory Journal.

I am wondering if this could be a result of a lack of history related to our asset sale, such as Navision is looking for a record that no longer exists.

Also as a side note; since none of this inventory actually exists the question has been posed can we just delete it (ironically this is the only action we can actually perform, tested on a record with no values)? Since this inventory never existed since the asset sale what consequences, if any, would we face by just deleting them.

Any help would be appreciated
Thanks!

Alex_Chow

You can clear the item in the adjustment bin by running the Functions --> Calc. Whse. Adjustment from the Item Journal. After the adjustments come up, you will need to post the item journal.

To properly get these items out of inventory, you will need to use the Whse. Item Journal instead of the Item Journal.

JMoritz

We run the Item Journal at least every other day and these items never come up, that is why i believe it had something to do with the lack of history that put them here. I have tried running the Whse. Item Journals to adjust the opposite of the adjustment to zero inventory after the asset sale to another bin location but i still cant seem to get the inventory to balance out.

Alex_Chow

JMoritz wrote:

We run the Item Journal at least every other day and these items never come up, that is why i believe it had something to do with the lack of history that put them here. I have tried running the Whse. Item Journals to adjust the opposite of the adjustment to zero inventory after the asset sale to another bin location but i still cant seem to get the inventory to balance out.

Do you mean you run the Calc. Whse. Adjustment process from the item journal? This process will take the quantities in the adjustment bin and put it on the item journal for adjustment.

As a general rule of thumb, you stop entering data into item journal when you enable full WHM. You only use the item journal to run the Calc. Whse. Adjustment at the end of the day.

You probably need to contact your NAV partner and get someone to log in remotely to take a look at these entries. There's more to this story than these entries.

JMoritz

Yes none of these numbers in the adjustment bin are found when we calculate whse. adjustments in the Item Journal, and the quantity cannot be moved or adjusted via movement worksheets, whse. Item Journal, Phys. Inventory Journals, or Whse. Phys. Inventory Journal.

For example one item has -14 quantity, 14 net quantity available, and 0 physical inventory.

Alex_Chow

Yeah, defintely get your NAV partner to log in and take a look. Again, there's more to this story and why they're there in the first place.

JMoritz

We were hoping to avoid going with a consultant, does anybody with an accounting point of view have any input on this?

JMoritz

Or anybody who knows the accounting end of this or who knows about/has experienced a removal of history data previously?

bbrown

JMoritz wrote:

We were hoping to avoid going with a consultant, does anybody with an accounting point of view have any input on this?

Why are you adverse to engaging a consultant/partner? These can be complex problems and engaging an experienced consultant/partner can be the most effective way of resolving your issues.

Alex_Chow

JMoritz wrote:

We were hoping to avoid going with a consultant, does anybody with an accounting point of view have any input on this?

Most people contributes here have accounting and programming background.

The accounting point of view is this:
Something is already fucked up. Get with your partner and resolve this.