Prev
Next
Forums Supply Chain Management Lawson S3 Supply Chain

Automation of Month End Period End Valuation data file

 3 Replies
 1 Subscribed to this topic
 38 Subscribed to this forum
Sort:
Author
Messages
Mike Bernhard
Veteran Member
Posts: 101
Veteran Member
8/2/2016 3:23 PM

    Hello colleagues,

    I have a hospital client that is manually creating a month end inventory valuation report for their Finance department.  To create this report, the data analyst must first run the IC234 report, then he manually reviews the IC234 report to gather the value for each account, then he must type these values into MS Excel as a summary report.  

    I was thinking that this process could be fairly easily automated if these valuations are stored in any table in Lawson.  I have searched with no luck (including the ICHISTORY table), so here is my question

    Does anyone have any existing processes, or ideas, for how to automate this type of process?  I would love to hear from anyone with thoughts about how to accomplish this?

    THANKS!!

     

    David Williams
    Veteran Member
    Posts: 1127
    Veteran Member
    8/2/2016 4:47 PM
      Mike,

      Technically the data is in Lawson since the Period End Valuation report takes the current inventory value and backs into the period end value by calculating the inventory transactions that occurred since that period end date.

      Unfortunately the process would be difficult to replicate, but it could be done.

      Can the IC234 be saved to Excel (CSV)? It might not be pretty but you could build a macro in Excel to strip out the garbage you don't need.

      Personally, I'd build a ProcessFlow to load and parse the file. We use the tools we know.

      If they have an interface engine, they should be able to use it to get to the actual data they want.

      Whichever method they use, it has to be faster that manually keying the results every month.
      David Williams
      Kat V
      Veteran Member
      Posts: 1020
      Veteran Member
      8/2/2016 7:24 PM
        We run IC234 as part of month end close - it is saved as csv with no issues. If the report is run as "Totals Only: Y (Yes)" it will do exactly what you are describing - summarizes the value per GL Category per location.

        Corporate Finance uses it to recon the balance sheet accounts.
        Mike Bernhard
        Veteran Member
        Posts: 101
        Veteran Member
        8/3/2016 12:18 AM
          Thanks David and Kat. Both methods solve the problem. I will share both with my client tomorrow.