Hello everyone,
Lawson newbie here. Not sure if this is the right thread to post this in, so I will move it if there is a better place. I am the systems analyst at a medium-sized children's hospital in California, and have been learning the ropes for the last 6 weeks or so. I happened to be hired on during a major investigation into a growing gap in the values of our inventory (through IC234) and the corresponding GL account. The IC234 value is consistently higher than our GL account. The differences (rounded) over the last 6 months are listed below:
Nov-16: $-24,800 Dec-16: $-10,500 Jan-17: $-68,200 Feb-17: $-68,900 Mar-17: $-67,000 Apr-17: $-137,200
As you can see, the changes have come in large spikes. It appears as though the MMDIST table and the GL align exactly, but we are still getting a drastically different value. We used to use IC24 for adjustment, but stopped that practice in January. This appeared to stabilize our issue, until April hit.
I am still pretty new to Lawson, so any help that you could give into the process of posting an IC transaction to the GL or what may be causing our issue would be greatly appreciated and would save us from a major issue. Thank you so much and have a great day!
If you have any questions, I will answer them as best I can!
We’re a large healthcare enterprise with many Inventories. Our daily process is to run IC130 at the end of the day (near midnight) followed by the IC233. Reconciliation between GL90 and the IC233 at that point should be very close (pennies or low dollars difference due to rounding).
In our experience most differences between GL and IC are due to user errors. Common issues include users Issuing Inventory (in or out) to either another Inventory or to itself (this would mean the Inventory is also built as a Requesting Location with RQ01 Accounting info populated).
One method to troubleshoot is to run IC220, export to csv and look for IS type transactions where the INV_ACCT_UNIT and INV_ACCOUNT are the same as the OFF_ACCT_UNIT and OFF_ACCOUNT. This scenario causes a net zero hit to GL while the IC appears to be correct.
Another issue is users manipulating IC142 created Requisitions by adding a Non Stock item. This would cause a hit to GL but not to the IC.