Initial Ledger data load

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

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

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

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.

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