Prev
Next
Forums Supply Chain Management Lawson S3 Supply Chain

Inventory Control Basics

 3 Replies
 0 Subscribed to this topic
 38 Subscribed to this forum
Sort:
Author
Messages
btaylor
New Member
Posts: 4
New Member
2/2/2018 3:04 PM

    To preface this, I’m completely new to the Infor / Lawson system when it comes to Replenishment & Inventory Control – the company I used to work for utilized a custom version of FilemakerPro.

    Our company is trying to build an Inventory Control system from the ground up, and I’ve been tasked with helping. We’re a bank, so we have several ship to locations, cost centers and general ledgers that are associated within our system.

    My problem is that when I make an issue in IC21, it’s not reflected in the GL90 for the Cost Center or GL. It is also not showing up in IC40 as available for that other location.

    Any ideas on what I’m doing wrong?

    Thanks in advance!

    Ben

    Tags: inventory control, issues, cost center, general ledger
    Kat V
    Veteran Member
    Posts: 1020
    Veteran Member
    2/2/2018 3:31 PM
      IC21 releasing does not post to the GL. IC130 must run with a date to include the gl date on the IC21 header.

      If that is happening and there is still no GL entry: On the IC12 for the location and item you are issuing out, there should be a GL Category. Take this code and go to IC04.

      On IC04, it sounds like your Inventory Account (where the product sits) and the Issues Account (where the issues offset) are likely set up as the same Accounting Unit/Account/Sub Acct combo.

      This means that the GL Transaction exists, but it is debiting the same account it is crediting. Leaving a Net Zero.
      Tags: inventory control, issues, cost center, general ledger
      Mike Bernhard
      Veteran Member
      Posts: 101
      Veteran Member
      2/2/2018 3:33 PM
        Ben,
        Welcome to the group. IC21 is used to "issue" inventory from an asset (perpetual) location to a department. The item is NOT transferred to that department, but rather, the department will be charged for the item (i.e. item is expensed when you use IC21).

        To transfer between locations, you will use IC22/IC23.

        MORE DETAIL:
        When you issue in IC21, the item and quantity are decremented from the storeroom and expensed to the department that is entered on the IC21 transaction. The quantities are NOT going to show up in another location. (By the way, the department field is called ACCOUNTING UNIT in Lawson, and this value is typically assigned to the LOCATION, so when you select the LOCATION on the IC21.1 or IC21.2 screen the accounting unit is typically inherited from Location Setup)

        If your intention is to transfer inventory between storerooms, then you need to use IC22 to transfer the item/quantities from one location to another and then use IC23 to receive into the receiving location.


        (by the way, this entire write up is related to your comment that the item "...is not showing up in IC40 for that other location").  


        Hope that helps get you oriented.
        Tags: inventory control, issues, cost center, general ledger
        btaylor
        New Member
        Posts: 4
        New Member
        3/29/2018 7:24 PM

          Hey Mike - thanks for the response!

          Is there no way to have one transaction that both charges the department that it is going to, as well as transfers that item between locations?

          Thanks!

          Ben

          Tags: inventory control, issues, cost center, general ledger