I am looking to assess our daily cycle count accuracy. As such I need to determine how many items / bins from each days count required an adjustment compared to those items / bin locations that did not require any adjustments. My question is how can I determine how many items did not require an adjustment? I am currently extracting data from the Ledger Entry table in to Excel to determine which items were adjusted each day. The only idea I have had is to use the Last Count date for each item from the Item table to determine how many items were counted on a particular date.
Using Nav 2009 R2
Any ideas welcome