Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

ICIVAL.STKQTY does not match ICILOC.QTYONHAND 1

Status
Not open for further replies.

johnhugh

Technical User
Mar 24, 2010
702
SG
Hi,

I'm using Accpac 5.6 and get an ICIVAL.STKQTY does not match ICILOC.QTYONHAND error when running the data integrity report.
I remember having this issue before and think KB 20785 refers to the same issue as well.
I can't find the KB article anymore and neither can I find the hotfix.
Anyone here that can help?

 
Thanks for that tuba. Much appreciated.

The macro did not fix my error though, although it's a bit more complicated I think.
The item valuation report when run as Location Detail Costs is correct.
When run as transaction cost the value/qty on the report differs from what is in IC.

Those items in question are actually non stock items which were set up incorrectly.

In order to "fix" my problem I'll delete all references to those items in table ICIVAL and ICILOC.
Then the IC valuation report and Integrity report will be correct.

What do you think?
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top