AX 2012 R2 CU7
We are curious as to how do other companies deal with changes to their inventory locations? Over the last couple years, we have had to move products from one location to another. I'm pretty sure this isn't an uncommon process.
But when we run our Cycle Count, even though part A is now only new the NEW location, a record is also created for part A at OLD location. When we select records for Cycle Count, we do it by a range of locations which usually includes both the OLD and NEW. We've tried it by Counting Groups as well with the same result.
Below is a sample snippet. This part used to be in Location D508B, but was moved to Location D509K. Yet both locations appear on the Counting journal.
What we expect is that the only locations that would show up on the Cycle Count would be the Location set up as the Released Product's Picking Location based on its Counting Group. And not a record for every combination of the Released Product and what might have been its prior Picking Locations.
For some reason (and it would be wonderful to understand), all of our parts have an empty record in their Warehouse items list. Perhaps this is causing the problem? For this record, there are no default locations assigned.
Product information management > Common > Released productsManage inventory – Warehouse – Warehouse items
I noticed when we run Inventory and warehouse management > Inquiries > On-hand, there is no Counting group listed for any Released Product. Also, the Counting date is not correct. This part was counted 7/27/18 yet shows 2/25/16 via the On-hand inquiry.
There was a count for it on 2/25/16 as well.
It seems like the On-hand inquiry doesn't necessarily look at the most recent related records to the released product.
When you create various inventory journals, Inventory and warehouse management > Journals > Item transaction > xxx, select the Location drop down and On-hand tab, AX knows what location has quantities for the part.We are looking for suggestions that would enable us to only have Locations associated as the Picking Locations on Released Products be selected as part of the Cycle Count. If any Location is no longer assigned to a Release Product, we do not want it to be a record created for the count.
We don't see any way to mark either Locations or the combination of Released Product/Location as disabled. Is it there and we are missing it?Thanks,Carol