PrevPrev Go to previous topic
NextNext Go to next topic
Last Post 07/31/2015 12:07 PM by  Robby
SCM Reporting - Cycle Count Variances
 0 Replies
Sort:
You are not authorized to post a reply.
Author Messages
Robby
Sr. Technology Consultant
Avaap
Veteran Member
(209 points)
Veteran Member
Posts:87


Send Message:

--
07/31/2015 12:07 PM
    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.