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!