Does anyone know / have a process what allows Adding, then Releasing AR to AP payments We have a few hundred transactions that needs to be interfaced, and manually doing the process takes too long. We are on LSF9, with 8.0.3 apps

Hi, I am new to Lawson, am barely using it a month and working in a department that are not entirely sure what they are doing either. I was wondering is there any way of running a detailed outstanding vendor statement for any given period In work I have been instructed to run an AP91.1 and drill into each transaction to see if invoices have been paid but this is time consuming and tedious. Is there a quick way of filtering that to see all outstanding items or have I simply been directed...

I'm new to Lawson, so please forgive me if this doesn’t make sense, or I'm leaving out information. I'm looking for a table that contains audit information on what account changes were made via GL20, GL00, GL30. One of the Accounting managers would like a count of every GL record update that is made to Lawson, preferably by the form updated, and which user updated it. He's just looking for a way to track how much work his people are doing. He specifically mentioned: Accou...

We are in the process of upgrading to 9.0, and have encountered the required UG11.1 fields. I was looking to see what everyone has benn populating in these fields and if they are keeping naming conventions identical to coding in the HR tables for names and descriptions

Has anyone ran across a table that lists Accounts Receivable of former employees that owe Cobra Premiums, Life Insurance Premiums, etc.

It is terrific to find a forum such as this. I am working for the executive leadership of a well known company that is going through some growing pains. They currently are using the unsupported version of Lawson for HR and Finance (modules were not installed properly according to client). Many of the major objectives of the finance department are dependent on the successful implementation of the supported version of Lawson (reporting, reducing monthly close, Sox compliance, etc). As a fin...

Hello, I am currently having an issue that when on any form if I hit CtrlShiftK on a form and then try to enter for example a new invoice on AP20 I am receiving an error that the invoice already exists. This is basically happening on every screen where you are trying to add something new after clearing the form. Has anyone seen this issue I currently have a ticket with Lawson open and continue to work on it with them...no luck yet in trying to figure it out. Thanks

Hi, Other than when making a payment using AP55 or on a system generated cheque is there any way of matching invoices and credit notes to clear them off an account

Does anybody use a good report for aged creditors. Thanks

Hello - I'm hoping someone out there has experience with using AP520 to create one-time vendors during invoice import process. My organization is working to consolidate refund requests from our patient accounting system with a file upload. While we do import invoices on a regular basis, we have not used the vendor auto-create function in the past. Both AP and accounting staff have concerns in the following areas... Duplication of existing vendors. It does happen even now, and is it th...

Hi!.. I would like to ask if there's a way to modify the output check file, so that i could add/delete data that is being pulled. Thanks is advance..

We plan to purge our vendor file of one-time vendors using AP300. We are on the Unix platform running Lawson version 8.0.3. We would like to know if anyone has experience with the AP300 and what your experience with this routine was. What problems, if any, did you encounter What were the benefits you gained from the purge

I tried running GL199 with limited close as the closing option. It gave me a report stating that the subsystem CB has not been closed for the period. So I ran CB190 and then CB195. The CB195 then gives me a report of 37 lines of unposted entries for the particular period. All transactions were of trans code DPT and has posted dates included in the report. I am at a total loss here so if anybody can help me, I would appreciate it.

Our Financial Acctg. mgr cannot seem to get GL190 to post entries. She gets the message “No journal entries detected for criteria given”. She relates that she has had this problem for several months, and has had to turn to her backup staff to run the jobs for her when all attempts fail. The other two have no problems running GL190, using the same criteria (dates and subsystems to access) that the manager has used. The mgr. usually runs the GL190 for some of the subsystems, such as AP and ...

We would like to pay our invoice thru credit card. I would like to hear any suggestion if you would have done in your company.

Can someone explain if there is a point where the financial calendar dates would get automatically updated (ie: closing last period in previous year, etc.) We've had an issue 2 years in a row where our finance department swears the calender is set up correctly for the new fiscal year and then the month and day for the new fical year periods magically revert back to the previous years month and day settings. As you can imagine, this causes grief since some periods had entries that could not be m...

Hello, this is my first time posting and I hope I am in the right forum. I am responsible for revising/correcting all invoices at my company and I am having a small issue for which I can't seem to find any documentation in my manuals. Is it possible to correct a bill rate on an invoice once it has been processed through the BR120 run in update I have only been able to correct bill rates if I add new transactions, but I cannot find where I can correct bill rates once revenue has been recogniz...

We are in the process of planning for an Asset Management implementation and I was wondering what the best practices are for determining at what point an asset is created and where Options seem to be at the Requisition, Receipt, PO or AP Invoice level. I suppose going directly to the AM module is also an option. Any insight would be appreciated. Thanks!

We just got the below response from Lawson regarding a number of our queries which stopped working. Has this issue effected anyone else if so how are you getting around the change. Using related tables in your criteria is no longer allowed. The only exception to this that you can use a single related field, and then it must be the only criterion. So you can use multiple criteria if they are not to related tables.

I posted a tip over on LGUG.net about automatically generating Total Names for a new year. Check it out. http://www.digitalconcourse.com/getdigi/dc4main.aspp=210&sp=7&ff=84&forum=1&thread=785&nt=1&ConfCode=lgugwebsite&dSeq=&tag=0

Hello all, I have created a recurring invoice which is attached to batch... I released the batch and ran AP193 in UPDATE = Y option. When I come back and inquire on the invoice... It throws an error that 'Invoice does not exist'. My Question Is there an place (form) where I can browse through my recurring invoices which I created Many thanks in advance. ********************* Regards Suresh

How do people clean up the COA We currently purge transactions after 13 months and balances after 7 years. Is there a way to identitfy the accounts that haven't been used in over 7 years and delete them from GL00 What steps are required to delete an account from GL00 Do you have to deactivate the account for all accounting units

Hi…  I am new to the Lawson and have a couple of question if someone in the group could answer them. The questions deal with finance GL entries and how to obtain financial information from the Lawson tables.  The information is specifically about the following: 1) All GL information in the GLMASTER table, but I also need the assets and the liabilities also. Please correct me if I am wrong, but I am not able to produce liabilities and assets from the GLMASTER. If not… where do I find this...

Question about the General Ledger period 0:   Does Lawson have a period zero in any form in the GL database tables I started using the GLAMOUNTS table, which has 1-13 periods, but not period 0.   Or.. Will I have to go back to the previous period and find out what the ending balance was and use that as period 0   Thanks..

Does anyone know if it's possible to create recurring payment in AP that recurs every other week  I can see options for monthly, weekly, etc..but not an option that would meet this need.  Is it possible to create others  If so how do you do that