How to run Inventory No-Movement Report

[MCMITAudit]

Does Macola have an Inventory report which shows items with no movement, I believe they do but don't know where/how - any assistance would be greatly appreciated.

Thanks

 

[NEmacGuy]

Not exactly that I am aware of.
Closing report would be to use ABC analysis. Would involve running a it as the process, then running it as the report for C items only. Otherwise, would be a perfect crystal / excel report to create.
You would want to think how would you define movement, over what time frame. I normally may look at usage. If this worked, then I would make a judgement call if I trusted the accumulators, this would give me this year and last year usage. If I wanted more than this I would head to the inventory transaction file which get a litle bit more difficult.

 

[dgillz]

You can write a crystal report for non-moving inventory by linking the IMINVLOC_SQL and the IMINVTRX_SQL and capturing only those items hat have not had a transaction in X number of days.

Software Sales, Training, Implementation and Support for Macola, Synergy, and Crystal Reports. Check out our Macola tools:

http://www.gainfocus.biz/exceladdin.html