Cycle Count History

Hello All

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
Sign In or Register to comment.