PrevPrev Go to previous topic
NextNext Go to next topic
Last Post 02/02/2018 10:33 AM by  Mike Bernhard
Inventory Control Basics
 2 Replies
You are not authorized to post a reply.
Author Messages
Purchasing Specialist
New Member
(1 points)
New Member

Send Message:

02/02/2018 10:04 AM

    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!


    Tags: inventory control, issues, cost center, general ledger
    Kat V
    Sr Supply Chain System Analyst
    South Broward Hospital District
    Veteran Member
    (1997 points)
    Veteran Member

    Send Message:

    02/02/2018 10:31 AM
    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.
    Mike Bernhard
    Lawson Supply Chain Consultant
    Trident Edge Consulting
    Veteran Member
    (251 points)
    Veteran Member

    Send Message:

    02/02/2018 10:33 AM
    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.

    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 " not showing up in IC40 for that other location").  

    Hope that helps get you oriented.
    You are not authorized to post a reply.