Inventory counting journals AX 2012 R2

(0) Share

Report

Posted on by CU14050944-0

Hi,

littel question:

we have Item A stocked in Warehouse WA and WB.

When creating a inventoury counting Journal for WareHouse WA, in table "InventItemLocationCountingStatus" the item is marked for counting. So whrn i create the Journal for Warehouse WB the item will not Show up.

How can i avoid this ( without manualy remove the marked in the table)?

Thanks

Pirmin

*This post is locked for comments

I have the same question (0)

All responses (7)

Answers (1)

Suggested answer

Denis Macchinetti 16,444 on at

Like (0)

Report

Hi Pirmin

In order to avoid this issue, you have to define the warehouse related to the items, on "Warehouse Items" form.

If you define the warehouses, AX check the InventItemLocationCountingStatus table using the proper warehouse, otherwise use the default.

Was this reply helpful? Yes No
CU14050944-0 on at

Like (0)

Report

Hi

do i Need to set up this per ittem? we have about 20000 items and 50 warehouses ...

thanks

Pirmin

Was this reply helpful? Yes No
Verified answer

Denis Macchinetti 16,444 on at

Like (0)

Report

Hi Pirmin

Yes.

However, you can create a easy job that create for each item\warehouse a record on Item warehouse table.

Also, you can trigger the item\warehouse insert event and create automatically the record on item warehouse table.

Was this reply helpful? Yes No
CU14050944-0 on at

Like (0)

Report

Hi

hmm thats bad. Ok thanks for the answer. I'll look around and see if i find somewhere a script on the net ..

thanks

Pirmin

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

Like (0)

Report

Or you can get the system to NOT set the counting started flag in the warehouse item record when a counting journal is started (You could manually untick it as well but not great for a mass count). Not as pretty a solution but I believe it used to be commenting out two lines of code (but I have a bad memory and I am not a developer).

Was this reply helpful? Yes No
CU14050944-0 on at

Like (0)

Report

Hi

ok seems i'll use the SQL script to rest the check box ..thanks

Regards

Pirmin

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Hi Pirmin,

Which table and field you have to update.

Thanks,
Ray

Was this reply helpful? Yes No