PrevPrev Go to previous topic
NextNext Go to next topic
Last Post 03/29/2018 3:24 PM by  btaylor
Inventory Control Basics
 3 Replies
Sort:
You are not authorized to post a reply.
Author Messages
btaylor
Purchasing Specialist
Private
New Member
(4 points)
New Member
Posts:2


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!

    Ben

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


    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
    (257 points)
    Veteran Member
    Posts:87


    Send Message:

    --
    02/02/2018 10:33 AM
    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.
    btaylor
    Purchasing Specialist
    Private
    New Member
    (4 points)
    New Member
    Posts:2


    Send Message:

    --
    03/29/2018 3: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

    You are not authorized to post a reply.