401K

 5 Replies
 0 Subscribed to this topic
 68 Subscribed to this forum
Sort:
Author
Messages
sdk6150
New Member
Posts: 1
New Member

    We are looking into changing providers for our 401K.  Currently, the file is built from some old COBOL jobs.  We were wondering if there was a job we could run that would give us a lot of the info we need to send the provider.  We currently use the BN106 files as a starting point for our other benefit providers, but I was told this would not work for the 401K.

    How do you currently get the info you need for 401K providers?  The only other option I can think of would be trying to find the info in the Lawson tables.

     

    Thanks,

    Scott

    Phil Simon
    Veteran Member
    Posts: 135
    Veteran Member

      Yes, there are BN rpts like the BN231 that can get your started but, in all likehood, those rpts will not meet the specs of your new provider.  You can use any number of tools to generate an interface file that's in the format supported by the new provider.  Based on specs that I've seen for providers, all of the information that you need shoudl be in BENEFIT, EMPLOYEE, and PAEMPLOYEE.

      As for sending it out, I suppose that you could automate that as well.

      Phil Simon http://philsimonsystems.com/ phil@philsimonsystems.com
      John Henley
      Posts: 3353

        I typically create these as custom COBOL programs for Lawson clients, since the data required usually needs to come from both Benefits (for the elections/deductions and plan parameters) as well as Payroll (for the actual deductions taken).

        Thanks for using the LawsonGuru.com forums!
        John
        mcl
        Advanced Member
        Posts: 29
        Advanced Member
          John, Can you be a little more specific with the files(tables) from Payroll that hold the actual deductions taken? If this has been covered elsewhere, just point me in the right direction.
          John Henley
          Posts: 3353
            PAYDEDUCTN
            Thanks for using the LawsonGuru.com forums!
            John
            mcl
            Advanced Member
            Posts: 29
            Advanced Member
              Thank you. I am testing a selection based deduction code and date, using ODBC connection in a C# program. What's the deal with the date? I cannot figure out how to select say >= 9/1/2008 and <= 9/30/2008.