Multi Location Stock Counts

Latest Axapta / Dynamics AX FAQ Pages

Get our Free Newletter

Don't you have the time to be online here at DUG every day? So how do you follow what is going on in the Dynamics industry and community?
If you subscribe to the DUG Newsletter then you can relax! We will make sure that you don't miss the big news!

Check out our
Newsletter Subscription Center
page a complete list of our different newsletters.

This post has 14 Replies | 0 Followers

Male
10 Posts
110 Points
Joined: 2003-6-24
Last Online:
2007-3-13 7:40
Location: Liverpool United Kingdom
Mike Pendray Posted: 2004-1-16 12:41 | Locked
We have just found out that we are unable to count the same stock item at more than one warehouse at any one time.
As soon as the first warehouse starts to count and creates a journal the item code is locked for new journals to count not only at that warehouse but at all other warehouses within the company.

I cannot understand it. The table in question (InventItemLocation) has a field called InventItemID, but instead of being populated with and ID that relates to the warehouse being counted, it takes the value "Axapta" and locks all the warehouses. The machinery is there to lock by warehouse, but it is not being used.

Is this not a major irritation to other users, or have we got it wrong and there is a parameter we need to set differently?

We are Version 3.0 SP1

Mike
Male
2,154 Posts
47,017 Points
Joined: 2003-1-21
Last Online:
2014-4-22 12:06
Location: Herts, England
Moderator
Harish Mohanbabu replied on 2004-1-16 13:45 | Locked
Hi Mike,

There is nothing wrong with InventItemLocation. Just make sure that you have created separate lines for each warehouse under Stock management -> Setup -> Stock breakdown -> Warehouses.

Hope this helps.

Cheers,

Harish Mohanbabu

Harish Mohanbabu
Long way to go before I sleep ..

View Harish Mohanbabu's profile on LinkedIn

28 Posts
222 Points
Joined: 2003-5-27
Last Online:
2007-3-13 7:32
Location: manchester United Kingdom
les shippen replied on 2004-1-16 15:10 | Locked
Harish,
I can't find the Stock Breakdown step in the sequence Stock management -> Setup -> Stock breakdown -> Warehouses. Is that in v3.0?

Cheers,
Les
Male
2,154 Posts
47,017 Points
Joined: 2003-1-21
Last Online:
2014-4-22 12:06
Location: Herts, England
Moderator
Harish Mohanbabu replied on 2004-1-16 15:41 | Locked
Les,

You are right. This is ver 3.0.

Regards,

Harish Mohanbabu

Harish Mohanbabu
Long way to go before I sleep ..

View Harish Mohanbabu's profile on LinkedIn

Male
10 Posts
110 Points
Joined: 2003-6-24
Last Online:
2007-3-13 7:40
Location: Liverpool United Kingdom
Mike Pendray replied on 2004-1-16 16:35 | Locked
Hello Harish,
Yes we have the warehouses created in Stock management / Setup / Stock breakdown / warehouses. Is there any setting here that is relevant?

My problem is that when we create a count journal the entry in InventItemLocation sets the InventDimID to Axapta. The record named Axapta in InventDim has the warehouse field showing blank. We have other InventDim records that show the warehouses and leave other fields blank. I cannot see why InventItemLocation should not point to these instead.

Best Wishes
Mike
Male
39 Posts
195 Points
Joined: 2003-5-20
Last Online:
2007-10-4 21:15
Location: Överkalix Sweden
Peter Karlsson replied on 2004-1-19 10:37 | Locked
Hi.

I have the same problem with counting.
It seems that one stock item can't be in more than one journal at the time. If you create a second journal and manually create a journal line with the item (that allreade exists in another journal) you get the message "Warning: Item X is locked for updates in warehouse X, as it is being counted".
I have not found any "work around" for this problem.
Anyone ?

/Peter Karlsson
Male
2,154 Posts
47,017 Points
Joined: 2003-1-21
Last Online:
2014-4-22 12:06
Location: Herts, England
Moderator
Harish Mohanbabu replied on 2004-1-19 10:52 | Locked
Hi Mike / Peter,

Try this -

1. Go to the Item Master form

2. Select the Item that you want to count and go to 'Setup ->
Warehouse Items'

3. Create a line for each warehouse

Now try counting journals. This should work.

Regards,

Harish Mohanbabu

Harish Mohanbabu
Long way to go before I sleep ..

View Harish Mohanbabu's profile on LinkedIn

179 Posts
980 Points
Joined: 2002-7-23
Last Online:
2006-10-31 6:29
Adam Seaton replied on 2004-1-19 11:11 | Locked
I queried this the other month with MS. The response was that the system is working as designed, but I do have a detailed response on how to remove the code.

You just need to be sure that you have business processes in place to prevent the same item (in the same location) being added to two different journals. If you can be sure of this then it is not a big job to remove the validation code.

Drop me an e-mail and I'll respond to you directly if you would like the full details.

Male
217 Posts
22,759 Points
Joined: 2001-7-11
Last Online:
2008-2-7 13:52
Location: Vienna, Austria
Helmut Wimmer replied on 2004-1-20 9:59 | Locked
Hi!
Check the following parameter:
Inventory Management/Parameters, General tab page: "Lock item during count"
Make sure it is unchecked if you don't want to lock the items during counting.
Best regards and have nice day! Helmut Wimmer Dynamics AX MVP http://axaptafreak.blogspot.com
179 Posts
980 Points
Joined: 2002-7-23
Last Online:
2006-10-31 6:29
Adam Seaton replied on 2004-1-20 10:42 | Locked
I don't think that parameter is related to this problem. This parameter prevents movement of the stock item during the count - but doesn't effect the functionality of the item in relation to multiple count journals.

20 Posts
124 Points
Joined: 2003-12-17
Last Online:
2007-3-13 8:34
Location: Jakarta Indonesia
AFEN replied on 2004-1-20 12:04 | Locked
Hi Mike.
I agree with Adam, the "Lock Items during Count" is not meant to prevent the multiple counting journals for an item. I gather from the manuals is that "When you have created counting lines for an item, no other lines can be created until the lines are posted or deleted." So in case you want to do the stocktaking for an item with multiple warehouses you have to create multiple journal lines in one journal number. One of the problem is that you can't select for a certain warehouse when you want to print the Counting List.
20 Posts
124 Points
Joined: 2003-12-17
Last Online:
2007-3-13 8:34
Location: Jakarta Indonesia
AFEN replied on 2004-1-20 12:18 | Locked
Hi Mike, great news for you is that after i read further that YOU CAN CREATE COUNTING JOURNALS WITH MULTIPLE WAREHOUSES FOR AN ITEM. Here is the way:
1. In the item master go to Setup button > Warehouse Item. Here you create new line for each warehouse with different counting group. So different warehouse is counted using different counting group. In the item master tab General, there is Count Group. I think that's the default in case you want to calculate the item for all the warehouses.
2. Create the counting journal for each warehouse.

Hope this helps!
Male
10 Posts
110 Points
Joined: 2003-6-24
Last Online:
2007-3-13 7:40
Location: Liverpool United Kingdom
Mike Pendray replied on 2004-1-20 14:21 | Locked
Thanks Harish, your third post has the answer.
Thanks Afen, Your second post has the answer.

Item Form / Setup / Warehouse Item seems to do the trick.
Interestingly you can set up records for different configurations in the same warehouse, but there is no need to, unless you want them to belong to different counting groups.
Male
39 Posts
195 Points
Joined: 2003-5-20
Last Online:
2007-10-4 21:15
Location: Överkalix Sweden
Peter Karlsson replied on 2004-1-20 15:06 | Locked
Nice,

I would have been strange if it was impossible.
Thanks!

/Peter Karlsson
Male
10 Posts
110 Points
Joined: 2003-6-24
Last Online:
2007-3-13 7:40
Location: Liverpool United Kingdom
Mike Pendray replied on 2004-1-20 17:43 | Locked
There is a postscript to this.
We have about about 4,000 stock items, some of which exist in only one location, but many are in several. I think we need to create about 4,000 new entries in InventItemLocation.
wheras this is quite possible using the forms, somehow the spreadsheet import routine rejects more than one entry per stock item.
Page 1 of 1 (15 items) | Get this RSS feed | Bookmark and Share