Cycle Counting Journal Lock

(0) Share

Report

Posted on by Ankit Batra

1,561

Hi,

In AX even when cycle counting lock on inventory and warehouse parameters is not checked, system does not allow putting the same item - item warehouse combination on two different counting journals.

In warehouse items for this item counting started gets checked and journal name to which it is added gets updated. Till the time this is checked system does not allow addition of the same item warehouse item to another journal.

If we do a customization to remove system for updating this check box will there be any adverse impact on inventory transactions?

Any inputs will be appreciated.

Thanks

*This post is locked for comments

I have the same question (0)

All responses (6)

Answers (0)

Guy Terry 28,924 Moderator on at

Like (0)

Report

Hi Ankit,

Are you using the 'Counting' journal functionality (Inventory management -> Journals -> Counting) or the new 'Cycle count' functionality in R3 (Warehouse management -> Periodic -> 'Cycle count work by item', for example)?

Was this reply helpful? Yes No
Ankit Batra 1,561 on at

Like (0)

Report

I am using WMSII and not R3. I am creating counting journals.

Was this reply helpful? Yes No
Suggested answer

Weaveriski 23,620 Moderator on at

Like (0)

Report

The downside is there is no check - so if you overlap your multiple journals you can have the same item in the same warehouse twice on different journals and therefore any differences are duplicated. It is a change however I have made a number of times (commenting out the counting started update). If you do setup warehouse items so there is a record per warehouse and then count by warehouse it will allow the same item on two journals at two different warehouses - just not within the same warehouse if you were to split by location for example. If you have no warehouse item record set it sets the counting started on the blank record and stops any subsequent return onto a counting journal for the same item.

Was this reply helpful? Yes No
EdVW on at

Like (0)

Report

Steven, where do I comment out the "counting started update" as mentioned in your post? We want to be able to count the same product in multiple count sheets in the same site and I believe this is our solution, but I wasn't able to find the code you're referring to above. Any help would be greatly appreciated!

Was this reply helpful? Yes No
Weaveriski 23,620 Moderator on at

Like (0)

Report

It is the code that sets the counting started flag when generating the counting journal lines, I cannot remember but should not be that difficult to find.

Was this reply helpful? Yes No
Suggested answer

EdVW on at

Like (0)

Report

Thanks to Steven's response, I was able to figure out how to change track down some code so that we can do counting journals for the same item/site combo. The Counting Started flag was what helped, however we couldn't use that as we'd have to set it for many different item/warehouse combos each time we do a physical inventory. What I did was update the updateStartCounting method in the InventItemLocationCountingStatus table. For the line that has "inventItemLocationCountingStatus.CountingStarted = NoYes::Yes;", I changed the Yes to No, "inventItemLocationCountingStatus.CountingStarted = NoYes::No;". This means that whenever the updateStartCounting method is evoked, rather than setting the CountingStarted field to Yes, it sets it to No so that it is never set to Yes. This way, the user can start journals for whole areas of a warehouse by location range, having another journal set for another location range for a full physical inventory.

Now, there is a risk associated with this code as you could count the same item/location twice, but our company assumes this risk. We always count by location ranges, so we wouldn't count the same item/location twice.

Was this reply helpful? Yes No