SCM Reporting - Cycle Count Variances

Sort:
You are not authorized to post a reply.
Author
Messages
Robby
Veteran Member
Posts: 87
Veteran Member
    Since this is a reporting question pertaining to SCM, I posted in both places in hopes of finding someone who knows just what I need!

    I'll let you know up front, I'm new to reporting for Supply Chain, so if this is too easy of a question....don't hold that against me!


    The business wants me to create a report (custom, of course!) to highlight the cycle count variances. Apparently, Lawson only tells you 0 (zero) variance if your count is greater than the expected count.


    But, here's my question, the data I want is in the ICFREEZE table (fields: FREEZE_QTY & COUNT_QTY).

    Come to find out, this table is wiped clean at the end of the cycle count process. Does this information 'live' somewhere else for 'historical' purposes?
    You are not authorized to post a reply.