It appears that these reports do not include transfers or variances; is that correct or have I missed someting in the set up before running them?
Do you mean Historical Stock Status? It should reflect variances and transfers. Are you sure all the Report Options are set properly? Item number range, Site ID range, etc, etc?
Frank E. Hamelly, MCP, MCITP, MCT, MVP
No, The report I ran is entitled "Historical Inventory Trial Balance Detail".
Okay. What version GP are you on? Is this your first time to run the report?
10.0 . . .no this is not the 1st time i've run the report, but this is the first time that I've noticed that transfers and variances are missing from the report. I don't know if they have been there before either.
Do you know if the HITB reset was performed prior to start of using the report?
What is that? I did not do it . .and I'm 99% certain no one else would have . . .this is the first time I've ever heard mention of it.
Okay, the IV reset utility is required to validate inventory transactions & balances prior to running the HITB report in GP, IF you're on a version prior to GP 2010 R2. Sounds like you need to do that. Here's a link that explains the process and additonal information on how to do the IV Reset - blogs.msdn.com/.../tips-on-inventory-stock-counts-and-hitb.aspx
Actually, now that I think about it, you shouldn't even be able to run the HITB if the IV Reset has never been done. What service pack is your GP 10 on?
One additional way to verify that HITB process has been run is to check SEE99997 table for multiple records.
If you query the SEE30303 table for that particular item, do you see any of the missing variances or transfer records? Perhaps the report format makes it difficult to see where they reside?
Other Microsoft Sites
I'm a Customer
I'm a Partner
Use the official Twitter tags:
#MSDYNCOMM | #CONV13