I am looking for a way to determine what the financial result of a cycle count will be, prior to actually processing the count.

I've been performing a manual calculation by importing the cycle count check report into Excel and then performing a vlookup function to get the standard cost by item.

Can anyone tell me if there is quicker and less tedious way of getting this info?

Thanks!

You can generate an Easy SQL query like this...

select tdilc501.item, tdilc501.cwar, tdilc501.loca,
tdilc501.clot, tdilc501.qstk, tdilc501.cstk,
tiitm001.dsca, tiitm001.copr
from tdilc501, tiitm001
where tdilc501.item refers to tiitm001

The output of this can be taken to excel and then it can be analyzed by Item, Warehouse, etc. Alternatively, you can also create a print session based on the tdilc501 & tiitm001 tables.

I have created several reports on the cycle counts sorted by Warehouse, by Location, by Item, by Item Group, by Item Type, etc.

Ram.