Cycle Count Statistics

I am attempting to write a query the looks at how many cycle count were performed during a specified time frame and the number of items counted. In researching, I did not come across a table that actually tracks historical cycle counts. The ICTRANS will show physical inventory adjustments, but only for the exceptions. Is anyone aware if this information is housed in Lawson?

Find more posts tagged with

Comments

jon-athey

That would be good information but Lawson does not store cycle count history data. But if your staff uses the handhelds and uploads cycle counts into MSCM there is a report in MSCM that might get the information you need.

0712131256598360.doc

StephanieD

There is an icaccuracy table with counts by period, but this was not detailed enough for what we needed. We ended up creating a custom trigger on icfreeze, which stores the data from every count, along with datetime, in a custom table.

0712131256598360.doc

dechevar

Thank you both for the feedback. Stephanie, would you be willing to share the functional design for your custom table/trigger?

0712131256598360.doc

StephanieD

Here is the trigger on icfreeze that populates our custom table icfreeze_history.

0712131256598360.doc

Copyright © 2025 Infor. All rights reserved.