Hi, I seek help on pre-closing the fiscal year. Appreciate your help / guidance. Background: My client is having just one GL company and having sub-systems like AP, AR, AM , BR, CB and GL.  Currently they are following the period from 01-Apr to 31-Mar. They want to move on to 1-Jan to 31-Dec from Year 2009 onwards. Now that I need to close the current fiscal year (2008).  My client will close the GL Books only on 15-Jan and other subsystems will be closed by  end of December 2008.  After ...

I want to create a sql dataset based on the results from the AC90.1 Activity Anyalysis form. Can someone tell me what database tables are used for this

Does anyone have a list of Year End CTPs for AP and PR  We are on Lawson 9.0.0.4. and having trouble tracking down which CTPs we need to apply. Thanks

We closed AM190 by mistake and can we restore only the am from a backup

I currently have a project that is setup to record transactions to an expense account.  I need to allocate these costs, including the amounts from the RNI accrual, to other accounting units and accounts.  I have found a way for CA 10 to allocate actual costs to other GL account, but am having trouble allocating the RNI (PO 135) costs to the other GL accounts.  Any asisstance is appreciated.

we need to add the control code and in lawson I see Payer name- are they the same.

Is there a recommended way to process third party freight bills but keep the freight costs connected to the original POs and ordering centers  For example, a FedEx\UPS bill might contain 50 shipments for different vendors and PO numbers, where we asked the suppliers to ship on our account number rather than charge freight through their processes and carriers. What would be the best way to pay the invoice to the freight carrier but tie the individual package charges back to the associated vendor...

I accidently ran the RNI as an update in the middle of the month. Now the final RNI report doesn't tie to what has posted. Is there a fix for this

We are testing our transition from 8.0.3 apps/9.0.0.x environment to 9.0.1 apps and environment.  The error 'Tax rounding account not set up for company' is stopping the release of the batch on AP25.  There are 2 new tabs (9.0.1 apps) that were not on 8.0.3 (workflow and tax tolerance). Has anyone encountered this error - how is it repaired Thanks!

Has anyone implemented Asset Management in S3 We are in that process now and could use any advice you can offer. thanks.

If a check run was skipped, without looking at how old invoices are in the APInvoice table is there anyway to find out I'm familar with AP150, AP155, and AP170, I'm thinking since they are jobs its harder to find that info out. Bascially find out that it has been X number of days since a check run has been performed for a cash code and pay group. Any ideas. I really don't want to see all of the outstanding AP. Any thoughts will be greatly appreciated.

All Lawson Gurus, Thanks for having this forum, I was trying to find an environment/instance where I can actually see Lawson and do some testing to find how the product works. Could you please help me with any such instance where I can get access and test the product Financials (or activity and project accounting) Thanks

I am new to Lawson Guru and I am not sure of the protocol for asking questions. I am in the finance area and was wondering if you can run GLS995 GL Calculate Profit/Loss multiple times - or just once when all of the year end entries are completed.  My GLS215 did not close out the year end P&L to retained earnings so my opening balance in 2010 is off.  I beleive that GLS995 will correct this; however, I may have new entries once my year end audit is completed (adjust journal entries from the CPA...

Does anyone has a process on creating split distributions for prepaid expenses in the GL38 screen If so, do you have a process on how this works without closing Recurring Journal We do not want to setup a closing control for RJ and Lawson's documentation is not clear on what the process is after we add the entery in GL38. When do the transactions get posed to GL etc Thanks, Priya Saluja

Hi Has anyone found a way to make the old Project Activity codes as Inactive. I have setup a new status called IN and not assigned any of the tasks to it (in AC02 i think). Even put an end date However when in RSS we are still allowed to select that Activity We are on 8.1 0 MSP5, LSF 9.0.0.4 on Win 2003 with SQL2005 backend Regards Saurabh

Just curious if its possible, can you lock down changes to a vendor depending on what vendor class it is For example, if the vendor falls within an Employee Class, our Vendor Setup employee cannot make a change to the record.

I am new to Lawson GL and would like to combine information from the GL tables to look at the linkages between the various tables. Does anybody have a general query that shows the joins between the glmaster, clchartdtl, glchartsum, glchart, glnames, and glamounts. Thank you, Jerry

We are fairly new to Lawson and are trying to reconcile the RNI to the GL. Where is the best place to start:crazy:

Last week when i registered on Lawsonguru, I was able to access a link that gave me all documentation for all lawson products and I used it to do some analysis. But this week, I donot see that link and when I try to enter url directly it gives error message that I do not have access Does anyone know how do I get access to all those user manuals under documentation link Is there a specific setup required on my profile to access the documentation. Please reply ASAP, need some docs urgentl...

User is trying to run AP175 and gets this error - Cannot run for cpy 0003 - company run in progress. We see no jobs that are running/waiting. Any help would be appreciated. Thanks

I was wondering how many others use the GM module

I've been using Lawson for a grand total of 3 weeks and would like to know what I need to do in order to download the Microsoft AddIns for Lawson Out group has been typing journal entries directly into Lawson and I would like to convert this to an upload process. Thanks. Bob

Does anyone know what tables Lawson report writer accesses to provide average daily balances I have a report that was working just fine, then when we got to Febr 2010, the previous year adb's started coming up with a -0- in the YTD ADB for February 2009. Not sure if something got messed up in the tables or if there is something wrong with my report, even though I get correct amounts for all other columns on the report.

I keep getting this message (Must inquire before using this function code) when I try to upload to APCDISTRIB (AP52.3. I mapped the HK field but I do not see a hidden filed for the inquire.

We are on Lawson 7.2.23. The company is changing banks. Their checks require changes to the print format. We run a pretty 'vanilla' shop in terms of out Lawson apps. Do we need to change a print program or is there defined templates that needs changing The area of change will on the right side of the check-- adjusting where the numeric value of the check prints and shortening the length of textual amount of the check. Any pointers would be helpful and appreciated. Rebecca