Opening Ledger Entries Issues when launch WMS

koalado

Before we start to implemente WMS (Warehouse Management System), we use "Location" logic to manage all inventory related transactions.
So, when we want to change from "Location" to "WMS". we encounter following problems:
1: When we click "Bin Mandatory" option on the location card we'd like to use as WMS, Navision prompts can not do that since there are opening ledger entries. I checked table 32 "Item Ledger Entry" and found all opening ledger entries' <Entry Type> are "Output/Transfer/Sales/Purchase/Positive Adjustment". How should we come cross the problem?
2. Similiar problems when we are going to enable "Item Tracking" in WMS.
On item card, we try to assign an "Item Tracking Code" but got error message "There are one or more ledger entries for this item".
Please advise. Thanks a lot. ](*,)

bbrown

1. As the message states, you cannot turn on bin control for a location that already has activity posted. The existing transactions are missing the required warehouse information. The best course of action is to setup a new location and move the inventory.

2. The system will not let you do this. Same reason as above, unfortunately this is an item wide setting. Best action, create new items and abandon the old ones.

Yes, you could write an update process that created the missing data or changed data required for each of these cases. However, unless you feel you have a good understanding of how Navision's data is structured for each of these situations, I suggest you do not take this approach.

Shenpen

For 3.7 SP1 or A or whatever I saw a batch job in the change log that converted a location to bin mandatory even if there are entries. I think it must be present somewhere in 4.0 too.

koalado

really? Could you please advise where I can get the detailed information?
I searched 4.0 SP1 and 3.7A documents but found nothing.
Thanks in advance.

ara3n

you need to a physical inventory. One where you zero everything out. and second where you are bringingn everything back into inventory.

koalado

I plan just use "Bin Mandatory" since we don't have complicated warehouse structure and related departments are not happy change to use "Warehouse document". OK, then the question is:

*. Which journal or order I should use to do the "transfering" from old location which has opening ledger entries to the new "Bin Mandatory" enabled location.
a)I can not use Item Journal since this journal doesn't include Bin information.
b)I try to use "Whse. Item Journal" or "Whse. Reclass Journal" but got an error message "The locations for warehouse employee ABC are not enabled for WMS." OK, it seems that I must enable "Directed Put-away and Pick" on location card, then I have to use "Warehouse Documents" to do all the transactions. Oops. That's not what I want.
c) In case we have to use "Warehouse Documents", still the question, which journal or order I should use to do the "transfering"?

Help! Thanks a lot ](*,)

ara3n

You need to use item journal. It does have the bin field. Do show column and display the bin field. Also one thing to remember is that with bin mandatory. If you purchase in different unit of measure, you will need to sales in same unit of measure as you purchase. So if you purchase a box of chocolate, you'll need to sale it in box of chocolate from the bins. You can't sell one chocolate at a time. You'll get error that bin content does not exists etc.

If you search the forum you'll find that I have put the code for another user who wanted the bin content to be in item base unit of measure.

koalado

The reason we can not use Item Journal before is due to some customization by consultant. corrected then working.

And we finally create a new location and adjust inventory in old localtion to zero and adjust back in new location. It works

Thanks a lot

ara3n

Welcome