Initial Ledger data load

Sort:
You are not authorized to post a reply.
Author
Messages
jp
New Member
Posts: 6
New Member
    We are just starting the learning and data migration for M3/S3 etc. The Accounts people tell me they will soon have a chart of accounts loaded, but I am looking for how we load Opening balances, and journal postings from our legacy system, not having much luck.....We have licked the item master, customers etc pretty well, but this area is a bit more elusive.

    Anybody have any wisdom they could share in this area please?
    thanks
    jp
    jrbledsoe001
    Veteran Member
    Posts: 91
    Veteran Member
      JP,

      You'll be happy to know that loading historical entries in Lawson is fairly straight forward. On the Lawson Product Documentation downloads site you will find a Financial Conversion Manual as well as a spreadsheet which you can use to load data in GL65 GLTRANSREL. After you load the data into GL65 you will run GL165 in report mode to see if there are any errors.

      joanna.bledsoe@jhsmh.org
      jp
      New Member
      Posts: 6
      New Member
        Joanna,
        Thanks for the above, big help. Should I be looking in the same place for info on loading other financial stuff like unpaid invs to supplier, and unpaid customer invs?

        thanks
        jp
        jrbledsoe001
        Veteran Member
        Posts: 91
        Veteran Member
          JP,

          You are going to use AP510 for vendor balances (1099 stuff) and AP520 for unpaid vendor invoices. I would advise you to use import db for the major stuff and then learn to use the XL add in for the minor changes. This way when you go live your end users will already know how to use the add in for journal entries and invoices. Someone posted today in the XL add in forum a link to Lawson Professional Services (LPS) add in templates; http://solutions.lawson.com/lu/addins/main.htm.

          Your AR conversion instructions are in the Financial Conversion Manual.

          good luck

          joanna.bledsoe@jhsmh.org
          mark.cook
          Veteran Member
          Posts: 444
          Veteran Member
            Couple of points, you can load balances with the GL167 (Balance Conversion) or GL165 (transactions). Depending on how much data and the level of detail you may work with one or both of these.

            You may also want to look at the corresponding programs in activities should you use those for capital or project tracking.

            The AP info (1099) needs to be concidered in relation to the go-live date as jr mentioned above with the AP conversion programs. Some places I have been paid out the old system and only built new transactions in Lawson. You will have to do some make some business decisions around this but either if workable.
            Adam Jacobson
            Veteran Member
            Posts: 69
            Veteran Member
              You can also load balances using GL67/GLMASTREL.

              However, I would strongly urge you to convert everything as a journal entry. If/When you try to reconcile something years down the road, its nice to have transactions for everything rather than just a mysterious balance.

              Adam



              Adam Jacobson

              Red Three Consulting, Inc. - The reports you need from the software you already have.

              255 West 36th Street - Suite 1006 - New York, NY 10018

              Voice: 646-736-0060 x101

              Cell: 917-848-7284

              Fax: 646-365-3262

              adam@redthree.com

              www.redthree.com

              LinkedIn <http://www.linkedin.com/in/ajredthree>





              From: forums-s3-financials@lawsonguru.com [mailto:forums-s3-financials@lawsonguru.com]
              Sent: Monday, September 21, 2009 9:35 AM
              To: Adam Jacobson
              Subject: RE: Initial Ledger data load [00006610:00008861]




              LawsonGuru.com Logo <https://www.lawsonguru.com/>


              S3 Financials Forum Notification


              A message was posted to a thread you are tracking.

              RE: Initial Ledger data load

              Posted by: jrbledsoe001
              09/21/2009 09:35 AM

              JP,

              You'll be happy to know that loading historical entries in Lawson is fairly straight forward. On the Lawson Product Documentation downloads site you will find a Financial Conversion Manual as well as a spreadsheet which you can use to load data in GL65 GLTRANSREL. After you load the data into GL65 you will run GL165 in report mode to see if there are any errors.

              joanna.bledsoe@jhsmh.org

              ________________________________

              To view the complete thread and reply via your browser, please visit:
              https://www.lawsonguru.co...fc/8861/Default.aspx

              You were sent this email because you opted to receive email notifications when someone posted and/or responded to a message on this forum.
              To unsubscribe to this thread please visit your user profile page and change your subscription options.

              Thank you,
              LawsonGuru.com

              You are not authorized to post a reply.