Prev
Next
Forums Supply Chain Management Lawson S3 Supply Chain

Cycle counting - invenotry value IC233 vs frozen total dollar amount IC175

 7 Replies
 1 Subscribed to this topic
 38 Subscribed to this forum
Sort:
Author
Messages
Johnmac
Advanced Member
Posts: 35
Advanced Member
9/30/2015 4:46 PM

    I am in the process of conducting YE physical inventory count.

    I ran an IC233 report to identify the current inventory value.

    I then counted the inventory and submitted the variances (IC175). At the bottom of the IC175 report the "Location total dollar frozen" is different than the IC233 total inventory dollar amount. Shouldn't these two total dollar amounts be the same?

    Johnmac
    Advanced Member
    Posts: 35
    Advanced Member
    10/2/2015 3:38 PM
      Answer - items that are inactive in IC12 are not frozen when IC170 runs
      JonA
      Veteran Member
      Posts: 1163
      Veteran Member
      10/2/2015 3:48 PM
        But items that are inactive in IC12 should also have no SOH so they wouldn't be included in the SOH value calculation in IC233.
        Jon Athey - Sr. Supply Chain Analyst - Materials Management - MyMichigan Health
        Johnmac
        Advanced Member
        Posts: 35
        Advanced Member
        10/6/2015 5:46 PM
          Unfortunately some of the inactive IC12 records have SOH which is why I ran into this issue..
          SCMaster-jk2
          Veteran Member
          Posts: 100
          Veteran Member
          12/21/2016 8:52 PM
            This is an old thread but we're having the same issue. No inactive items have stock in them though. I guess I don't know how exactly to read the IC175, how is the Location Total Dollars Frozen calculated? When I sum the freeze quantities * cost, I get a much lower number than the total dollars...
            Mike Bernhard
            Veteran Member
            Posts: 101
            Veteran Member
            12/21/2016 9:36 PM
              IC175 only shows EXCEPTIONS (records where count qty <> freeze qty).
              Bill Ianni
              Veteran Member
              Posts: 111
              Veteran Member
              12/21/2016 9:50 PM
                The Location Total Dollars Frozen is a calculation of the frozen qty * the cost from ICRECEIPTS (if Company Costing Method is LIFO or FIFO) or ITEMLOC (if the costing method is AVG).
                Mike Bernhard
                Veteran Member
                Posts: 101
                Veteran Member
                12/21/2016 9:58 PM
                  By the way, download the ICFREEZE table if you want to see all the freeze records in Excel.