Prev
Next
Forums Supply Chain Management Lawson S3 Supply Chain

ICFREEZE Table in SCM

 2 Replies
 0 Subscribed to this topic
 38 Subscribed to this forum
Sort:
Author
Messages
Robby
Veteran Member
Posts: 87
Veteran Member
7/31/2015 3:22 PM

    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?

    Bill Ianni
    Veteran Member
    Posts: 111
    Veteran Member
    7/31/2015 4:08 PM
      This would be in ICTRANS (BEFORE QTY for trans type = PI) It's a big table though, and you might need a good query tool to form the basis of a report.
      Robby
      Veteran Member
      Posts: 87
      Veteran Member
      7/31/2015 5:46 PM

        PERFECT!!

         

        Thanks!!

         

        -Robby