Warehouse Management Module Question

davisj · 2007-01-11

Hi All...

My company is using the Warehouse Management module and we are having some difficulties with posting inventory transactions (Consumption Journal, Item Journal & Physical Inventory Journal).

The issue is that any time we post one of these types of transactions the system is not updating the Bin Contents with the change to inventory. That leads to a disconnect between the Item Card Inventory (Qty. on Hand) value and what the Bin Contents total up to.

We are on 4.0 with the SP1 execuitable only.

Is this an issue that has been fixed by one of the service packs or is it possibly a setup issue?

Any help would be great

Thanks in advance!

ara3n · 2007-01-11

I have a client that is on sp3 and they are using whse. mgt. and creating warehouse picks for Released production orders, they register the picks and post the consumptions and output, and it works fine.

raj2000be · 2007-01-11

When you post journal transactions in the warehouse module using the Whse. Item Journal or the whse. Physical Inventory journal the system does not update the Item Ledger Entries. This is a standard feature built in the system to avoid the over population of the Item ledger with a lot of entreis.

To update the Item Card Quantity, you have to periodically use the Calculate Whse. Adjustment batch job available in the Functions button of the Item Journal. This will calculate and populate one consolidated journal line per item and the item card quantity is updated only when this journal is posted.

Regards
Rajesh

ara3n · 2007-01-11

the bin content is created or upddated based on warehouse entry table, and not item ledger.

raj2000be · 2007-01-11

Thats right aran, I never said otherwise. But the Bin contents do not update the Item ledger and hence the quantity on the item card. Thats why you would have to run the calculate whse. adjustment batch job to update the item card quantity to match the bin content.

Regards
Rajesh

ara3n · 2007-01-12

ic I misread it

He wrote

The issue is that any time we post one of these types of transactions the system is not updating the Bin Contents with the change to inventory.

which led me to believe that the bin content info wasn't correct.

And yes Item Ledger and Warehouse Entry can go out of sync. If you are doing warehouse adjustment or warehouse physical for location that are setup with pick and putaway.

Production consumption on the other hand creates the item ledgers so that wouldn't be an issue.

davisj · 2007-01-12

All... Thanks for the feedback

. I was unaware of the Calculate Whse. Adjustment batch job. I am going to play around with this.

ara3n · 2007-01-12

If you are using lot tracked inventory or serial no. Make sure it calculates the correct value. Last time I checked, it didn't, and the report had to be changed.

Warehouse Management Module Question

Comments

Categories