ICFREEZE Table in SCM

 2 Replies
 0 Subscribed to this topic
 38 Subscribed to this forum
Sort:
Author
Messages
Robby
Veteran Member Send Private Message
Posts: 87
Veteran Member

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 Send Private Message
Posts: 111
Veteran Member
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 Send Private Message
Posts: 87
Veteran Member

PERFECT!!

 

Thanks!!

 

-Robby